Knowledge Base
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.
Your 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).
If you’re having trouble opening any CSV files you’ve downloaded from ListClean, consider following these steps.
- Open a new Excel document and navigate to the Data tab.
- Click “From Text”.
- Navigate to the CSV file you wish to open and click “Import”.
- From the newly-opened window, choose “Delimited”. Then click “Next”.
- Check the box next to the type of delimiter – in most cases, this is either a semicolon or a comma. Then click “Next”.
- Click “Finish”.
That’s it; you have just imported a CSV file to Excel!