Heading image
Heading icon Help

Excel form import

If you already have forms or would prefer to create your forms in Excel, you can also achieve this with NestForms and then import your Excel file into your new form in NestForms.

Important note. This is not about importing your Responses, but this page is about importing the form structure with all the required questions for your form.

Start here: https://www.nestforms.com/form-excel-import, Download our sample template, make any edits you require and then upload it again.

Remember you must follow the format in the sample template we have provided. The template document is a simple example showing you how to create each type of field

Remember there should always be Three columns only

First Column: Questions - The text of your question

Second Column: Component Type - you must choose one of the component types in the available dropdown (input, dropdowns, number, GPS, etc.).

Third Column: Values -  some component types may require additional information - eg dropdowns, radio or checkboxes.

Values can be separated by the symbol “|” with no spaces
For example:
Single answer question (Radio button) Yes|No
Multiple answer questions (check boxes) Lettuce|Tomato|Radish|Pepper
Dropdowns Strawberry|Vanilla|Chocolate

Also make sure that your form is in the first sheet of the Excel file.

It is not possible to create skip logic or required fields within the import, but you can easily apply these features after the import is completed.

If you forgot something, don’t worry. Once your form is imported, you will be able to add other fields to the form later on within our website form builder.

 

If you already have a form in the NestForms builder and you just want to make a copy, you can use the Save as new feature. Or, if you want to clone your existing form into the another account, use clone form feature.

 

Importing forms including skip logic #

There is a more enhanced format you can apply if you want to import a form that includes Skip Logic. 

This enhanced format might not be for everyone as it requires some programming knowledge.

If this is the case for you, then we would strongly recommend importing the form without the skip logic and adding the skip logic into your form within the visual form builder.

For those that are comfortable with JSON, you would need to change the Value column from the pipe (|) separated string to a structured JSON format that contains an object with one item called items, where items are an array of objects. Each of these objects contain a name with the name of the item and might contain opts as additional options. Opts are an objects containing the key conditional which is an array of strings containing the IDs entered in the ID column. 

In simple terms, it might look like this:

{“items“:[{“name“:“Chocolate“, “opts“:{“conditional“:[“howMuchChocolate“]}}, {“name“:“Strawberry“},{“name“:“Vanilla“}]}

You can download a sample XLS file on the form import page with skip logic.

There are other options available that accommodate different component types, see the enhanced example for more details. Let us know if you would like to see more options available to meet your import needs.