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 sheet for each location. A View makes it easy to merge inventory data from all locations into a single, combined sheet.

How to Merge Multiple Sheets into One View

Start by adding a new View using the plus icon in the bottom left corner
All the sheets you own will be shown. Select which ones to merge into the View
Using the toggles, select which sheets you'd like to merge into the view
Click create to complete the process. 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; instead, it inserts all rows consecutively. Here’s an example:
Sheet Name (Region) VIN Car Manufacturer

Europe 1234 SUBARU

USA 5678 HONDA

ASIA 5678 HONDA

USA 1234 SUBARU

Sheet Name (Region)
Europe
VIN
1234
Car Manufacturer
SUBARU
Sheet Name (Region)
USA
VIN
5678
Car Manufacturer
HONDA
Sheet Name (Region)
ASIA
VIN
5678
Car Manufacturer
HONDA
Sheet Name (Region)
USA
VIN
1234
Car Manufacturer
SUBARU

Sheet Name (Region)	VIN	Car Manufacturer
`Europe`	1234	SUBARU
`USA`	5678	HONDA
`ASIA`	5678	HONDA
`USA`	1234	SUBARU

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 data, you must enable the Can Export permission in the user settings.

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:

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

File Extension: .html
Format Description: HTML (default when no extension provided)
MME Type: text/html

File Extension: .csv
Format Description: CSV (Comma-separated values)
MME Type: text/plain

File Extension: .json
Format Description: JSON (JavaScript Object Notation)
MME Type: application/json

File Extension: .xml
Format Description: XML (Extensible Markup Language)
MME Type: text/xml

Next Steps

Have a question about using the Views?

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

Was this guide helpful?

Ready to start scanning?

Get Started Book a demo