How to import data into Formaloo

You can import your forms and their responses into Formaloo using an Excel spreadsheet or a Google Sheets. When you import a file, Formaloo creates a new formaloo for you and imports all of your data to it.

Step 1: Prepare your Excel file

Download your responses from your previous tool. Then open your downloaded Excel file to prepare it for importing into Formaloo. There are a few rules your Excel file should follow to be imported appropriately.

Your file should be in .xlsx or .xls format and shouldn’t have more than 10,000 cells. For importing more data, contact our support team on the website chat to help you with it.

1: Define the field names and types

The first row of your spreadsheet should include your field names and types. The format is simple:

field title(field type)

To assign the correct field types, follow the last section of this article.

2: Make sure your rows match Formaloo’s validation

Formaloo validates responses to make sure the entered data matches the field type. To make sure your responses match with Formaloo’s validation, check the following points:

The options inside the single-choice and multi-choice fields will be added from the responses (other rows). So if there are options no response has ever selected, you can add them in a new row to your spreadsheet or later in your formaloo.
The date format in your Excel file should be in this format: YYYY-MM-DD.
If you downloaded responses from your previous form builder solution, the files are on the source servers and won’t be moved to Formaloo’s servers in this import. Therefore, at version 1 of Formaloo importer, it only creates a file field with no responses inside. So instead, you can make this field a URL type to store the URL of your files from the previous tool.
The section and video fields will create a field of that type. But since they’re meta fields and don’t collect data, you’ll have to add content/link to them at the form editor when the import is completed.
If Formaloo doesn’t recognize the format of some of your responses, it will ignore them.

Step 2: Import your Excel file

After preparing your Excel file, go to your Formaloo dashboard and click on the Import button at the top.

Import an Excel file

Upload your Excel file and click the Send button.

Import a Google Sheet

Paste the Sheet URL in the specified field. Make sure the URL you paste here is the URL of the correct sheet and change the Sheet title based on your Sheet. Then click Import.

It will start to import your form and its responses, and when finished, you’ll be redirected to the form’s page.

If you received an error while importing your Excel file, go back through your field types and responses and ensure they match this tutorial and the sample Excel file.

Step 3: Find the imported data

Depending on the number of rows, it can take a few minutes to import all your data and fields.

After a few minutes, refresh your editor and dashboard and you will find the imported data in your newly created formaloo.

List of field types

Find the right field type for your import in the following table:

	Short text field Add text in the parentheses in front of your field name Example: Full name (text)
	Email field Add email in the parentheses in front of your field name Example: What’s your email address? (email)
	Single-choice field* Add choice in the parentheses in front of your field name Example: Which model do you prefer the most? (choice)
	Multi-choice field* Add multiple_select in the parentheses in front of your field name Example: What are your favorite snacks? (multiple_select)
	Phone field Add phone in the parentheses in front of your field name Example: What’s your contact number? (phone)
	Number field Add number in the parentheses in front of your field name Example: How old are you? (number)
	Long text field Add long_text in the parentheses in front of your field name Example: Write down your question here (long_text)
	Dropdown field Add dropdown in the parentheses in front of your field name Example: Which class are you registering for? (dropdown)
	Date field* Add date in the parentheses in front of your field name Example: When’s the best available date to meet? (date)
	Website Field Add website in the parentheses in front of your field name Example: What’s your website URL? (website)
	File field* Add file in the parentheses in front of your field name Example: Upload your photo here (file)
	Time field Add time in the parentheses in front of your field name Example: What time best suits you? (time)
	Score or Net promoter score (NPS) field Add score in the parentheses in front of your field name Example: How likely are you to recommend us? (score)
	Star or customer satisfaction (CSAT) field Add star in the parentheses in front of your field name Example: How happy are you with our products? (star)
	Yes / No field Add yes_no in the parentheses in front of your field name Example: Do you accept our terms of service? (yes_no)
	Like / Dislike field Add rating/like_dislike in the parentheses in front of your field name Example: Do you like Marvel movies? (rating/like_dislike)
	City field Add the city in the parentheses in front of your field name Example: Where are you located? (city)
	Section field* Add meta/section in the parentheses in front of your field name Example: Here’s some info about our products (meta/section)
	Video field* Add meta/video in the parentheses in front of your field name Example: Watch our latest demo video (meta/video)
	Hidden field Add hidden in the parentheses in front of your field name Example: User’s email (hidden)

For example, if a field asks for the user’s full name, you’ll have a cell in the first row that says Full name(text). As a result, Formaloo will add a short text field to your form and name it Full name.

Didn’t find the field type you have in your form? Choose the closest field type or suggest/vote on the field types we’re adding to Formaloo in our product roadmap.

How to use Formaloo SDK

Importing your Excel to Formaloo: mistakes to avoid

Two-way sync your formaloo with Google Sheets

How to import Excel or Google Sheet

How to create a custom dropdown of cities