Excel and CSVs
Excel and comma seperated value files are common ways to store data. You can import these files to Zing via the Google Sheet importer.
All of these file types are supported:
- .xls (if newer than Microsoft® Office 95)
- First, import your (non-password-protected) file to Google Sheets:
- Ensure the first row contains headers.
- Every column to be imported must contain a header
- Header names must be unique within your sheet
- Exclude images, macros, tick-boxes, etc from your sheets prior to import
- Tap ‘share’ and set link visiblity set to ‘anyone with the link’. Once the sheet is imported you can revoke this permission if you wish.
Note that unlike all other data sources in Zing, Google Sheets imports are not ’live’ connections. That is, Zing takes a ‘snapshot’ of the sheet at the time of import but subsequent changes to the sheet will not automatically update in Zing. If you’d really like it to be a live connection, let us know.
- Then add the Google Sheet to Zing as follows:
Add a Google Sheet as a data source from the web:
Go to your Zing Data Web Console and ensure you are logged in
Tap the ‘data sources’ tab
Tap ‘Google Sheets’
Enter your Google Sheet URL. Your sheet’s link visiblity must be set to ‘anyone with the link’. Once the sheet is imported, you can revoke this permission if you wish.
Add the name of the table you’d like your sheet to appear as in Zing. This will be searchable in Zing so making this reflect what the table is about will make it easier to find and use.
Check for any warning messages which might indicate the sheet was incorrectly formatted
The data source you just added will be available to everybody in your organization.
Note that Google Sheets has some size limitations) on imports.