How to scan barcodes into Google Sheets

You can create a real-time link between Orca Scan and Google Sheets by creating an Orca Scan cloud sheet. Scanned barcodes and data entered from the device will then be available in your Google Sheet - removing the need to import/export data.

If you've not done so already, log in to your online Orca Scan account and create a Cloud Sheet. Once you've done that, use the following 3 steps to connect your sheet.

1. Get the export link from your Orca sheet
2. Add the IMPORTDATA formula
3. Paste the export link

1. Get the export link from your Orca sheet

Click Settings on the Sheet you want to set up

Activate and copy the link

Now, over to Google Sheets...

2. Add the IMPORTDATA formula

Place the curser in the A1 cell and add the =IMPORTDATA=( formula to the first cell of your sheet.

3. Paste the export link

Now add the export link from Orca Scan within the brackets =IMPORTDATA("replace-with-your-orca-sheet-url-here.csv") - be sure to include the quotation marks!

Hit enter and wait for your data to load.

That's it!

You're done. Your Google Sheet will now mirror everything in your Orca Sheet. So if you add, update or delete a row inside Orca Scan, Google will automatically pull them changes into your Google Sheet.

Important:

• Google pulls data from your Orca Scan every 60 minutes.
• Clearing your Orca Sheet will also clear the data from your Google Sheet

Questions?

We're always happy to help, simply chat with us live or drop us an email.