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.
Start by adding a new View using the plus icon in the bottom left corner.
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:
Sheet name | VIN | Name | Quantity |
---|---|---|---|
ASIA |
5678 | HONDA | 14 |
USA |
1234 | SUBARU | 7 |
USA |
5678 | HONDA | 12 |
Europe |
1234 | SUBARU | 9 |
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.
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) |
We’re always happy to help, chat with us live or drop us an email.