Import people into the CRM from a spreadsheet
Load a CSV straight into CRM fields, with a preview before anything changes.
You need to be a CRM manager. Save your spreadsheet as a CSV file first.
- In the portal, open CRM, press the gear (Setup), then Data.
- Under Import into the CRM, choose your file.
- Leave The first row is column names ticked if it is.
- Above each column, check what it fills, such as Full name, Email, Phone - mobile, Company, Lifecycle stage, Owner (email or name), Tags or one of your own properties. Pick - skip this column - to leave one out.
- Choose what happens to People already in the CRM: leave them alone, or fill their blanks and add tags.
- Optionally Tag everyone imported, and tick Start "person is added" workflows for them.
- Press Preview. It shows how many will be added, updated, skipped or can't be read.
- Press Import.
A Company column links each person to that company, and adds the company to the CRM if it isn't there yet.
Was this helpful?
