Import Data from CSV

You can either create a new table from scratch that is created based on CSV data or, import CSV data to an existing native table.

Create a New Table from a CSV File

The table will be created based on the columns inside the CSV file. Upon creation, the data from that CSV file will be imported.

Update Existing Native Table with CSV

You can manually update your table by importing data from a CSV file. This option is accessible in More Actions on your TaskBot page.

It is also accessible on the tables list page https://creator.zerowork.io/datagroups as well as inside the table itself in More Actions.

Column matching

Whenever you import data from a CSV file to an existing table, make sure that the column names in CSV match the column names in your table.

If some columns are not matching, the table will still be updated but non-matching columns will be left out (ignored).

Sequence of columns in CSV versus your table does not matter.

Name of the file name versus table name does not matter either.

Column matching is not case-sensitive.

The data is always appended, unless you check this checkbox. 👇

Checkbox "overwrite current data"

By checking this checkbox, the current data in your table will be overwritten by the data from CSV. The existing data in your table will be permanently deleted. If you want to secure your data before overwriting it, you can simply Export Data as CSV first. If left unchecked, per default, the data would be appended. This means that the data in your table would be "merged" with the new data from your CSV.

How to Import Data from a CSV File to a Google Sheet?

Google Sheet allows you to import data from a CSV file, too. Simply click on File -> Import inside your Google Sheet. If you are not sure how to do this, check this guide where you'll find some screenshots: External Link - How to Import CSV to a Google Sheet.

Last updated