> ## Documentation Index
> Fetch the complete documentation index at: https://help.reevo.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Update Existing Records via CSV

> Learn how to update existing contacts, accounts, and opportunities in bulk by importing a CSV file through your Reevo account team.

# Overview

You can update existing records in Reevo in bulk by importing a CSV file. This is useful for correcting field values, filling in missing data, or syncing information across a large set of contacts, accounts, or opportunities without making changes one at a time.

Reevo needs a way to identify which records to update. You can either provide Reevo's own record ID for a precise one-to-one match, or use a recognizable field so Reevo can find the right record automatically.

## Before You Begin

Before starting your import, reach out to your Reevo account team to coordinate. Reevo reviews all CSV imports before processing to ensure data quality and accurate field mapping.

<Info>
  **New accounts:** During onboarding, an approval lock is active on all data imports. Once you submit an import inside Reevo, a member of the Reevo team reviews it before processing. This ensures your initial data is mapped and formatted correctly. The approval lock can be removed at any time upon request, after which all imports you submit will process automatically without Reevo review. As part of onboarding, Reevo can also handle your initial imports end-to-end if you share your CSV files directly.
</Info>

# Step-by-Step Instructions

## Option 1 - Update by Reevo Record ID

This is the most reliable method and works for all object types - contacts, accounts, and opportunities. Because the Reevo Record ID is unique to each record, there is no risk of Reevo matching the wrong one.

1. Navigate to the relevant object view - **Contacts**, **Accounts**, or **Opportunities**.
2. Click **Export** to download your records. The exported file will include a **Reevo Record ID** column for each record.
3. In the exported file, add columns for the fields you want to update and fill in the new values. Do not modify the Reevo Record ID column.
4. Share your prepared file with your Reevo account team. They will review the mapping and submit the import on your behalf.

**Important notes:**

* This mode only modifies existing records - it will not create new ones. Any rows where the Reevo Record ID does not match an existing record will fail.
* This is the only supported method for updating opportunities.

## Option 2 - Update by External Identifier

Use this method when you do not have Reevo Record IDs available. Reevo matches records using a recognizable field from your CSV. This option is available for contacts and accounts only.

1. Prepare your CSV with one of the supported matching fields for your object type (see table below), plus columns for the fields you want to update.
2. Share your prepared file with your Reevo account team. They will review the mapping and submit the import on your behalf.

**Matching fields by object:**

| Object      | Matching field               |
| ----------- | ---------------------------- |
| Account     | Domain name OR Account name  |
| Contact     | Primary email                |
| Opportunity | Not supported - use Option 1 |

**Important notes:**

* This mode will create new records for any rows where no match is found. If you only want to update existing records without creating new ones, use Option 1 instead.
* For contacts, matching is done by primary email only. Make sure email values in your CSV exactly match what is stored in Reevo.
* If your data contains duplicates, Reevo uses the first match found. Review your data for duplicates before sharing your file.

# Troubleshooting / FAQs

<AccordionGroup>
  <Accordion title="How do I get the Reevo Record ID for my records?">
    Export your records from the relevant object view using the **Export** button. The exported CSV includes a Reevo Record ID column for every record.
  </Accordion>

  <Accordion title="Some of my records failed to update. Why?">
    In Update mode, any row where the Reevo Record ID does not match an existing record will fail - it is not skipped silently. Check that your IDs were copied from a recent export and have not been modified. In Upsert mode, check that your matching field values exactly match what is stored in Reevo.
  </Accordion>

  <Accordion title="Why can't I update opportunities by external identifier?">
    Opportunities do not have a unique external field that Reevo can reliably use for matching. Use Option 1 with the Reevo Record ID to update opportunities.
  </Accordion>

  <Accordion title="Will a blank cell in my CSV clear the existing field value?">
    No. If a column is present in your CSV but a cell is empty, Reevo skips that cell and leaves the existing field value unchanged. To intentionally clear a supported field, enter `REEVO-UNSET` in the cell. Reevo will treat this as an explicit instruction to blank the field.
  </Accordion>

  <Accordion title="Will this overwrite values I did not include in my CSV?">
    No. Only the fields included as columns in your CSV will be updated. Any fields not present in your file will remain unchanged.
  </Accordion>

  <Accordion title="Can I update custom fields?">
    Yes. Custom fields appear in the field mapping step and can be updated using either method.
  </Accordion>

  <Accordion title="Can I undo an import?">
    There is no automatic undo for imports. Your Reevo account team will review your file before processing, but it is still good practice to test with a small sample first.
  </Accordion>
</AccordionGroup>