Skip to main content
All CollectionsFAQs and Troubleshooting
The CSV that i exported looks weird
The CSV that i exported looks weird

This article contains guide lines on how to make the csv that you exported from Pobuca Connect get displayed correctly in Microsoft Excel

Carolina Brunatti avatar
Written by Carolina Brunatti
Updated over 6 years ago

If you exported data from Pobuca Connect to a CSV file and then opened the CSV with Microsoft Excel, you probably noticed that your data looks weird!

To overcome this issue using Microsoft Excel, follow these steps:

  1. Open the CSV with Microsoft Excel program 

  2. Select the first column

  3. Click on the ‘Data’ tab and then on ‘Text to Columns’ button 

  4. In the dialog box that will open, choose ‘Delimited’ and then ‘Next’ as shown in the screenshot below 

5. Choose ‘Comma’ as the only delimiter (unselect all other delimiters) and then click on ‘Next’ as shown in the screenshot below 

6. Click on ‘Finish’ 

Did this answer your question?