Import Data into an Existing Table

You can import a CSV file, a JSON file, or an XML file with tabular data, or copy the cells from a spreadsheet and paste the table data.

Note that importing additional data into an existing table is different from importing a new table into your database. To create a new table from import, view this article on how to import a CSV file, a JSON file, or an XML file with tabular data into a database.

For other import options, please see these articles:

• Create a new table from an import
• Import Airtable to Baserow

Import additional data into existing tables

To import a file into an existing table, open the table where you want to import your data.

1. Click on the ellipsis ••• beside a view to open your view settings.
2. Select ’Import file’
3. Select the file type you would like to import and click ‘Import’

The columns of the Baserow fields will be automatically mapped to the correct fields in your table. You can change the mapping by choosing the desired target field, or use the mapping to manually set up the logic of which fields to merge and where. Any incompatible cell will remain empty after the import.

Tip 💡 Toggle between the Import Preview and File Content preview to compare the logic of which fields to merge and where.

The file importer can import to link row, single select and multiple select columns and automatically set them up with links or options.

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!