Knowledge Base

Table of Contents

Display issues when importing CSV files in Excel

Cause

When you export data from Sparkcentral, the data is stored in CSV files. When importing these files in MS Excel you might experience line breaks or other unexpected display issues limiting you to work with the data.

This is an MS Excel limitation. When you open the CSV file as a text file, you can see the file is correct.

Solution

You can use this workaround to import data in MS Excel:

  1. After exporting to CSV, do not open the CSV file. (If you already opened it, close it without saving.)
  2. Upload the CSV file to a Google Sheet.
  3. Open the CSV file in Google Sheets. You will see that all the data is displayed correctly.
  4. Download the Google Sheet (File -> Download as) to a Microsoft Excel file (.xlsx).
  5. Open the new file in MS Excel. The data is now displayed correctly.

Was this article helpful?

You already voted!

We're always happy to help you ❤️!

Did you know you could help us too?

We love feedback from our users. It’s incredibly important for our business. That’s why a positive recommendation from your company could really make a difference!