Fixing Form Submissions 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 a CSV file in Microsoft Excel:

1. In Excel click on New and create a Blank workbook.
2. Next, go to Data → Get External Data → From 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.

Excel file origin

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 (Data Separator).

csv file separator

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, then Finish.

Text qualifier

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, select New worksheet before pressing Ok, instead of leaving it on Existing worksheet. Don’t forget to save your workbook.

Related articles

1 comment

Leave a Reply

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

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form for more information. in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?