1 Star2 Stars3 Stars4 Stars5 Stars (32 votes, average: 4.06 out of 5)
CSV logo

CSV, or comma separated values, is a common format for storing and transmitting content including contacts, calendar appointments and statistical data.

Excel is supposed to read CSV files, but in most cases, when you open a CSV file in Excel, you see scrambled data that’s impossible to read.

This article demonstrates how easy it is to properly open CSV files in Excel 2016 and Excel 2003 and view them without the need to convert anything.

BONUS: Find out how to export iPhone contacts to Excel.

Open CSV in Excel 2016

  1. Create a new Excel file and click on Data ➔ From Text/CSV.
  2. Open CSV in excel

  3. Find the CSV file on your PC and click on Import.
  4. Select a CSV file

  5. Preview the resulting table in the pop-up window and click on Load.
  6. Check the data and click on Load

    Change the delimiter and encoding type if needed.

  7. Done.
  8. CSV file in Outlook

How to export iPhone contacts to Excel

Learn how to export and edit iPhone contacts in Excel. Follow our step-by-step tutorial below.

How to export iPhone contacts to Excel

CopyTrans Contacts interface

Open CSV in Excel 2003

  1. Open a new Excel document and navigate to the Data tab.
  2. xcel sheet data tab

  3. Click on From Text.
  4. excel import from text function

  5. Navigate to the CSV file you wish to open and click on Import.
  6. import csv file to excel

  7. In the newly-opened window, choose Delimited. Then click on Next.
  8. text import wizard in excel 1st step delimited

  9. Check the box next to the type of delimiter: in most cases, this is either a semicolon or a comma. Then click on Next.
  10. text import wizard in excel

  11. Click on Finish.
  12. excel text import wizard complete

That’s it! you have just imported a CSV file to Excel!

csv contacts in excel

Avatar for krasimir

By krasimir

Krasimir is an avid marketing aficionado and a tech-support specialist in charge of the English-speaking market. He grew up in Bulgaria and on the island of Mauritius where he became passionate about windsurfing and photography.