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.
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 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.
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
|.html||HTML (default when no extension provided)||text/html|
|.csv||CSV (Comma-separated values)||text/plain|
|.xml||XML (Extensible Markup Language)||text/xml|
Most popular integrations
- Microsoft Excel Automatically send data to Excel spreadsheets
- Google Sheets Automatically send data to Google Sheets
- Microsoft Power BI Transform and visualize your data with Power BI
- Google Data Studio Build dashboards and reports with Data Studio
- Tableau Analyze and understand your data with Tableau
Have a question about using the Views?
We're always happy to help, chat with us live or drop us an email.