Using IntelliScanner barcode readers with Excel

Getting Started

Microsoft Excel and IntelliScanner readers integrate easily. IntelliScanner Pro and Scanabout Pro are designed to work with many applications without additional configuration. Both models perform direct keyboard emulation – meaning they function in the same way as a keyboard and type out the barcode number they read into whatever application your cursor is active in.

Your IntelliScanner can also be used when trying to find data in Excel, for instance. Simply launch the find function (Ctrl+F or select “Edit” and “Find” from the menu bar in Excel) and scan a barcode into the “Find What:” field.

Integrating your IntelliScanner with Excel

Integrating your IntelliScanner with Excel is quick and easy. All of our small-business barcode readers - IntelliScanner Pro and Scanabout Pro - are designed to work with Excel (and many other applications) without additional configuration.

IntelliScanner Pro advanced configuration. If you are using an IntelliScanner Pro (tethered USB model), there is no setup necessary – simply plug it in and start scanning away. One function you may want to utilize is to change the end-of-text character. By default, the IntelliScanner Pro types a carriage return (CR) after each scan. When using it with Excel, you may want to change the end-of-text character to “tab” to the next column - here’s how to change the end-of-text character to a tab.

Scanabout Pro advanced configuration. First, make sure you’ve paired your Scanabout Pro with your computer. One function you may want to utilize is to change the end-of-text character. By default, the Scanabout Pro types a carriage return (CR) after each scan. When using it with Excel, you may want to change the end-of-text character to “tab” to the next column - here’s how to change the end-of-text character to a tab.

Examples

We’ve included some simple Excel examples below. In these Excel examples, we are associating a barcode with a record in the spreadsheet. Using our preprinted Asset Tags, I’ve attached them to the items, scanned the number into the spreadsheet and filled in the detail information.