1 Star2 Stars3 Stars4 Stars5 Stars (26 votes, average: 4.31 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 reads CSV files by default but in most cases when you open a CSV file in Excel, you see scrambled data that’s impossible to read.

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

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

  2. Click “From Text”. excel import from text function

  3. Navigate to the CSV file you wish to open and click “Import”. import csv file to excel

  4. From the newly-opened window, choose “Delimited”. Then click “Next”. text import wizard in excel 1st step delimited

  5. Check the box next to the type of delimiter – in most cases this is either a semicolon or a comma. Then click “Next”. text import wizard in excel

  6. Click “Finish”. excel text import wizard complete

That’s it; you have just imported a CSV file to Excel! csv contacts in excel

Export iPhone contacts to CSV

If you want to know how to export iPhone contacts to CSV, follow our step-by-step tutorial below. CSV is a common format that many platforms and services including Outlook and Google support.

How to export iPhone contacts to CSV tutorial

main copytrans contacts window

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.