1 Star2 Stars3 Stars4 Stars5 Stars (37 votes, average: 3.65 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 to convert CSV to excel.

How to open CSV file in Excel:

  1. Open CSV files in Excel 2016 and later
  2. Open CSV files in Excel 2003

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


CSV to Excel 2016

  1. Create a new Excel file and click on Data ➔ From Text/CSV.
  2. Convert CSV to 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. All done.
  8. Convert CSV to Excel


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

Transfer iPhone contacts to Excel with CopyTrans Contacts


CSV to Excel 2003

  1. Open a new Excel document and navigate to the Data tab.
  2. Open CSV in Excel

  3. Click on From Text.
  4. How to open CSV file in Excel

  5. Navigate to the CSV file you wish to open and click on Import.
  6. CSV 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!

Excel CSV

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.