Import data into an existing table
Importing your data can be useful for taking action in Baserow. By understanding the different fields that can be imported, you gain valuable context to make the most of your data. Learn more about fields in Baserow.
This article will cover the step-by-step process to effortlessly import data into an existing table.
Overview
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 ways to create a Baserow table, please see these articles:
- Start with a new table
- Duplicate an existing table
- Paste table data
- Create a new table from an import.
Import additional data into existing tables
To import a file into an existing table, open the table where you want to import your data.
- Click on the ellipsis ••• beside a view to open your view settings.
- Select Import file.
- 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.
Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.
Contact support for questions about Baserow or help with your account.