When a form contains a table, you can export the table data into a clean, row-per-entry spreadsheet. This makes it easier to process timesheets, reimbursements, inventories, and other multi-row submissions without needing manual formatting or macros.
Exports include both the table rows and any additional fields you choose to include for context (such as employee name, ID, approver, etc.).
In this article, we will review:
How to Export Table Data
Navigate to your form's Responses page.
Select the submissions you want to export.
You may select individual submissions or use Select All.
Click Download in the top-right corner and choose As a Spreadsheet
-
After selecting "As a spreadsheet,” you will see a pop-up to start selecting which fields to export.
Under the Table, select the specific columns you want to include in the export.
You may include all columns or only the ones you need for your export
Under Additional Fields, choose any fields outside the table that should appear in each exported row.
What to expect in your spreadsheet export
Each row in your table becomes one row in your spreadsheet.
All selected additional fields will be repeated on each row so data remains tied to the correct submission.