Fixing CSV export in Microsoft Excel

Fixing CSV Export in Microsoft Excel

There have been some problems reported when trying to open exported CSV files in Microsoft Excel. The submissions wouldn’t appear as tabular textual data. This is due to the fact that Excel sometimes can’t directly transform all data accordingly from the exported file.

Follow the steps below on how to open CSV file in Microsoft Excel:

  1. In Excel click on New and create a Blank workbook.
  2. Next go to DataGet External DataFrom text.
  3. Import the CSV file from your computer.
  4. Check Delimited and, at File Origin, select 65001:Unicode (UTF-8) from the dropdown list.
  5. Click Next and, at Delimiters, choose the delimiter (field separator), be it space or comma. You’ll see the changes in the window below, within the wizard panel. The delimiter that you choose should be the same as the one you selected when exporting the CSV file from your 123FormBuilder account.
  6. In the same panel choose the enclosure of the fields in Text qualifier. The qualifier that you choose should be the same as the one you selected when exporting the CSV file from your 123FormBuilder account. Hit Next, afterwards Finish.
  7. Hit Ok and you’re done. Your submissions should now be organized within a table with well structured columns in your Excel window. If this doesn’t work try to select New worksheet before pressing Ok, instead of leaving it on Existing worksheet. Don’t forget to save your workbook.

We hope these steps on how to open CSV files have proved to be helpful to your situation. For any further assistance, contact us and we will get back to you shortly.

2 Comments

  1. […] in a messed up order, don’t worry as they can be fixed right away, be it Excel 2003 or a more recent version of Excel Related Topics View, filter and sort submissionsCustomize viewResend, print or export to CSV […]

  2. […] content should now be displayed correctly, on columns. If this doesn’t work read our Fixing CSV export in Microsoft Excel Guide Related Topics View, filter and sort submissionsCustomize viewResend, print or export to CSV […]

Leave a Reply

Your email address will not be published. Required fields are marked *