Import table data to an existing table

You can use a wizard in the Table Browser tool to import table data to an existing table.

Prerequisites

You have an existing table configured from the Table Definition tool.
Your CSV file has headers, as a set table structure is imported to a table with a predefined table definition.

Select Import and select Existing in the dialog that opens.
In Use Existing Table, select an existing table from the Table dialog.
To delete all rows from the existing table before uploading data, select Delete all rows from table before uploading data.

You cannot undo the deletion of rows from an existing table when importing new table data.

Result: The Import wizard opens at the Data Type step.
In the Data Type step, select between the data types CSV and JSON, and select Next to go to the Upload step.
1. If you select CSV, in the Upload step, do the following:
  1. Browse for a CSV file on your computer.
  2. In Data Separator, select between Automatically detect delimiter (default), . (Comma), ; (SemiColon), | (Pipe).
  3. If the CSV file has a header row, select CSV file has header row.
  4. If you want to import table data IDs, select Import id.
  5. Select Next.
2. If you select JSON, in the Upload step, do the following:
  1. Paste your JSON code into the wizard.
  2. Select Next.
Result: The Data step opens.
In the Data step, you can modify cells of columns and rows with free-text changes, if necessary.
Select Import.

Result: The Import Data step opens and a message appears, informing that the table data was successfully imported.
Select Complete.