QRcodesHowTo.com – QR Code Examples & Tips

QR codes to Excel Spreadsheet in Real-Time (Quickmark)

How to scan a QR-code into an Excel spreadsheet in real-time with your computer’s webcam. Also, how to scan a regular barcode into an Excel spreadsheet in real-time with your computer’s webcam.

 


wpid1114-media_1331324755990.png

 

Why import QR codes to an Excel Spreadsheet?

Quickmark QR-code scanning software has a couple of important limitations: The keyboard output feature works with MS Excel but not Google spreadsheet (because it sends an [Enter] key after each scan instead of the [DownArrow] whic h is needed for Google Spreadsheet. Also, the Quickmark program’s keyboard output works only in (unusable) demo mode unless you upgrade to the "Advanced version" for $9.99.

************************************************************************************
UPDATE: HERE IS A PROGRAM THAT IS BETTER THAN QUICKMARK:
ZBarSpreadsheet is a FREE program that can also scan QR-codes from webcam to spreadsheet in real-time. ZBarSpreadsheet works with both Excel and Google Spreadsheet. You can read more about it at this link.
************************************************************************************

This article is written about QuickMark_PC version 3.8 downloaded on 3/9/2012. There are a few minor quirks to overcome before you can use it:

  • Your computer’s screen resolution must be set to 96dpi, which is the Windows default. If you use a screen resolution greater than 96dpi then some of the Quickmark menu options and buttons won’t be visible.
  • The Quickmark installation download is a .RAR file (not a ZIP). You’ll need another program, such as 7-zip, to open it. The download file is probably a .RAR file because Quickmark is a Taiwanese company where RAR is a more popular than .ZIP.
  • You’ll have to install the Microsoft .NET Framework if you don’t already have it installed.
  • The Quickmark "Advanced" version is required to send output to the keyboard and Excel. It is only $9.99 and can be purchased here
  • You’ll find QuickMark’s System Requirements at this link
 

Quickmark > Settings

  1. Start the Quickmark Program from your Windows Menu
  2. Click anywhere on the QuickMark program screen to activate it it.
  3. Click the gears in the lower right corner, or press F5, to display the Settings screen

wpid1117-Quickmark__Settings.png

 

Quickmark > Settings > General

Configure the General settings before your first scan:

  1. Select the "General" tab
  2. Confirm that "English" is selected (Quickmark is a product of Taiwan)
  3. Confirm that the correct webcam is selected in the "Device" section.
  4. To save each scan without having to manually acknowledge it, select in the "Scan History" section the "Auto save on scan." option.
  5. To save each scan to a text file, select in the "Scan History" section, "Save to text"
  6. Click the "Ok" button.

wpid1119-Quickmark__Settings__General.png

 

QR code to Excel Spreadsheet – Keyboard Mode

To capture the scanned data to a TEXT FILE and also automatically type the scan data into Excel or a another program:

  1. Click the "Settings" gear on the main screen (or press [F5]) to display the Settings dialog.
  2. Click the "Action" tab
  3. In the "Scan Result Output Mode" section, select "Keyboard Input"
  4. Also select the "+Enter" checkbox so that the [Enter] key is automatically pressed after the scan data is sent to the keyboard.
  5. Click the "Ok" button

Note: the data from any barcode or QR-code you scan will be also saved to the file and folder below:
C:\Program Files (x86)\SimpleAct\QuickMark\ScanHistory.txt

QR-code Excel Spreadsheet Setup:

  1. Start Microsoft Excel
  2. Click the cell where you would like the QuickMark program to begin typing the data
  3. After you scan each barcode or QR-code, the data will be typed in the cell and the [Enter] key will automatically be pressed, activing the cell in the next row for the next scan.

wpid1116-QR_code_to_Excel_Spreadsheet_-_Keyboard_Mode.png

 

Quickmark > Settings > Action > Standard (non-keyboard) mode

To capture the scanned data to a TEXT FILE — but NOT automatically type the data into Excel or a another program:

  1. Click the "Settings" gear on the main screen (or press [F5]) to display the Settings dialog.
  2. Click the "Action" tab
  3. In the "Scan Result Output Mode" section, select "Standard"
  4. Click the "Ok" button

After changing these settings, the data from any barcode or QR-code you scan will be saved to the file and folder below:
C:\Program Files (x86)\SimpleAct\QuickMark\ScanHistory.txt


wpid1118-Quickmark__Settings__Action__Standard___non-keyboard__mod.png

 

QR code data in Excel File


wpid1115-QR_code_data_in_Excel_File.png

1 Response to "QR codes to Excel Spreadsheet in Real-Time (Quickmark)"

I’ve shared this tool and data with our friends at http://www.facebook.com/QuickResponseCode. Please feel free to post any of your QRC related writings with there on that page.
Best regards,
Jeff Nix @ http://www.facebook.com/QuickResponseCode

Leave a Reply

Your email address will not be published. Required fields are marked *

Free QR Code Generator QR Code Help

Written by