Microsoft Forms can connect responses to an Excel workbook, but “live” depends on how the form and workbook were created and which sync experience they use. Microsoft announced the expanded Excel workflow on June 28, 2024; its current support guidance covers several form-creation paths, while later notices document changes to sync and migration for older workbooks.
What changed in the June 2024 Microsoft Forms update?
Microsoft said Forms data sync to Excel was fully available with additional capabilities on June 28, 2024. The central option is to start a form from Excel for the web: choose Insert > Forms, then create the form in the Forms experience that opens. Questions and responses connect to the workbook. The workflow supports worksheets stored in OneDrive or SharePoint. Microsoft Forms Blog: Forms data sync to Excel is now fully available with more functionality
The June 2024 rollout dates and account availability statements in that announcement are historical. They should not be read as a current promise that every Forms workbook, Excel client, or account type behaves identically.
How do I sync Microsoft Forms responses to Excel?
Choose the route that matches where the form starts and who needs to work with its results. Microsoft Support currently describes live-connected workbooks for forms created from OneDrive for work or school, SharePoint Online, Excel for the web, Teams, or the Forms web part. It also covers Microsoft 365 group forms and Power Automate workflows. Microsoft Support: Can I get real-time updates in my Excel workbook?
#1 Best Overall
- Over 215 Microsoft Windows Excel Shortcuts
- Two-Sided Durable Laminiated Sheet
- Designed for Excel on a Windows Computer
| Starting point | Storage and access fit | What to know |
|---|---|---|
| Excel for the web: Insert > Forms | OneDrive for an individual form, or SharePoint for a team workflow | The form opens in Forms; questions and responses sync with Excel. This create-from-Excel path supports worksheets in OneDrive and SharePoint. (Microsoft Forms Blog, June 28, 2024) |
| OneDrive for work or school | OneDrive | Microsoft Support lists this as a supported live-connection context. For personal access in the June 2024 guidance, OneDrive was the suggested location. (Microsoft Support; Microsoft Forms Blog, June 28, 2024) |
| SharePoint Online or a Microsoft 365 group form | SharePoint; suited to shared team work | The June 2024 announcement says group-form workbooks are saved in SharePoint. Support also lists SharePoint Online and Microsoft 365 group forms among supported contexts. (Microsoft Support; Microsoft Forms Blog, June 28, 2024) |
| Teams or the Forms web part | Depends on the connected form and workbook | Microsoft Support lists these as supported form-creation contexts; confirm which workbook is connected before relying on it for analysis. (Microsoft Support) |
Share the workbook separately when coworkers need the results
For a group form, the workbook is saved in SharePoint. The June 2024 announcement says coworkers who need to inspect or analyze its syncing responses should be given the Excel link; access to the form response page alone does not provide access to the syncing workbook. Share the workbook with the appropriate people using the relevant OneDrive or SharePoint permissions.
Can I get real-time updates in my Excel workbook?
Microsoft Support answers: “Yes, you can get live updates about your forms without checking each one individually.” That describes the supported connected-workbook experience, not a guarantee that every client continuously refreshes every workbook in the background.
Rank #2
- Instant Copilot. Unlock new possibilities with the dedicated Copilot key, which gives you instant access to experiences that can enhance your productivity¹.
- Enhance your experience With the new microphone mute key and snipping key
- Full keyboard experience. Features a full mechanical keyset, backlit keys, and a large trackpad for precise navigation and control. Optimal key spacing allows fast, fluid typing.
- Slim and compact Performs like a traditional, full-size keyboard.
- Clicks in place instantly Use in combination with the Surface Pro (11th Edition), Pro 9 and Pro 8* kickstand for a perfect laptop experience anywhere.
Microsoft’s July 17, 2024 Message Center notice MC816207 gave a more specific condition for the original workflow: “New responses will automatically sync while the workbook is open in Excel for the web.” It also described coauthor updates there. In that workflow, Excel for the web was the relevant open workbook; do not assume that having desktop Excel open alone triggers the same sync. Microsoft 365 Message Center Archive: MC816207
A later notice described a newer sync solution, so the exact trigger depends on whether a workbook uses the original or newer connection. Microsoft’s September 30, 2024 notice MC901820 said that, under the announced newer workflow for OneDrive and SharePoint forms, after responses arrive users create the Excel workbook from the Forms results page; sync is triggered in Excel for the web. Desktop Excel receives data after the web workbook syncs. Microsoft 365 Message Center Archive: MC901820
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Rank #3
- EXCEL SHORTCUTS. ZERO SEARCHING. – Our bestselling reference mat puts an extensive collection of commonly used commands, formulas and helpful tricks directly beneath your fingertips so you can find answers fast, work smarter and stay in the flow.
- YOUR DESK. SMARTER. – Clearly organized sections for navigation, selection, formatting, data and functions make it easy to find the right Excel command exactly when you need it.
- LEARN, WORK & RESET – Built-in desk-exercise diagrams give you 10 quick ways to stretch, recharge and return to work feeling sharper.
- ROOM TO WORK & CREATE – The extended 31.5 x 11.8-inch Pixiecube desk mat fits a laptop or keyboard and mouse, while the soft 2 mm surface adds comfort and protects your desktop.
- BUILT FOR REAL-WORLD WORKDAYS – A rugged stitched edge helps prevent fraying, and the water-resistant, stain-resistant surface protects against scratches, spills and everyday wear—because smarter desks should work harder.
Why is my Forms spreadsheet not updating?
Check the connection and sync path before treating the workbook as broken. The first diagnostic question is whether you are opening the workbook connected to the form, rather than a downloaded copy or a separate export.
- Identify where the form was created. Check whether it began in Excel for the web, OneDrive for work or school, SharePoint Online, Teams, the Forms web part, or a Microsoft 365 group. Microsoft Support lists these contexts for live-connected Excel workbooks.
- Open the connected workbook in Excel for the web. The original MC816207 workflow tied automatic syncing to the workbook being open there. A newer workflow also uses Excel for the web as the sync trigger.
- For a newer OneDrive or SharePoint workflow, create the workbook from Forms results if needed. MC901820 described creating the Excel workbook from the Forms results page after responses were received. Then allow the web workbook to sync before expecting the data in desktop Excel.
- Check whether the workbook uses the older sync solution. Microsoft’s migration notice said older-sync workbooks would stop receiving new responses after the 2025 retirement dates unless migrated. Those dates are past; if an older workbook has stopped updating, follow Microsoft’s current migration guidance rather than relying on the historical rollout schedule.
- Review automations that expect unattended updates. Microsoft warned that workflows depending on automatic updates without user action would be affected by the older sync retirement and suggested Power Automate. Microsoft Support also describes Power Automate workflows, but the right flow depends on the required trigger and destination.
- Confirm access to the file. For team use, make sure collaborators have the Excel link and the necessary SharePoint or OneDrive access; permission to view form results does not by itself grant workbook access.
Microsoft’s August 8, 2024 notice MC855685, updated January 22, 2025, is historical migration guidance. Its key practical point is that the older sync path had retirement milestones and unattended-update workflows could be affected; it is not a current schedule for all Forms workbooks. Microsoft 365 Message Center Archive: MC855685
Quick Recap
Best Value
- 💻 ✔️ EVERY ESSENTIAL SHORTCUT - With the SYNERLOGIC Reference Keyboard Shortcut Sticker, you have the most important shortcuts conveniently placed right in front of you. Easily learn new shortcuts and always be able to quickly lookup commands without the need to “Google” it.
- 💻✔️ Work FASTER and SMARTER - Quick tips at your fingertips! This tool makes it easy to learn how to use your computer much faster and makes your workflow increase exponentially. It’s perfect for any age or skill level, students or seniors, at home, or in the office.
- 💻 ✔️ New adhesive – stronger hold. It may leave a light residue when removed, but this wipes off easily with a soft cloth and warm, soapy water. Fewer air bubbles – for the smoothest finish, don’t peel off the entire backing at once. Instead, fold back a small section, line it up, and press gradually as you peel more. The “peel-and-stick-all-at-once” method only works for thin decals, not for stickers like ours.
- 💻 ✔️ Compatible and fits any brand laptop or desktop running Windows 10 or 11 Operating System.
- 💻 ✔️ Original Design and Production by Synerlogic Electronics, San Diego, CA, Boca Raton, FL and Bay City, MI, United States 2020. All rights reserved, any commercial reproduction without permission is punishable by all applicable laws.
Rank #4
- Efficient Media Controls: The Wired Keyboard 600, designed by Microsoft, features a Media Center with four hot keys for easy control of play/pause, volume up, volume down, and mute functions.
- Quiet and Responsive Keys: Enjoy a comfortable typing experience with quiet, thin-profile keys that are both responsive and efficient.
- Convenient Shortcuts: Quickly access common tasks with dedicated shortcut keys, including a calculator hot key and a Windows start screen key.
- Spill-Resistant Design: Work confidently with a spill-resistant design that protects your keyboard from accidental messes.
- Plug-and-Play Simplicity: No software needed—just connect the keyboard to your PC and start using it right away, with a full number pad for efficient data entry.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
