How to scan barcodes into Microsoft Excel

Requires subscription plan

You can create a real-time link between Orca Scan and Microsoft Excel by creating an Orca Scan cloud sheet. Data entered from the Orca Scan app will then be pushed directly into your Excel Spreadsheet from anywhere in the world.

To get started, to your Orca Scan account and create a Cloud Sheet. Once you've done that, use the following 4 steps to set up the connection.

  1. Get the export link from your Orca sheet
  2. Navigate to the Get Data section in Excel
  3. Paste the export link
  4. Set the import frequency

1. Get the export link from your Orca sheet

Click Settings on the Sheet you want to set up

Orca Scan cloud sheet settings

Activate and copy the link

Copying the Orca Scan unique sheet URL

Now, over to Microsoft Excel...

2. Navigate to the Get Data section in Excel

Find the Get Data menu Hover over From Other Sources, and click From Web

Navigating to the Get Data section in Excel

3. Paste the export link

The window below will surface - now paste the link from Orca Scan

Pasting the Export link in Excel

Connect with anonymous access (advanced: configure if needed)

Connecting Orca Scan export link to the Excel spreadsheet

Click Load

Microsoft Excel loading Orca Scan data

4. Set import frequency

You can configure how often Excel pulls data from Orca Scan.

Click the Refresh button to do it manually, as seen here:

Showing configuration for how often to pull scanned barcodes into Excel

That's it!

Your Excel spreadsheet will now mirror everything in your Orca Sheet. So if you add, update or delete a row inside Orca Scan, Excel will pull them changes into your Excel Spreadsheet.

Showing all scanned barcodes in Excel

Important: Clearing your Orca Sheet will also clear the data from your Excel Spreadsheet.

Questions?

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

Create a free account

No credit card required