Multiple rows in the CSV refer to the same participant data upload error

Fixing “multiple rows in the CSV refer to the same participant”

Click here for a complete list of contact upload errors and how to fix them!

If your contact upload fails with the error “multiple rows in the CSV refer to the same participant”, it means more than one row in your CSV has the same customer_id. Message expects each participant/contact to have a unique ID in the file.

Step 1: View which rows are causing the issue

1. Open your import history and click the failed import.

2. Click View Errors.

3. Note the customer_id shown in the error and the row numbers (if provided).

Step 2: Decide which situation you have

Option A: The rows are true duplicates (same person twice)

Ask: Do the flagged rows contain the same contact information? (same name, email, etc.)

Fix:

1. In your spreadsheet, find the duplicate customer_id.

2. Delete one of the duplicate rows.

3. Save the file as a CSV.

4. Re-upload.

Option B: One customer_id was assigned to two different people

Ask: Do the flagged rows look like two different contacts (different name/email), but they share the same customer_id?

Fix:

1. Determine the correct customer_id for each contact using your source records/system of record.

2. Update the CSV so each contact has the correct, unique ID.

3. Save as a CSV and re-upload.

Quick check before re-upload

• Sort or filter the customer_id column and confirm no ID appears more than once.