{"id":10424,"date":"2022-07-25T16:52:36","date_gmt":"2014-04-07T14:12:24","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=10424"},"modified":"2025-03-05T11:19:54","modified_gmt":"2025-03-05T11:19:54","slug":"submissions-are-not-properly-displayed-in-google-docs-what-to-do","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/submissions-are-not-properly-displayed-in-google-docs-what-to-do\/","title":{"rendered":"123FormBuilder submissions are not properly displayed in Google Sheets. What to do?"},"content":{"rendered":"
\n
\n

This usually happens when you have edited your spreadsheet after you have integrated your form with Google Sheets within the form builder<\/a> and received submissions. Once you have received your first submission, a new spreadsheet is created in your Google Sheets account with the name of your form. If you edit the spreadsheet, new entries will no longer be properly displayed in Google Sheets.<\/p>\n

To fix this, export your submissions in CSV<\/a>, copy its content, and paste it into a new spreadsheet in Google Sheets.<\/p>\n

In the future, if you want to edit your spreadsheet, you’ll need to follow these steps:<\/p>\n

1. First, change the names in the column header (label) and make a submission.
2. Reorder the columns as you want and submit the form again. This will prevent the integration from delivering submissions that are not properly displayed in your Google spreadsheet.<\/p>\n

\n

Related articles<\/b><\/p>\n