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!