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.
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:
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.
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:
|.html||text/html||HTML (default when no extension provided)|
|.csv||text/plain||CSV (Comma-separated values)|
|.xml||text/xml||XML (Extensible Markup Language)|
Most popular integrations
- How to scan barcodes into Microsoft Excel
- How to scan barcodes into Google Sheets
- How to visualise barcode data with Power BI
- How to visualise barcode data in Data Studio
- How to visualise barcode data in Tableau
Have a question about using the Views?
We’re always happy to help, chat with us live or drop us an email.