Contact and spreadsheet CSV workflows

Convert Excel Contacts to Google Contacts CSV

Prepare an Excel contact sheet with Google Contacts field headers, preserve phone strings, export a checked CSV and verify a small import before scaling up.

By Uddhav Gopani, FounderPublished 27 September 2026Updated 29 September 2026

Convert Excel Contacts to Google Contacts CSV

To prepare Excel contacts for Google Contacts, map the workbook into the Google Contacts template, export the mapped sheet to CSV and import that file into the intended Google account. The important conversion is from your source columns to contact fields; simply saving an arbitrary workbook as CSV does not establish that mapping.

Separate the source sheet from the import sheet

Keep the original workbook and create an import copy with only the intended contacts. If the source has several worksheets, decide which one contains the current authoritative list. A sheet named Old Customers or a filtered report may contain a different population from the one you mean to import.

Write down a simple mapping before moving data. Given name can map to First Name, family name to Last Name and an email-address column to Email 1 - Value. Treat a telephone label such as Work as a separate value from the telephone number itself.

Use the current destination template

Google’s import documentation links a template and documents its headers. Use a copy, including its header row, rather than inventing shortened headings. The same documentation provides an Excel download route for the template.

Do not split full names automatically on the last space without reviewing the source. A name can contain several given names or a compound family name. If the workbook already has reliable separate fields, use them; otherwise, review ambiguous records rather than silently guessing a person’s name structure.

Build and inspect two sample contacts

First Name,Last Name,Email 1 - Label,Email 1 - Value,Phone 1 - Label,Phone 1 - Value
Asha,Rao,Work,asha@example.com,Mobile,+12025550123
René,Park,Home,rene@example.com,Home,+442079460123

The fixture contains two fictional records and six columns. Work and Home label email fields; Mobile and Home label phone fields. The email address and phone number belong in their corresponding Value columns. An importer cannot reliably infer a swapped pair from a label that merely looks familiar.

Compare Asha’s email and number across the worksheet and exported record. Then repeat with René to check non-ASCII text. This two-record check catches different problems from repeatedly testing a single simple row.

Keep phone strings intact

Prepare phone values as text before copying them into the import sheet. Preserve the intended country-code plus sign and all digits. Removing punctuation may change presentation, but deleting digits or automatically converting a long identifier to a rounded number changes the data.

If a number already became scientific notation or lost a leading zero in the source workbook, return to the original record to repair it. CSV export cannot infer the missing digits. Do not add a literal apostrophe to the CSV as a universal repair; that character may become part of the imported value.

Export and reopen the file carefully

Export the mapped sheet to CSV using the workbook application’s save or download controls. Check that the resulting file contains the intended header and contact rows, with commas separating fields and quotes enclosing any field containing a comma. Preserve accented names with a compatible text encoding.

Reopening a CSV directly in a spreadsheet can apply automatic type conversions again. For verification, inspect it as text or import it with phone columns explicitly treated as text. Otherwise, the act of checking the file can produce a new altered version that gets saved over the correct export.

Check the account and resulting fields

In Google Contacts on a computer, choose Import, select the CSV and import it. Confirm the intended account before this step. A successful upload means the service accepted the file; it does not replace checking the individual fields in the resulting contacts.

Start with a deliberate small set and inspect names, email labels and phone values. If details appear in unexpected places, correct the column mapping before importing the remainder. Avoid repeated full-file retries, which make it harder to distinguish new contacts from earlier test records.

Reconcile the completed import

Compare the intended records with the imported set using more than the displayed total. Two identical names can represent different people, while one person may have several email addresses. Use the source details to resolve duplicates deliberately instead of merging every matching name.

Retain the original workbook and the exact CSV used for the import. If the destination data later needs correction, those files identify whether the error arose in the source, the export or the field mapping. A repeatable preparation step is safer than editing an untracked series of temporary CSV copies.