Merging data from multiple sheets with Views

A View acts as a virtual table to combine data from multiple sheets.

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 database.

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.

Showing the selection of sheets to merge into a 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
Europe 1234 SUBARU 9
USA 5678 HONDA 12
ASIA 5678 HONDA 14
USA 1234 SUBARU 7

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.

Showing the user dialog to add users to a view

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

Extension Format Content/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

Most popular integrations

Have a question about using the Views?

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