Skip to main content

Import CSVs into Retool Database

To import existing CSV-formatted data, drag a CSV file onto the drop zone. Convert your file to a CSV before you upload it, as XLSX files are not supported. Once you upload a file, Retool attempts to identify the type for each field and map it to an appropriate field type to create a table schema.

New CSV import

You have the opportunity to review and make changes to the new table schema in the Schema mapping section before importing data. You can change field names and types, drag fields to change their order, or remove certain fields from being imported by clicking the X button.

You can also configure how imports are processed using the Import settings section.

  • Column heading: Use the first record of CSV-formatted data to set field names.
  • Create a primary key: Create a primary key field for imported data (recommended).
  • Use a CSV column: Select an existing CSV field to use as the primary key. This is useful if you are importing data with an existing primary key (e.g., id). If turned off, Retool creates a new primary key field and sets values.