-
Distributions TeamAsked on June 26, 2024 at 9:08 AM
Hello! Is it possible to export all the information to Google Sheets in separate columns and not all in the same column/row? Even better if they can be exported to columns that have already been established by the previous questions in the sheet.
For example: a father is filling in the form for his family. He writes his full name in the first question. When he is filling in the configurable list with the kid's full names, can that data be sent directly into a single 'Full Name' column in Google Sheets? Thank you!
-
Jovito JotForm SupportReplied on June 26, 2024 at 9:26 AM
Hi Distributions Team,
Thanks for reaching out to Jotform Support. I checked and tested Google Sheets on my demo form and unfortunately, it is not possible to separate the children's names into different columns. This is because the information are collected in one widget. Check out the image below:
Here is the result when you integrate the form with Google Sheets:
If you want to separate this information into different columns, you need to download the submissions in Excel and manually separate the names to different columns. We also have a guide on How to Download Form Submissions as Excel, CSV, or PDF that you can check.
Give it a try and let us know how it goes.