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:

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.
  4. To update existing records with imported data when matches are found, put a checkmark next to the option “Update rows if they already exist.” If not checked, all rows will be imported as new records, regardless of potential duplicates.

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.

To update existing records, put a checkmark next to the option “Update rows if they already exist.”

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

enter image description here

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.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.