How to Import Contacts from a Spreadsheet (CSV)
Typing contacts in one by one is fine for practice. But if you already have a list — from a phone, an old CRM, or a notebook turned spreadsheet — you can load them all at once with an import. This guide uses a CSV file, which is just a simple spreadsheet format that every spreadsheet app can save.
What you need before you start
- A spreadsheet with one row per person and separate columns for first name, last name, email, and phone.
- The file saved as CSV. In Google Sheets: File → Download → “Comma-separated values (.csv)”. In Excel: File → Save As → CSV.
- Permission to contact these people. Only import people who gave you their details.
The steps
-
Open Contacts
Click Contacts in the dark sidebar on the left edge of your screen.
-
Find the import button
Look at the row of small icons near the top of the contact list. Click the one that looks like a little upward arrow coming out of a tray (hover it and it says “Import Contacts”).
-
Upload your CSV file
Click the upload box, pick your CSV file, and click Next. The system reads your file and shows a preview.
-
Map the columns
This screen asks: “which column in your file goes into which field?” Match your Email column to the Email field, Phone to Phone, and so on. If a column does not matter, choose “Don’t import”. Click Next.
-
Tag the whole batch
When it asks about tags, type something like imported-july. Every person in this upload gets that label, so if anything looks wrong later you can find (or delete) the whole batch in one search.
-
Start the import and wait
Click the final confirm button. Small lists finish in seconds; thousands of rows can take a few minutes. You can leave the page — it keeps working.
Success check: search the contact list for the tag you used (for example imported-july). If the number of people matches the rows in your spreadsheet, the import worked.
Common questions
“The import says some rows failed. Why?” Usually a badly formatted phone number or a duplicate email. Open the error file it offers you, fix those rows in your spreadsheet, and import just the fixed rows again.
“Will it create duplicates if a person already exists?” By default the system matches on email or phone and updates the existing contact instead of duplicating them. When in doubt, tag the batch so you can review it.
“Can I undo an import?” Yes — filter the list by your batch tag, select all, and delete. That removes only the people from that upload. This is exactly why step 5 matters.
No account to import into yet?
Open a free account, then bring your whole list with you in one upload.
30-Day Free Trial + $15,000 BonusesAffiliate link — we earn a commission if you sign up, at no extra cost to you.