Importing a Spreadsheet into Contacts (Outlook, iPhone and Gmail)

Turn a CSV spreadsheet into an address book in Outlook, iPhone and Gmail. Learn the file format, column mapping and how to handle duplicate contacts.

8 min read4 viewsImporting a Spreadsheet into Contacts (Outlook, iPhone and Gmail)
— · 0 votes
Contents
  1. Start with a clean spreadsheet layout
  2. Save the sheet as a CSV file
  3. Import an Excel spreadsheet into Outlook contacts
  4. Import a spreadsheet into iPhone contacts
  5. Import contacts from a spreadsheet into Gmail
  6. Map columns to the right contact fields
  7. Handle duplicate contacts after import
  8. Spreadsheet Contact Import Questions
  9. How do I import contacts from a spreadsheet into Gmail?
  10. How do I import contacts from a spreadsheet into an iPhone?
  11. Can I import an Excel spreadsheet into Outlook contacts?
  12. What is column mapping during a contact import?
  13. How do I stop duplicate contacts from appearing after import?
  14. Which file format should a contact spreadsheet use?

Importing a spreadsheet into contacts means converting your rows into a file the address book accepts, then mapping each column to a contact field. Outlook, iPhone and Gmail each run their own import step, and all of them read a CSV file with a header row. The work is mostly in preparing the file, not in the import itself.

  • Save the sheet as CSV with UTF-8 encoding and one header row naming each field.
  • Keep one contact per row and put the full name or the first and last name in separate columns.
  • Check the column mapping preview before you confirm the import, since a swapped field is hard to undo.
  • Remove duplicate rows in the spreadsheet before importing, because merging after import takes longer.
  • Each app has its own CSV template, and Gmail expects a Google Contacts CSV format with defined headers.

Start with a clean spreadsheet layout

A clean spreadsheet layout decides whether the import works on the first try. Put one contact per row, with a header row at the top naming each field you want to bring across. Use separate columns for first name, last name, phone number, email address and any group or note.

Avoid merged cells, blank spacer rows and multiple phone numbers crammed into one cell. A single cell holding two addresses forces the import to guess, and the guess often lands in the wrong field. Keep one value per cell so the column mapping step stays simple.

Name your columns in plain words such as First Name or Mobile Phone, since the import tools read these header names. If a row lacks an email but has a phone number, leave the email cell empty rather than typing a placeholder. Empty cells are skipped cleanly, while filled placeholders become junk data.

Save the sheet as a CSV file

A CSV file is a plain text file with one line per row and commas between values. Every contact app in this guide reads CSV, which is why the format is the shared starting point. Save your spreadsheet with the CSV option, not the native spreadsheet format.

Choose UTF-8 encoding when your spreadsheet tool offers the choice. UTF-8 keeps accented letters, apostrophes and non-Latin scripts readable after the import. A wrong encoding turns those characters into symbols that you then have to fix by hand.

Watch for commas inside a field, such as a street address or a note. Proper CSV wraps those values in quotes, but hand-edited files often break. Open the saved file once in a plain text editor and check that each line still holds one full record.

Import an Excel spreadsheet into Outlook contacts

Outlook imports an Excel spreadsheet through its import and export wizard, which walks you through the file. Open the wizard from the file menu and choose the option to import from another program or file. Select the comma-separated values type, then point the wizard at your saved file.

The Outlook import contacts wizard asks which folder receives the records, and the contacts folder is the one you want. It also offers a duplicate handling choice, where you decide to replace, allow or skip repeated entries. Pick skip or replace if you have already imported the same list once.

The final screen shows a column mapping, where each spreadsheet column is matched to an Outlook field. Check that the email and phone columns are not swapped before you finish. Outlook can also open the spreadsheet directly and map fields through the same matching screen.

  • Open the import and export wizard from the file menu.
  • Choose import from another program or file.
  • Select comma-separated values as the file type.
  • Point the wizard to your CSV and pick the contacts folder.
  • Choose how duplicate entries are handled.
  • Confirm the column mapping and finish the import.

Import a spreadsheet into iPhone contacts

An iPhone has no direct sheet import, so the file goes through an account that syncs contacts. Add the CSV to a cloud contacts service such as Google Contacts or iCloud through a computer, then let the phone sync that account. The iPhone contact import from file therefore happens in two stages.

On the phone, open the settings for contacts and accounts and confirm the account is switched on for contacts. The records then appear in the contacts app without any file handling on the device itself. Give the sync a moment and pull down on the contact list to refresh it.

If you keep contacts only on the phone, export them before you add a syncing account so nothing is overwritten. Check where new contacts are stored by default, since a wrong default account splits your list. Set the default account to the one holding your imported spreadsheet before you add anyone new.

Import contacts from a spreadsheet into Gmail

Gmail accepts a CSV through Google Contacts, which is the address book behind the mailbox. Open Google Contacts in a browser, find the import option in the menu, and upload your file. The tool previews the rows and asks you to confirm which account receives them.

The Google Contacts CSV format uses its own header names, so a sheet built for another app may map poorly. Download the sample file from the import screen and match your columns to those headers before uploading. This step prevents phone numbers landing in the notes field.

After the upload, Google Contacts shows how many records were added and offers to review duplicates. Merging duplicates is a separate action from the import, so plan a moment to clean the list. You can undo an import shortly after it finishes, which is useful when the mapping goes wrong.

Map columns to the right contact fields

Column mapping is the step where each spreadsheet column is tied to a contact field. A header row makes the mapping automatic in most tools, but you still confirm it before the import runs. Take a slow look at the preview, because a mismatch buried in one column affects every row.

Watch the phone and email columns first, since they look alike in a preview. Group and label columns are worth mapping too, as they let you sort the roster later. A column with no matching field can be skipped rather than forced into a note.

Test with a small file of a few rows before you commit the full list. A short trial reveals whether the header names and encoding survive the trip. Delete the test records afterward so they do not clutter the address book.

Handle duplicate contacts after import

Duplicate contacts on import appear when the same person already sits in the address book under a slightly different name. Clean the spreadsheet first by removing repeated rows and standardizing names and numbers. Prevention in the file saves more time than cleanup in the app.

Outlook, Google Contacts and iCloud each offer a merge or find-duplicates tool after the import. Run it once the file is in, and review each suggested pair before merging. A merge of two different people with the same name is hard to reverse.

Decide on one format for phone numbers and stick to it across the sheet. Mixed formats make the same number look like two entries to the duplicate finder. Keep a copy of the original CSV so you can re-import a corrected version if the merge goes wrong.

Spreadsheet Contact Import Questions

How do I import contacts from a spreadsheet into Gmail?

Gmail imports a spreadsheet through Google Contacts, which is the address book behind the mailbox. Open Google Contacts in a browser, choose the import option, and upload a CSV file with a header row. Match your columns to the Google Contacts CSV format and confirm the account before the import runs.

How do I import contacts from a spreadsheet into an iPhone?

An iPhone cannot read a spreadsheet file directly, so the CSV goes into a syncing account first. Upload the file to a cloud contacts service on a computer, then switch that account on for contacts in the phone settings. The records appear in the contacts app once the account syncs.

Can I import an Excel spreadsheet into Outlook contacts?

Outlook imports an Excel spreadsheet or a CSV through its import and export wizard. The wizard asks for the file, the destination contacts folder and a duplicate handling choice. You then confirm the column mapping, where each sheet column is matched to an Outlook field.

What is column mapping during a contact import?

Column mapping is the step that ties each spreadsheet column to a field such as first name, email or phone. The import tool shows a preview, and you correct any column the tool matched to the wrong field. Good header names in the sheet make this step quick and accurate.

How do I stop duplicate contacts from appearing after import?

Duplicate contacts on import come from repeated rows or slightly different versions of the same name and number. Remove repeated rows and standardize phone formats in the spreadsheet before you upload. After the import, run the merge or find-duplicates tool and review each suggested pair.

Which file format should a contact spreadsheet use?

A CSV file with UTF-8 encoding and a single header row works across Outlook, iPhone sync accounts and Gmail. Each app has its own preferred header names, so download its sample file when one is offered. Save your sheet as CSV rather than the native spreadsheet format before importing.

Read next

Latest articles