Convert Contact List to Excel: A Step-by-Step Guide

How-to basics · Updated November 20, 2026

To convert a contact list to Excel, export it from your contacts app as a CSV file, then in Excel for Microsoft 365 on Windows choose Data > From Text/CSV, preview the columns, and select Load. Save the result as an .xlsx workbook. If your list is a vCard (.vcf), first import it into a contacts app that can export CSV; Excel does not reliably turn a vCard directly into a structured contact table. A little care during import helps preserve phone numbers, postal codes, and other fields exactly.

What You’ll Need

  • A computer with Excel for Microsoft 365 on Windows. Excel for Mac can also import CSV files, though available menu labels and Power Query options depend on the version.
  • Your contact list, preferably exported from its current app as a .csv file. Common sources include email services, phones, customer databases, and contact-management software.
  • A place to save the finished workbook, and enough access to the original contacts app to export or convert the list if needed.

Step-by-Step

  1. Check the contact list’s current format. Find the file extension in File Explorer: .csv is a comma-separated text file, .xlsx is already an Excel workbook, and .vcf is a vCard file. If the contacts are still in an app, look for an Export option in its contacts or settings area. Choose CSV when offered, and select all contacts or the intended group. If the app offers different CSV formats, choose one intended for Excel or Outlook. Save the export somewhere easy to locate, such as Documents. Do not rename a .vcf file to .csv; changing the extension does not convert its contents.
  2. Prepare the export before importing. If you can choose which fields to export, include the ones you need, such as first name, last name, email address, phone, company, and notes. Avoid exporting sensitive or unnecessary details. If you have a vCard instead, import it into the contacts service that created it or another compatible contacts app, then export the contacts from that app as CSV. In classic Outlook for Windows, the File > Open & Export > Import/Export wizard can import a vCard and export contacts as CSV; the steps differ in new Outlook, so using the original contacts service’s export option is usually simpler. Verify that the converted file contains all the contacts before moving on.
  3. Start the import in Excel. Open a blank workbook, then select Data > From Text/CSV on the ribbon. Browse to the CSV file, select it, and choose Import. This route lets you review how Excel reads the file before loading it. Avoid opening a CSV by double-clicking if it contains phone numbers or postal codes with leading zeros: Excel may interpret those fields as numbers and remove the zeros before you can check them.
  4. Check the preview settings. In the import preview, confirm that the first row contains field names and that the data is separated into the right columns. A typical contact export might show First Name, Last Name, Email, and Phone as separate headings. Check the File Origin or encoding setting if accented letters or symbols look wrong; choose the encoding used by the source, commonly UTF-8. Check the delimiter too. CSV commonly uses commas, but some regional settings or exports use semicolons or tabs. Select the delimiter that makes the preview line up into sensible fields.
  5. Use Transform Data to protect important fields. If you see fields such as phone numbers, postal codes, account IDs, or contact IDs, choose Transform Data rather than loading immediately. In Power Query Editor, look in the Applied Steps pane for an automatic Changed Type step. If it has already converted a sensitive column to a number, remove that step before correcting the column, so original leading zeros are not lost. Select the relevant column headings and choose Transform > Data Type > Text. Set names and email addresses to Text as well if Excel has guessed a different type. Review columns that contain dates, too: leave them as text if you need to preserve the source’s exact date format, or set them to Date if you want Excel to sort and filter them as dates.
  6. Load the contact data. In Power Query Editor, choose Home > Close & Load to place the cleaned data in a new worksheet. If you did not need to change types, you can choose Load from the import preview instead. Check the worksheet’s first and last few rows, and compare its number of contact rows with the source export. The first row should normally contain the headings, with one contact per row beneath it. If the preview or loaded data is wrong, return to the import settings and correct it before using the list.
  7. Review and arrange the columns. Make headings clear and consistent, for example First Name, Last Name, Email, Phone, Company, and Notes. Keep one type of information in each column and one contact in each row. If names arrive in a single Full Name column, you can leave them together; split them only if you have a reason, because names can contain middle names, prefixes, suffixes, or multiple words. If you do split a column, make a copy of the original first and inspect the results rather than assuming every name follows the same pattern.
  8. Make the list easier to use and save it. Click inside the data and choose Home > Format as Table, select a style, and confirm that My table has headers is checked. A table makes sorting and filtering more convenient without changing the contact values. Check that email addresses have not been split at punctuation and that long notes remain in their own column. Then choose File > Save As, select Excel Workbook (*.xlsx), choose a folder, and save. Keep the original CSV as a backup; the CSV remains useful for transferring data between apps, while the .xlsx version can retain Excel formatting and additional worksheets.

Common Mistakes

Opening the CSV directly and trusting the result. Excel may automatically convert phone numbers, postal codes, and long numeric IDs, remove leading zeros, or display long values in scientific notation. Importing through Data > From Text/CSV gives you a chance to check and set data types before loading.

Choosing the wrong delimiter or encoding. A wrong delimiter can put a whole row into one column or split a field that contains punctuation. The wrong encoding can make letters with accents appear as unusual symbols. Check the preview, not just the filename, before loading.

Assuming each row is one person. Some exports include extra blank rows, multiple email or phone columns, or more than one record for a person. Check for duplicates and understand how the source represents secondary details before deleting anything.

Overwriting the only copy. Keep the source export unchanged until you have checked the workbook. Saving a CSV as .xlsx is not a substitute for preserving the original, especially if you need to repeat or audit the conversion.

Tips

  • Export only the fields you need. This keeps the workbook easier to review and reduces the amount of personal information in the file.
  • Use a consistent structure: one contact per row, one field per column, and a single header row. Avoid merged cells, blank separator rows, and multiple contacts typed into one cell.
  • Keep phone numbers and postal codes as text, not numerical values. They are identifiers, not quantities to add, and formatting them as text preserves leading zeros and characters such as +.
  • Use filters to find missing email addresses or blank names, but do not delete incomplete contacts automatically. A contact with no email may still have a useful phone number or mailing address.
  • If you need to clean duplicates, first save a separate copy. Compare more than names alone: two people can share a name, and one person can appear under different spellings. Email address is often a useful comparison field, but check the records before removing one.
  • When importing a fresh export later, retain the same column names and data types where possible. Consistent headings make it easier to compare the new list with the old one or use it in another workbook.

Troubleshooting

Everything appears in one column: Reopen the CSV through Data > From Text/CSV and try the other delimiter shown in the preview, such as semicolon or tab. If the export uses unusual separators, check its regional or export settings. Do not split the data by hand until you have confirmed the delimiter.

Leading zeros have disappeared: Re-import the original CSV rather than trying to add zeros back to the workbook. In Power Query, remove any automatic Changed Type step that converted the affected values, set the relevant column to Text, and then load it again. If the CSV itself already lacks the zeros, export a fresh copy from the source.

Accented characters look garbled: Return to the import preview and change the file origin or encoding, then inspect names and notes before loading. UTF-8 is common, but the right choice depends on how the file was saved by the contacts app.

Names or addresses seem split incorrectly: Check the delimiter and preview first. Commas can occur inside quoted address or notes fields, and a proper CSV importer should keep those values together. If they are still divided into unexpected columns, the file may be malformed or may not actually be CSV; export it again using the contacts app’s CSV option.

Some contacts are missing: Compare the source app’s export count with the rows loaded into Excel. Check whether the export covered all contacts or only a selected group, and look for filters in Excel that might hide rows. Also check for blank lines or records the source app could not export.

Excel will not open the file as expected: Confirm that the file really ends in .csv and is not a renamed vCard or another format. Re-export it from the source app if needed. On Excel for Mac, use the available CSV import option under Data; menu wording and Power Query availability vary by version. If the import tools are unavailable, opening the CSV from File > Open may offer a text-import step. Carefully set sensitive columns to text and verify the result before saving as .xlsx.

Frequently Asked Questions

Can I convert a contact list to Excel without losing the original?

Yes. Import the CSV into a new workbook and save the result as .xlsx under a different filename. Keep the original CSV untouched as a backup and as a portable copy for other contact apps.

Can Excel open a VCF or vCard file directly?

Excel is designed to import tabular files, not to reliably organize vCard records into contact columns. Import the VCF into a compatible contacts app first, then export the contacts as CSV and import that CSV into Excel.

Why did Excel remove the zero at the start of a phone number?

Excel interpreted the value as a number, and numbers do not retain leading zeros. Re-import the original file and set the phone column to Text before loading. Phone numbers should generally be stored as text because they are not used for arithmetic.

How do I convert an Excel contact list back to CSV?

Open the workbook, select the worksheet containing the contacts, and choose File > Save As. Choose CSV UTF-8 (Comma delimited) (*.csv) if available, or the CSV option required by the receiving app. CSV saves only the active worksheet and does not retain Excel formatting, so keep a separate .xlsx copy.

Can I add more contacts to the workbook later?

Yes. You can type new records into the next row of the table or import an updated CSV into a separate worksheet and compare the lists. Check the column headings and formats before combining records, so phone numbers and postal codes stay as text and contacts are not duplicated.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.