Skip to main content

​
Importing a CSV

Import a CSV straight into a table. If you’re unsure of the expected shape, export a template first and fill it in, which avoids most import failures.
If a CSV can’t be parsed, the import fails rather than importing part of it. Check that headers match your fields and that the file is genuinely comma-separated.A table holds 10,000 records by default. A file with more rows than the table has room left for still imports, but only up to that limit and the remaining rows are dropped without an error, so check the record count afterwards.

​
Importing a JSON template

A JSON template holds a table’s fields and, optionally, its records. To get one, use Export Template on a table. Import it from the tables list to create a new table, or from inside a table to replace that table.
Importing a template into an existing table deletes all of its fields and records, then rebuilds it from the file. There’s no undo.
Activepieces checks the file before changing anything. If the file doesn’t match the format below, the dialog shows which column or part of the file is wrong and nothing is imported.
Each column’s type must be one of these: The table and every column need an externalId. A cell’s value is only imported when its fieldId matches a column’s externalId. A row whose cells match no column is imported as an empty record. Rows beyond the table’s record limit are dropped.

​
Exporting

  • Download data from the table, for a spreadsheet or a backup
  • Download table data as a step inside a flow, when you want it on a schedule

​
Backups

Table data lives in your Activepieces database. If you self-host, it’s covered by your normal database backup, see Self host. A periodic CSV export is a cheap extra copy for the tables you’d hate to lose.