SpreadsheetConverter automatically sends submitted web forms to any Inbox. The basic service is free. You enter the e-mail address in the Configure Submit options on the Workbook tab in the Settings panel.

Your can build web forms that automatically get sent to your e-mail Inbox every time someone uses the form. For a small monthly fee, you can also have each submitted form stored in a hosted database for later retrieval. Read more about our Free and Advanced Submit Services.

When you create a web form, you need to specify to which e-mail address each submitted form is to be sent. There are also many other powerful options that let you tailor the forms submission process to your requirements.

Configure submit

The forms submit options are on the Workbook tab in the Settings panel.

Switch to the SpreadsheetConverter ribbon

In Excel, look for the SpreadsheetConverter tab at the right end of the menu ribbon. Click the tab to switch to the SpreadsheetConverter ribbon.

ssc_ribbon

Open the SpreadsheetConverter Settings panel

In the SpreadsheetConverter ribbon, select Properties > Show so that the SpreadsheetConverter Settings panel becomes visible.

ssc_panel

Open the Workbook Settings panel

In the SpreadsheetConverter Settings panel, select the Workbook tab so that the Workbook Settings become visible.

workbook_tab

Workbook > Select buttons to include

SpreadsheetConverter provides a number of different buttons you can use on a web form. The most important one is “Submit”, since this is the button that is used to send a completed form for processing. This checkbox must be checked for every electronic form.

submit_choose

The Print button prints the current web form section/worksheet, and the PrintAll button prints the entire web form. The Reset button empties all fields in the web form.

The Update button forces a recalculation of the spreadsheet. This button is only used when an ASP.NET server is used without automatic recalculation.

Preferences > Customize Text

To change or translate any built-in texts used with your form, including the button texts, use Preferences > Customize Text.

enable_customizetext

On the Message Dialogs tab, click on the arrows to expand the following sections:

  • Validation Message – these are the texts used for incorrect input.
  • Submit Dialog – these are the texts used when the Submit button has been pressed.
  • Offline Save – these are the texts used when a form is submitted offline.
  • Offline Submit – these are the text used when saved forms are sent when online again.
  • Offline Submit Fail – these are the texts used when the saved forms couldn’t be submitted.

Workbook > Configure Submit button

At the bottom of the Workbook settings, there is a button for configuration of the forms submission process, i.e. how completed forms should be forwarded for processing.

configuresubmit_choose

Workbook > Configure Submit > E-mail settings

Enter the e-mail address to which you want completed forms to be sent.

email_field

Select the Advanced submit service if you have a trial or paid license for it, or select the Free submit service that is included with your SpreadsheetConverter license. The main difference is that the Advanced service stores each form in a database, and formats the e-mail you get for each form submission exactly like the web form.

secure-delivery-configure-submit

If you have a license for the Advanced service, select the Secure Delivery option if you want the e-mail to contain just a link to the received form. This protects the form contents and any file attachments behind an additional login.

Screenshot of the e-mail from the Advanced Submit Service that contains just a link thanks to Secure Delivery

We recommend that you use Secure Delivery if you allow file attachments for the form. Otherwise, file attachments are included in the e-mail with the completed form, which may cause problems if the files are very large.

If you just want a one-time demonstration of what an e-mail from the Advanced submit service looks like, select Demonstration. Instead of being sent to your Inbox, a copy of the e-mail will open directly in your web browser every time you submit a new form.

Workbook > Configure Submit > After submit settings

After a form has been submitted, a neutral “Thank you” page is displayed. If you want to provide your own thank-you-page, enter its address in the “After successful submit” field. Click the button to the right of this field to verify the address; the page will open in your web browser.

email2

You can also provide your own handling for submissions where our server fails to receive or e-mail you the data. This can only happen when our server is stopped for some reason. The URL should point to a page that recommends the user to wait for ten minutes and then try again.

If a data entry wizard layout is used for a multi-sheet workbook, you can provide a Cancel button in the wizard that allows the user to leave the form without submitting it. Enter the address of the web page you want the user to arrive at after having pressed Cancel, e.g. the address of the page where the user originally found the form and opened it for data entry.

Using your own script for SpreadsheetConverter forms

If you prefer to use your own script to process each submitted web form, enter the URL to that script in the URL field. The script will be sent the following parameters:

  • xl_version=14.0.0 – identifies the file format
  • (name1)=(value1)
  • (name2)=(value2)
  • etc

where (name1) is the name assigned to the first input cell in the form and (value1) is the value in that cell. If a worksheet contains two input fields, “name” and “release”, the parameters sent to the script will be:

?xl_version=14.0.0&name=spreadsheetconverter&release=6.1.0

Data is encoded according to the HTTP Post standards, e.g. a space is represented as “%20”. Please contact our support department if you need help on how to decode the query string of an HTTP Post operation.

If you intend to use this feature, you should assign names to all the input cells in the form. Otherwise, SpreadsheetConverter has to refer to cells with an internal Excel coding that is different for Excel 2000-2003 and Excel 2007 and later versions. Please contact our support department if you need help decoding this format.

Special functions

Our form solutions provide lots of added value:

  • An e-mail copy of the submitted form can be sent to the submitter, or to any other e-mail address. Just give a cell the reserved name “email” and have the user enter the e-mail address there.
  • If you wish to assign a particular subject to this message, give a cell in the spreadsheet the reserved name subject and provide a text for the e-mail Subject there.
  • Like any other named cell, the e-mail address and subject can be set from the form’s URL, e.g. “/form.htm?email=x@y.z&subject=Application”.

Read more in the tips and tricks section.

Build live website calculators and web forms now!

conversion imageconversion imageconversion image

Just download, install and test the Excel add-on now. Or let us convert a spreadsheet for you, for free.