Merging sheets together

A View allows you to combine the data from multiple sheets into one. For instance, tracking inventory levels across multiple warehouses often requires a separate sheets for each location. A View makes it easy to merge the inventory data from all locations into one combined sheet.


1. Create a view

Start by adding a new View using the plus icon in the bottom left corner.

2. Select sheets to merge

All the sheets that you own will surface so you can select which ones to merge into the View.

Using the toggles, select which sheets you'd like to merge into the view
Using the toggles, select which sheets you'd like to merge into the view

When creating a View an additional column is added called Sheet name to show which sheet the data originates from.

The merge operation does not consolidate rows with duplicate barcodes but inserts all rows consecutively instead. Here’s an example:

Sheet name VIN Name Quantity
ASIA 5678 HONDA 14
USA 1234 SUBARU 7
USA 5678 HONDA 12
Europe 1234 SUBARU 9

Adding users

You can share your View with other Orca Scan users to help manage or export the data from their own web accounts. To allow users to export the data, you must enable the Can Export permission.


Exporting data

You can download the data in multiple formats directly using the Export button from the toolbar. Business plan users can also use the Live Data URL to connect a View to external systems such as Microsoft Excel or Microsoft Power BI, or use a simple HTTP GET request to pull the data using a script.

Live Data URL formats

You can change the format of data exported from the Live Data URL using the following extensions:

Extension Content/Type Format
.html text/html HTML (default when no extension provided)
.csv text/plain CSV (Comma-separated values)
.xml text/xml XML (Extensible Markup Language)
.json application/json JSON (JavaScript Object Notation)

Have a question about using the Views?

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

Ready to start scanning?