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