Tabidoo supports the import of the following formats:
If you want to create a completely new table in Tabidoo by importing from an Excel file, just follow this step:
How to import data from the Excel file to Tabidoo
If you have more than one sheet in your Excel file, all sheets will be imported into Tabidoo as separate tables. This means that if you have two sheets in Excel called, for example, "Customers" and "Orders". They will be imported into Tabidoo as two tables with the same names.
If you only want to update existing data in Tabidoo by importing from Excel, you need to do the following:
The import key column must not contain any duplicates. Otherwise, an error will occur when importing data.
The first field in the table is automatically preset as the import key field for the user.
Afterward, these options will appear:
Keep in mind:
To import only some selected columns from an Excel sheet, you simply need to delete all the columns in the Excel sheet that you do not want to import, leaving only the selected columns + the Import Key column.
Depends on the size of the Excel file - the number of columns and rows in the Excel and the complexity of the data (number of links, numerical series, calculated fields). The import can take from a few seconds to minutes.
However, if the import takes longer, it will be automatically processed in the background while you can get back to work and use Tabidoo freely.
Some data are calculated asynchronously (e.g. links, number series, calculated fields), which means that they will be automatically added to the data after import. Therefore, do not worry if they are empty immediately after import.
It is also possible to import from Excel sheet column data into ‘Link to table’ field type.
To import such data, you first have to make sure the data you will be importing are displayed in the grid. Eg. in the example below in a table Tasks, a task can be assigned to multiple users.
To see the list of the names of assigned users and enable import of the linked data set up the settings of the column Assigned To in the following way:
In the field Select fields for link, select the column you want to display in the grid, in this case Name. In the dropdown menu select List to display values of all the linked records - in this case all the names of the users assigned to the task.
When you then import data into the column Assigned To, you have to make sure that the name of the column in the Excel sheet is named exactly the same as it appears in the grid.
When importing multiple values, they have to be separated by the vertical line => |.
If you are not sure about anything, you can always export data from a table first and use the Excel sheet as a template to import additional data.