To connect the barcode scanner to the excel sheet. Open Microsoft Excel and then make a new spreadsheet. Select Data tab and choose From Other Sources. Choose From ActiveX Control. Click Barcode in the list of controls and then select OK. Then position the cursor wherever the barcode is to be displayed click OK. Scan the barcode and the data will appear on your Excel spreadsheet.