Export your Formli responses data into CSV-file or Google Tables
How it works
Formli enables users to export response data either through an automatically updating Google Sheet or by downloading a CSV file. To use Google Sheets, you need to copy and paste an import code from Formli into your Google Sheet. This will allow your Google Sheet to automatically populate with new responses every hour, so you won’t have to manually update your record.
You can also embed the response view table directly into the website using HTML Forms custom code.
Setup Guide
You have the option to export your responses from the individual Formli, in which case your export file will contain all columns from each block, as well as the Formli name and response date. Alternatively, you can export responses or payment data from the Responses page, allowing you to select which columns you want to include.
Export responses for specific Formli
Export responses from Response View (for all Formlis or specific columns)
Export responses to the webpage using HTML Forms
Export responses for specific Formli
- Open the Formli editing page. Open
Moremenu and then click onExport responsesbutton - Click on the
Generate Response Viewbutton to create a response view for this Formli. This will generate a response view with all the necessary columns automatically, saving you from having to add them manually. In the response view, you can add, delete, or edit columns as needed, and then export the data from theResponsespage. - Click on
Download CSVbutton. As the result you will receive CSV file which will include all received responses block by block. - To export your Formli responses directly to Google Sheets, click on the
Copybutton. Then, paste the formula into your Google Spreadsheet, and the data will automatically update every hour.
Click into the top left cell (A1) and paste in the code (either by right clicking or typing ctrl+v)
Export responses from Response View (for all Formlis or specific columns)
- Go to
Responses - Open or create a view that contains the data you want to export. How to create and edit responses views see here
- Click on
Exportbutton. - Click on
Download CSVto download the export file. It will contain the same columns as your response view.
or click on Copy button to copy the code for Google Sheet.
Export responses to the webpage using HTML Forms
You can embed the response view, including all settings and data, into your website using HTML Forms. The os-table custom component generates a table and will keep it in sync with your response view.
To do this, copy the code below and replace view_uuid with the ID of your response view, which can be found in the URL. Then, insert this code inside the <body> tag:
<os-table data-os-element="loop" data-os-view="view_uuid"></os-table>
<head> tag (see guide here)