- Ubbo48Asked on March 13, 2018 at 11:42 AM
I need to output fields of a form to excel. Surely that is standard.
But also standard is that all forms of a repeating section are placed in the same row. This is not clever when one wants to export to a database, e.g. MS access.
So the excel sheet should reflect the layout of the form.
Question 1 AAAAAAAAAAAAAAAAAAAAAAAAAA
Question 2 BBBBBBBBBBBB
Repeating SSSSS TTTTTT RRRR QQQQQQ
YYYYYY ZZ PPPPPPP
should lead to in excel
AAAAAAAAAAA BBBBBBBBBBB SSSS TTTTTT RRRR QQQQQQ
AAAAAAAAAAA BBBBBBBBBBB YYYYY ZZ PPPPPPPP
Can you show me how to achieve that?
- JotForm SupportJohn_BensonAnswered on March 13, 2018 at 01:21 PM
To export form data to Excel, please follow this guide: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel
You can also integrate your form to the Google Spreadsheet. It automatically transfers form data to the Spreadsheet everytime someone submitted to your form. Here's a guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet
Please try it and let us know how it goes. Thank you.
- Ubbo48Answered on March 14, 2018 at 05:01 AM
Your answer does not touch the essence of my question. As I wrote, the standard export to Excel that you link to, is not what I want. May be I should have stated the question more clearly:
I do not want to have all answers of a respondent on a single line in Excel. I should like to have all answer lines of the form in a separate line in Excel
Can you comment on that?
- JotForm SupportVictoria_KAnswered on March 14, 2018 at 08:50 AM
As far as I understood the idea, it seems to be not possible to modify the layout of an Excel Report. We only have export options "questions as columns".
But, as you've mentioned exporting to a database, I can suggest you to send the data using Webhooks integration:
Or to push the data directly to your database:
The process would be just like in the link above, but instead of inserting it to MySQL Database you will insert it to MS Access database.
It might be of help also to check the list of our available integrations as to "database":
Hope this information helps! But, let us know if you need any other assistance as to your JotForms.