How to scan barcodes into Microsoft ExcelEnterprise feature
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, log in 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.
- Get the export link from your Orca sheet
- Navigate to the Get Data section in Excel
- Paste the export link
- Set the import frequency
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 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
3. Paste the export link
The window below will surface - now paste the link from Orca Scan
Connect with anonymous access (advanced: configure if needed)
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:
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.
Important: Clearing your Orca Sheet will also clear the data from your Excel Spreadsheet.
We're always happy to help, simply chat with us live or drop us an email.