Opening a CSV in Excel

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 NeverBounce, you can try these steps to open the file properly.

1. Select the column that is improperly formatted and then go to “Data” -> “Text To Columns”


2. Go though all 3 Steps in the Convert Text To Columns Wizard

Step 1

Choose “delimited”

text to colum wizard step1

Step 2

Then “Comma”

text to colum wizard step2

Step 3

Click “Finish”

text to colum wizard step3

Hopefully that solves any issues regarding the separation of fields in Excel. If this does not please reach out and let us help.