How to merge multiple sheets into one view

An Orca View acts as a virtual table, allowing you to combine the data from multiple sheets into one.

For instance, tracking inventory levels across multiple warehouses often require 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:

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

Adding users

You can now share your View with others to manage or export the data from their own web accounts.

When adding users to your View, you can activate the Can Export permission as seen below. If turned off, the data will appear as read-only.

Add users to the view and decide whether they can export the data within it
Add users to the view and decide whether they can export the data within it

Exporting data

You can download the data in multiple spreadsheet formats directly from the export menu. As a Business plan user, you can also use the Live Data URL to connect to external systems like Excel or PowerBI using simple HTTP GET requests.

All URL export formats

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

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?