Updating your CSV lets you overwrite incorrect values, remove unwanted data, or correct fields that were placed in the wrong columns. Once re‑imported, the mapped fields are updated immediately in your account, blank values remove existing data, and your corrected details are available straight away for personalisation, segmentation, and automation.
What you can do
Update the affected columns in your CSV file.
Re‑import the file and map each field correctly.
Overwrite your existing data with the corrected values.
If only a few fields need fixing, create a CSV with just the Email column and the fields you want to update. This overwrites only the mapped fields.
1. Edit your CSV file
Open your CSV in Excel or another editor.
Find the columns that were mapped incorrectly.
Adjust the data as needed:
Correct any values that were placed in the wrong column.
Move or rename the column headers so they match the Dotdigital data fields you intend to map.
Save your file in CSV format.
To remove values from a data field, leave the cells blank and map the column during import.
2. Import your corrected CSV file
Go to Audience > Contacts.
Select Import contacts.
Choose your updated CSV file.
If asked, select Unicode (UTF‑8) as the encoding.
Continue to the Data mapping step.
3. Map your data fields correctly
During the mapping step:
Map each CSV column to the correct Dotdigital data field.
Map Email to Email Address so Dotdigital can match and update existing contacts.
If you see columns you don’t want to update, set them to Skip column.
Correct mapping ensures that only the fields you specify are updated and prevents accidental data changes in other fields.