How To Connect Microsoft Forms To Excel Online

‍

‍

To ensure your data flows automatically into Excel Online, you need to establish a "Live Sync." The most reliable way to do this is to create the form from within the cloud environment rather than starting at the Forms homepage.

‍

1. On your Microsoft 365 main dashboard, click OneDrive.
2. Click on Create or upload button to start from scratch.
3. From the dropdown menu, select Excel workbook.
4. On the Excel tab, click on Insert and choose New Form.
5. From the right panel that appears, click on the Open Form button in green.
6. Design your survey in a new tab to automatically generate matching columns in your Excel Online sheet.
7. Return to your Excel tab to confirm the new sheet has appeared.‍
8. You're all set, and the live connection is active.