Microsoft Forms backup: export structure & responses

If you need a reliable way to preserve a Microsoft Form and its answers before deleting, moving, or archiving it, do three things: copy the form to preserve its structure, export responses to Excel and store that workbook in OneDrive or SharePoint, and (if the form will keep collecting responses) add a Power Automate flow to capture new submissions. This article gives the exact permissions and prerequisites, step-by-step manual instructions to copy a form and export responses, a Power Automate pattern to record new responses, how to rebuild a form from backups, and the common pitfalls that cause loss. Follow the steps that match your scenario and keep backups in a versioned SharePoint/OneDrive folder so you can revert if needed.

What you need before you start

• You must be the form owner or an Office 365 admin able to access group resources and user data. Group forms are owned by the group; personal forms are owned by the account that created them.
• A storage location with versioning and controlled access: a OneDrive for Business folder you control or a SharePoint document library with versioning and retention enabled.
• Power Automate license that supports the Microsoft Forms connector and writing to Excel/SharePoint (your tenant may require a paid plan for advanced connectors or larger volumes).
• An Excel workbook stored in OneDrive/SharePoint that contains an Excel table (not just a sheet) if you plan to write responses into a table.
• Practical limits and caveats to accept: there is no single built-in “export form as one file” that includes both structure and responses; exported responses go to an Excel file you download, and very large forms or long-running response collections may hit export or connector limits. I don’t have tenant-specific limits for your environment; check your admin center if you expect huge volumes.

Example: as a teacher, create Backups/Forms in your OneDrive for Business and name files like Course2026_FormName_Responses.xlsx. Keep a copied form in Backups/Forms/FormsCopy (a duplicate you own) so you can reopen or reuse the structure later.

Quick manual backup: copy the form and export current responses

1. Open Microsoft Forms and sign in with the account that owns the form.
2. Locate the form you want to preserve and click the three-dot menu (More options).
3. Select Copy to save a new form you own that preserves questions and settings.
4. Rename the copied form so it’s clearly a backup, for example FormName_backup_2026-10-30.

copying a form does not copy existing responses; export responses separately.

5. Open the original form and go to the Responses tab.
6. Click Open in Excel to download an .xlsx file that contains all current responses and a header row.

FormName_Responses.xlsx

7. Move the downloaded Excel file into your OneDrive for Business or a SharePoint library. Use a clear file name that includes course, form, and date, for example:

Course2026_FormName_Responses.xlsx

8. In SharePoint or OneDrive, enable versioning and, if available, set a retention policy for the backup folder so old exports are preserved automatically.

Completion: you now have a copied form that preserves the structure and an Excel file in OneDrive/SharePoint with responses and timestamps.

Automate ongoing backups using Power Automate

1. Create or open a Power Automate flow and choose the trigger When a new response is submitted (Microsoft Forms).
2. In the trigger, pick the form from the Form Id drop-down or paste the form's id if it isn't listed.
3. Add the action Get response details and set the same Form Id and the Response Id from the trigger.
4. Decide how to store responses: write a row to an existing Excel table or append to a CSV/JSON file in OneDrive/SharePoint. If you use Excel, the file must be in OneDrive/SharePoint and the worksheet must contain an Excel table with a header row matching the columns you will write.

if your flow writes headers or recreates the table on each run you can end up with duplicate header rows. Create the table once and write rows only.

5. To add a row to Excel, use Add a row into a table (Excel Online (Business)) and map each form question from Get response details to the corresponding table column.
6. Alternatively, to append to a CSV file, read the existing CSV and write back the combined content, or append a line to a text file. Include a header line once.
7. Optional: add an action that converts HTML or a Word template to PDF and saves the file to OneDrive/SharePoint if you need a snapshot copy.

Practical tips:

• Use the form’s internal id rather than form name when possible; names change and can break flows.
• Create the Excel table with columns for every question plus ResponseId, SubmittedDate and any metadata you care about.
• Test the flow with a few sample submissions and check the table for correct mapping and no header duplication.

ResponseId
SubmittedDate
ResponderEmail
Question1
Question2
...

Completion: each new form submission is recorded to your Excel table or CSV in the chosen OneDrive/SharePoint folder.

How to restore or rebuild a form from your backups

Restoring responses for analysis

Open the saved Excel workbook in OneDrive or SharePoint. The downloaded Excel file from Microsoft Forms or the file created by Power Automate contains responses; timestamps and response ids are usually present. Use Excel filters, pivot tables, or Power Query for reporting.

Recreating the form structure

• If you copied the form with Copy, open that copied form and make it active or change ownership by sharing it if required.
• If you only have the Excel file and not a copied form, you must recreate questions manually in Microsoft Forms. Microsoft Forms does not provide a built-in import that reliably reconstructs question types, branching, or settings from a spreadsheet.
• If you own the original form and have a copy, edit the copy to restore branching and settings, then share or move it into the correct group.

Re-associating exported responses to a rebuilt form

There is no reliable built-in way to re-link exported responses back into a new or rebuilt Microsoft Form so responses appear in the Forms interface with original Response IDs. Keep exported responses in Excel for records and analysis. If you need to present responses alongside a recreated form, keep a mapping of ResponseId to answers in your workbook.

Completion: you know it worked when the copied form shows the same questions and settings and the Excel file in OneDrive/SharePoint contains rows of responses with timestamps and response ids (if you saved them).

Common pitfalls and cautions to avoid data loss

• Owner account deletion: if the user who owns a personal form is deleted, the form and its responses can become inaccessible. Copy the form to a safe owner account or make the form a group form owned by a team mailbox before deleting the user.
• Group vs personal forms: group forms are tied to an Office 365 Group. If the group is deleted, forms are at risk. Store backups in the group’s SharePoint and confirm retention policies.
• Response export size and connector limits: very large response sets may fail to export in a single operation or cause Power Automate runs to time out. If you expect high volume, export periodically and use chunked backups.
• File retention policies: copies in a user’s personal OneDrive may be lost if the account is removed. Keep long-term backups in a SharePoint library with retention and versioning enabled.
• Duplicates from flows: poorly designed flows can insert header rows or duplicate entries. Create tables and header rows manually, and ensure the flow writes only content rows.
• Permissions on backup files: ensure only authorized people can edit or delete backups. Use SharePoint permissions and retention labels if required.
• Metadata loss when recreating forms: branching, choice settings, and file upload questions may not translate perfectly if you recreate from CSV. Keep a copied form for exact structure reproduction.

Deleting a form owner account without first copying the form and moving backups can make the form irrecoverable in practice.

Conclusion

Do two things now: make an immediate copy of any form you plan to remove or archive, and export current responses to an Excel file stored in a versioned SharePoint/OneDrive folder. If the form will keep collecting responses, add a Power Automate flow that records each submission into an Excel table or appends to a CSV. Keep a consistent naming scheme and test restoration by opening a copied form and the exported Excel to confirm everything you expect is present.

Frequently Asked Questions

Can I export a Microsoft Form as JSON or a single file that contains both structure and responses?

No. Microsoft Forms has no built-in option that exports both structure and responses in a single file. You can `Copy` the form to preserve structure and export responses to Excel. Some third-party tools or the Graph API can extract structure as JSON, but availability depends on those tools and your tenant permissions.

Will the exported Excel keep timestamps and respondent identifiers?

Yes. The Excel exported directly from Microsoft Forms includes timestamps and a response id or respondent identifier when available. If you use Power Automate to write responses, include `ResponseId` and `SubmittedDate` in your table explicitly to preserve that metadata.

Can I schedule daily automatic backups instead of recording each response in real time?

Yes. Create a scheduled Power Automate flow that runs daily, finds new responses since the last run, and appends them to your backup file. For large volumes, break exports into chunks and use incremental checks to avoid timeouts.

What should I do if a form owner leaves the organization?

Before the account is deleted, copy the form to a safe owner account (for personal forms) or move the form into a group owned by a shared mailbox or team. Export all responses to SharePoint/OneDrive. If the account is already deleted, contact your tenant admin — they may recover content from OneDrive or with eDiscovery depending on tenant retention settings.