How can I make a different format for the data exported to Google Sheet?

  • Sean
    Asked on November 9, 2018 at 11:19 AM

    Hello, 

    I'm building out a form here; when I export all of the submissions to Google Sheets, it lists all line items on the top row.

    The form I'm building has several submission fields, so the excel sheet is quite long. Do you know how I can change the way the data is displayed on Google Sheets (Ex, make the line item headings in column A instead of Row A)?

    Thank you!

  • AshtonP
    Replied on November 9, 2018 at 12:50 PM

    When a form is integrated with Google sheet it always looks for the column headers. From there, the for new record gets added to the new row. The key here is the column names used in the spreadsheet. The integration will only work if the column names match the form fields, all succeeding submissions will map the appropriate fields.

    For this reason, you cannot alter the data in Google Sheet. However, you may do this by downloading submissions in Excel format, then use its inbuilt functionality to copy the column data into rows. I found an article on how to achieve this - https://www.timeatlas.com/switch-excel-columns-rows/