The Online Form Builder Blog

Web Form to Excel

Stored form responses and export to Excel allow FormSmarts users to collect online form responses on FormSmarts and download a report at their convenience in Excel format.

Export online form results to Excel/CSV


Activating Form Data Storage for Export to Excel

Export to Excel requires that data storage be enabled for each of the forms for which you would like to be able to access form responses online. For privacy reasons, data storage is disabled by default. To activate stored form results and allow Excel reporting, visit the Form Details screen of each of your forms for which you would like to access form responses online.

Store form responses in database

You will then be able to easily create 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.

Excel Report Generator Settings

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.

Importing an Excel Report

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).

Excel Text Import Wizard encoding

Posted by FormSmarts on Wednesday, July 8, 2009 at 9:46 am in form builder.
Permalink | Comment
Tags: , , ,

15 Responses to “Web Form to Excel”

How many form submissions / how much storage will be allowed for each account? Will we be able to purchase additional storage?

Posted by: Mitch | July 15th, 2009 at 12:32 pm

We would like to join beta testers.
Cheers
Brad

Posted by: Brad | July 20th, 2009 at 3:39 am

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.

Thanks Mark and the Team at Syronex. Implemented Web Forms to Excel feature and it works fine. Looking forward to Text Blocks in Forms.
Kind regards
Brad

Now that I can download form data from FormSmarts is Excel format, how can I stop receiving forms by email?

Posted by: Anna | August 21st, 2009 at 9:47 am

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

I activated my web forms submission to excel. Any chance it could be operational soon? Is there a limit to how many form responses can be stored?

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).

Is there an option to schedule weekly excel reports to an email address? If not this would be really useful!

Posted by: Yarran | March 23rd, 2010 at 6:16 am

Is it possible to clear the database of form submissions? I did a lot of test registrations on my first form, to nudge the whole process, and now I’d like to purge them and start anew. Should I just clone the form?

Posted by: David | December 2nd, 2010 at 2:57 pm

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

Although I receive the submissions to my email and much of the entries are in Arabic they entries appear as funny characters when I generate an excel output using the excel generator tool.

Please advise how this can be rectified.

Thanks,

Posted by: Terry | April 8th, 2011 at 3:11 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.

Can limited authorization be granted to an additional person so form data can be downloaded?
Thanks

Posted by: David | March 8th, 2012 at 1:23 am

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.

Leave a Reply

Email will not be published.

Connect with FormSmarts


Get updates by email (~1 email/month):

Got a Question?

Got a question about FormSmarts?
Ask FormSmarts Sales!

About the Form Builder Blog

The Online Form Builder Blog is published by FormSmarts, a web form service providing all you need to create a form and publish it online in minutes. FormSmarts makes it easy to build a form and embed it on your site. You can then get form submissions by email or store them on FormSmarts and download an Excel report. Learn more about the many other benefits of FormSmarts.
Your AccountHelpFormSmarts