Others

How to Import Excel Scores into Microsoft Forms Quizzes

Rana Garcia Sep 30, 2026 869 views

Question details

The user wants to automatically assign or import calculated quiz scores from an Excel workbook directly into a Microsoft Forms quiz.

How to Automatically Import Excel Scores into Microsoft Forms Quizzes

Product: Microsoft Forms / Microsoft Excel
Device & OS: not provided
Scenario: Attempting to sync or import formula-calculated points from an external Excel file into a Microsoft Forms quiz to automate grading.
Observed behavior: Microsoft Forms lacks a built-in feature to read, link, or import dynamic quiz point values directly from an Excel workbook.

Before you start

Ensure your Excel workbook containing the score calculations is saved online (e.g., OneDrive or SharePoint) so it can be securely accessed by cloud automation tools.

Solution 1Recommended

Use Power Automate to Sync Scores to a Tracking System

Since Microsoft Forms cannot natively import scores from Excel, you can use Power Automate to route the calculated scores to a database, spreadsheet, or email workflow.

Microsoft Forms does not currently support assigning quiz points dynamically from an external Excel file. However, you can bridge this gap by setting up a workflow in Power Automate to read form responses and output the calculated Excel scores elsewhere.

Set up the trigger

Go to Power Automate and create a new automated cloud flow. Set the trigger to 'When a new response is submitted' in Microsoft Forms.

Get response details

Add the 'Get response details' action to retrieve the specific answers submitted by the respondent.

Connect to Excel Online

Add an Excel Online action such as 'Get a row' or 'Update a row' to cross-reference the submitted answers with your pre-calculated Excel score table.

Send the results

Add a final action to output the calculated score, such as 'Send an email (V2)', to notify the respondent of their Excel-calculated final grade.

Use Power Automate to Sync Scores to a Tracking System

Note on MS Forms Limitations: This automation method will not display the updated score directly inside the Microsoft Forms UI, but it effectively communicates the final computed score to the user.

Solution 2

Submit a Feature Request to Microsoft

If your workflow strictly requires the scores to appear inside the Forms interface itself, requesting the feature directly from Microsoft is the best course of action.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Management with WPS Office

While Microsoft Forms has integration limitations, managing your complex formulas, scorecards, and data tracking is effortless with a reliable spreadsheet tool. WPS Office provides a robust, free alternative to Microsoft Office, ensuring your data is always accessible and easy to calculate.

1. Download WPS Office: Visit the official WPS website and download the free version of WPS Office.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing .xlsx files containing your score formulas.
3. Manage Data Easily: Utilize the highly compatible calculation engine to track and manage student or employee scores efficiently.

Highly compatible with Microsoft Excel formats (.xlsx, .xls) ensuring all your score calculations work perfectly.Lightweight, fast-loading software that runs smoothly on Windows, Mac, and Linux.Built-in advanced formulas and data analysis tools for complex grading and score tracking.Free to download and use with a familiar, easy-to-navigate tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can I link a Microsoft Form directly to a specific cell in Excel?

No, Microsoft Forms only exports data to a new row in an Excel table for each submission. It cannot map responses to specific pre-existing cells or read data directly from them to display inside the form interface.

Will Microsoft Forms automatically grade quizzes?

Yes, Microsoft Forms has a built-in quiz feature where you can set correct answers and assign point values manually for each question during the form creation process. However, it cannot pull these point values dynamically from an external Excel file.

Is Power Automate free to use for syncing Forms and Excel?

Power Automate offers a free tier included with many standard Microsoft 365 personal and educational accounts, which is generally sufficient for basic Forms to Excel automations. Utilizing premium third-party connectors may require a paid license.

Office Quick Solutions