Knowledge Base
< All Topics
CSV (comma-separated values) is a popular format for storing and distributing data such as contacts, calendar appointments, and statistics.
By default, Excel reads CSV files, but in most circumstances, when you open a CSV file in Excel, you’ll see scrambled data that you can’t understand.

excel settings may not always render a CSV correctly (this often happens if you have been dealing with other delimiters such as tabs or semi-colons).

having trouble opening any CSV files you’ve downloaded from ListClean, consider following these steps.
  1. Open a new Excel document and navigate to the Data tab.
  2. Click “From Text”.
  3. Navigate to the CSV file you wish to open and click “Import”.
  4. From the newly-opened window, choose “Delimited”. Then click “Next”.
  5. Check the box next to the type of delimiter – in most cases, this is either a semicolon or a comma. Then click “Next”.
  6. Click “Finish”.

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

Table of Contents