- twphotogAsked on March 30, 2015 at 03:36 PM
Is there a way to setup a survey so that when all the info gathered shows up properly in Excel, in rows and columns the way you would expect the info to be displayed?
Are there any DOs and DON'Ts? Like DON'T use a matrix, it will NOT list the info as you see it in the matrix, etc.
I couldn't find a specific thread providing this info.
- JotForm SupportdavidAnswered on March 30, 2015 at 03:53 PM
For the most part, data will be populated into your spreadsheet/Google sheet in the order it is received in the form and in the format it is contained in within the form. The exception to this are any widget fields, such as the matrix fields. These fields are treated as one data set and one entry. If a large amount of data is collected in one field in your form, the whole data set will be transferred as if it was one field, regardless of how the field itself is split up. So 100 entries in a single matrix would be treated as a single entry by Excel.
The easiest way to treat it is, if it is a single field added to your form, it will be a single field when added to your spreadsheet. Even though the Address field is separated to many different small parts, it will still be placed into the spreadsheet in one entry. It will not be split to city, state etc.
I hope I made things a bit more clear, if you have any further questions, let us know and we will be happy to help.