How to scan a QR-code from webcam to Excel or Google spreadsheet in real-time. Also, how to scan a regular barcode from webcam to Excel or Google spreadsheet in real-time.
(Note: The ZBarSpreadsheet software in this post is free. In another article I wrote about QuickMark which is a different program that works with Excel but not with Google Spreadsheet.)
UPC barcodes appear on grocery store items and retail packaging. Code39 barcodes are the type that appear on UPS and Fedex shipping labels and on boxes for inventory control. Two-dimensional codes, the kind with "dots" such as the QR-code, are most often used to transfer information from the QR code to a smartphone, tablet or some other mobile device. However, when you use this webcam program to scan either a barcode or a QR-code the data is typed into Microsoft Excel or a Google spreadsheet (or other program) in real-time.
Why you might want to use a QR code for data capture:
ZBar is an "open source" (FREE) program for reading bar codes from webcams, video streams, and image files. ZBar reads the most popular types of bar codes including the QR codes, UPC codes and Code 39 bar codes. ZBar is small, fast and takes little memory.
ZBarSpreadsheet is a small program that works with ZBar to automatically type, in real-time, any scanned data into a spreadsheet or other program. ZBar Spreadsheet terminates each scan with a "down arrow" keystroke to advance to the next row of the spreadsheet.
First, download and install ZBar bar code reader from this direct link
Then, download ZBarSpreadsheet ZIP file from this direct link and follow the steps below:
ZBar and ZBarSpreadsheet work from a Command Window (CMD).