Opening a CSV in Excel

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.

Sometimes your excel settings may not properly render a CSV (this often happens if you have been dealing with other delimiters such as tabs or semi-colons). If you are experiencing issues opening any CSVs downloaded from DeBounce, you can try these steps to open the file properly.

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!

Was this helpful?