Data can be imported into a table from an Excel spreadsheet (.xlsx) or a comma-separated file (.csv).
It is assumed that the first row in the spreadsheet contains headings and is therefore not included in the import.
The table determines how many columns are imported from the spreadsheet. For example, if there are 3 columns in the table and 5 columns in the worksheet, imports will only include the first 3 columns in the spreadsheet.
The import function synchronizes the table so that the contents match the data contained in the spreadsheet.
The import function uses the first column as the ID column. If a spreadsheet contains a row where the contents of the first column match the contents of the first column in one of the table rows, that row will be updated in the table with the contents of the remaining columns in the spreadsheet.
If the spreadsheet contains a row where the contents of the first column do not match the contents of the first column in any of the table rows, a new row will be created in the table.
If the table contains a row where the contents of the first column do not match the contents of the first column in any of the rows in the spreadsheet, that row will be deleted from the table.
How to do it:
•Select Settings in the settings menu

•Click on Reports / Tables under the desired organization in the left menu

•Click the Table that data should be imported to
•Click Settings
