• Home
• Blog
• Online Form to Excel

Online Form to Excel

FormSmarts allows users to collect online form responses on the cloud and export them to Excel at their convenience with the Report Generator.

Enable Form Data Storage for Export to Excel

Export to Excel requires that you turn on data storage for each of the forms for which you would like to use this feature.

For privacy reasons, form submissions were not saved on the cloud by default in the past. For Business accounts created after March 20, 2017, storage is now enabled by default. This does not apply to Pro accounts, for which storage is turned off by default and must be enabled for each form if needed. Note that the storage space available with Pro accounts is limited.

To enable stored form results and allow Excel reporting, visit the Submit Actions tab of the Form Details screen of each of the forms for which you would like to access form responses online, as shown in the video below.

You will then be able to download Excel reports from stored form responses in a few clicks with the report generator. Business-level members may also view individual form responses online and download a PDF Report.

To enable storage of form entries by default when you create a new form, check Turn on cloud storage for all new forms in the Settings Tab of the form builder. This option is only available in Business accounts and is turned on by default for accounts created after March 20, 2017.

Updating Form Results

To ensure you get consistent and up-to-date data when you export form results as an Excel spreadsheet:

• If you find out a form response has incorrect or out-of-date information, edit it and amend the data
• After you submit a test run, remember to remove it.

Excel Report Generator Settings

Show Field Names in the First Line

If checked, the first line of Excel reports will show the name of each field. This option is enabled by default.

Week Starts

The report generator allows you to specify the date range over which a report is generated by either picking a start & end date or choosing a preset period of time (This Week, Last Seven Days,…). For the time periods that depend on the first day of the week (This Week, Last Week), we use the default first day of the week for your country (as set in your account). You can change this under More Options.

Time Zone

Preset time periods, date ranges and the form submission timestamp shown in Excel reports are now using your time zone (as defined in your computer settings). If you would like to generate a report using a different timezone, select the relevant city in the Timezone drop-down list. Note that the city selected by default may not be your city of residence, but it will be a city in the same timezone.

Export Format: CSV or XLS

Choose the reports format from Comma-Separated Values (CSV), the default, or the Native Excel format (XLS or XLSX).

Importing an Excel Report When the Spreadsheet Contains Non-Western European Characters

If an Excel (CSV) report contains text in a language other than English, you may need to change the character encoding to Unicode (UTF-8) in Excel’s Text Import Wizard, as illustrated below. The report may not display correctly for languages other than English unless the encoding is set to Unicode (UTF-8).

Posted by FormSmarts on Jul 8, 2009 at 9:46 am in form builder.
Permalink · Comment
Tags: excel, form results, form to excel, form to pdf

17 Responses to “Online Form to Excel”

Mitch,
Each account will have a storage allowance, and you’ll be able to purchase more storage if needed. You’ll also be able to have stored submissions automatically deleted after 30 days. We’ll publish details in due course.

Posted by: FormSmarts | Jul 20th, 2009 at 7:14 am

Anna,
To stop receiving forms by email, simply log in to your account and uncheck all email subscribers (in the form details screen).

Posted by: FormSmarts | Aug 21st, 2009 at 10:53 am

Jen,
You should be able to use our Form to Excel feature by now. Activation currently takes up to a few hours. You’ll be able to activated form storage instantly for each form in the Form Details screen of your account starting with out next release.

There is no limitation in the number of form responses you can store at this time (subject to fair usage policy).

Posted by: FormSmarts | Jan 3rd, 2010 at 9:28 pm

David,
You can’t delete form data at this time. You should indeed just clone the form.

Posted by: FormSmarts | Dec 2nd, 2010 at 2:59 pm

Terry,
Excel reports are encoded with the Unicode (UTF-8) character encoding, which supports character sets used in all languages. I suspect that when you open a report, Excel uses the default Windows encoding set in your computer to decode the data instead of UTF-8. As a result, the characters shown in the report are be incorrect.
After downloading a report from FormSmarts, there should be an option in the Excel window to set the character encoding for opening the document. You should also be able to change the encoding of the Excel spreadsheet before saving it to your computer in the Save As window.

Posted by: FormSmarts | Apr 8th, 2011 at 3:38 pm

David,
The current version of FormSmarts doesn’t allow this, however starting with version 3 (due in a few months) Business Plus and Max accounts will become multi-user. The account administrator will then be able to grand limited privileges (such as the ability to view reports) to a sub-user.

Posted by: FormSmarts | Mar 8th, 2012 at 10:24 am

Yes Patt, you can also export form responses to Excel XLSX.

Posted by: FormSmarts | Apr 1st, 2021 at 12:29 pm

Leave a Reply