Why Is the CSV I Downloaded Incorrectly Formatted in Excel?

Incorrect formatting of your CSV email validationⓘ results file may occur in Microsoft Excel. This error occurs because Excel often doesn't auto-detect the file delimiter and, instead, puts all of the results data into a single column.

Thankfully, you can circumvent this issue by using the following steps:

1. Open a new, blank worksheet in Excel.
2. Click on the "Data" tab in the top navigation bar.
3. Under the "Data" tab, click on "From Text/CSV". You can find this in the section "Get & Transform Data".
4. After importing your file, the Text/CSV transform section will appear.

5. Select the delimiter that's being used within the file. In the pictured example below, there is a Comma delimited file. In this scenario, you would select the "Comma" option.

6. Click "Load".

When you upload an email list file to ZeroBounce, the email validationⓘ tool auto-detects the file delimiter that's in use. After the email list cleaningⓘ or scoring is complete, the validator will use the same file delimiter that was used in your original file. When troubleshooting formatting errors in Excel, be sure to select the same file delimiter that you used in your original file.

If these troubleshooting steps fail, or if you experience other issues with your downloaded CSV being incorrectly formatted in software, contact ZeroBounce support. The support team can work with you to examine your results file and find a solution.

You can get in touch with ZeroBounce support 24/7, 365 days a year through your preferred method:

Related Articles

Why Is My File Taking So Long to Process?

Why do I need a password to open my processed file?

How do I get a password to decrypt my file?

Why is my Overview PDF report blank?

Why are some emails missing append features?

Why do I get the error “unable to expand” with Archive Utility?

Where can I get software to open the CSV file?

Why is my bounce rate high after email cleaning?

Why can’t I find my file on Windows?