How to import data into Orca Scan

You can import your asset or inventory data into Orca Scan using a Microsoft Excel .xlsx file. Your data must be in the first sheet and include a Barcode column that contains a unique barcode for each row.

When a barcode is scanned from the mobile app, it will search your barcode column for a match, if it finds one the row data will be returned to the device.

1. Use an Excel file

At present you can only import .xlsx files - the default Microsoft Excel format.

2. Include a Barcode column

Ensure your sheet contains a barcode column so the system knows which columns to search through for a match.

3. Keep it clean

Your Excel file should not contain any irrelevant information such as logos or merged cells. Ideally, it should resemble the example below:

Selecting field types
Example of an Excel file ready for import

Troubleshooting

When I import a file, it clears away all the formatting on the fields?

Yes. The system doesn't yet recognize the structure of an imported file to match them so it will overwrite the existing content in the sheet and clear the history log.

Import error: "Failed to fetch"

Try reloading the browser and import the file again.

Import error: "Your spreadsheet must include a barcode column"

You need to add a column to the filed with the name "Barcode". You can always change this once the file is imported.

Next steps

Questions about importing files?

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