How do I update existing data using an import?

In this article, we share general information on how to update existing data using an import.

If you want to update data that already exists in one of your tables using an import, this article section will show you the steps: Importing Records.

There are two important items in that article section to pay attention to:

  1. To update existing records, you will need to identify a column in your file with unique values that help to identify which records should be updated in your table.

  2. If a matching record isn't found in your table, a new record will be created instead. This is a great shortcut for importing both new records and updating existing records using a single import.

When importing to update existing data, you do not need to include all the fields in your table within the import file. You can include only the fields you want to update in your import file, plus the field that you will use for matching (identifying which records to update).