Others

How to Create a Compact Testing Matrix Table in Microsoft Forms

Maira Mehtab Sep 22, 2026 868 views

Question details

A user wants to collect combinations of test settings, such as cached and non-cached tests at various sizes, using a compact table-style or matrix layout.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Designing a survey or data collection form that requires users to input multiple combinations of variables in a structured matrix layout.
Observed behavior: Microsoft Forms lacks native support for arbitrary table-style questions, preventing users from creating compact testing matrices directly within the form.

Before you start

Before designing your data collection tool, clearly map out all the required variables and combinations to determine if a simple form workaround will suffice or if a dedicated spreadsheet is necessary.

Solution 1Recommended

Use a Likert Scale for Simple Matrix Layouts

While arbitrary tables are unsupported, the Likert scale question type provides a basic grid format that can be used for single-choice testing matrices.

The Likert scale is the closest built-in feature to a table format in Microsoft Forms. It allows you to set rows as one set of variables (e.g., test sizes) and columns as another (e.g., cached vs. non-cached). Keep in mind that this only supports radio button selections, not text entry.

Add a new question

Open your Microsoft Form, click 'Add new', and select the dropdown arrow to reveal more options. Choose 'Likert'.

Define your statements and options

Enter your test scenarios (e.g., 10MB, 50MB, 100MB) in the 'Statements' rows, and your settings (e.g., Cached, Non-Cached) in the 'Options' columns.

Preview the layout

Click 'Preview' at the top of the screen to ensure the matrix layout accurately captures the combinations you need to test.

Solution 2

Split the Matrix into Sections and Separate Questions

If you need users to input text or multiple answers per combination, break the matrix down into sequential form sections.

Solution 3

Use Alternative Tools for Arbitrary Table Layouts

For true, compact testing matrix data collection, bypass Microsoft Forms and use a tool designed for tabular data, such as Excel Online or Power Apps.

Free Microsoft Office alternative

Need a Better Way to Collect Matrix Data? Try WPS Office

When standard online forms limit your ability to create compact testing matrices, WPS Spreadsheet offers robust table layouts, advanced data validation, and easy file sharing. It is a highly compatible, free alternative to Microsoft Office that gives you complete control over your data structures.

1. Download and install WPS Office: Visit the official WPS Office website and install the free software suite on your device.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet and create a new blank workbook to design your data collection table.
3. Build your matrix: Set up your testing variables across rows and columns, apply data validation rules, and share the file with your team for direct input.

Easily design custom table layouts for complex testing matrix dataSeamlessly compatible with Microsoft Excel formats (.xlsx)Lightweight installation with a familiar, user-friendly interfaceAdvanced data validation to ensure accurate data entry from your teamFree to download and use for essential office productivity tasks

microsoft office alternative - wps office

Frequently Asked Questions

Can I embed a fillable Excel table directly into Microsoft Forms?

No, Microsoft Forms does not support embedding fillable tables or interactive Excel sheets directly into the form. You can only provide a hyperlink to a shared Excel file in the form's description.

What is the closest feature to a matrix table in Microsoft Forms?

The Likert scale question type is the closest alternative. It creates a grid layout allowing users to select one option per row, but it does not support text entry or multiple selections per cell.

How can I request Microsoft to add the table feature?

You can request new features by visiting the Microsoft Forms feedback portal and submitting a formal request for arbitrary table-style questions.

Are there other Microsoft 365 apps better suited for matrix data?

Yes. Excel Online is ideal for manual grid entry, Microsoft Lists is excellent for structured row-by-row data, and Power Apps allows you to build custom, highly specific table-entry interfaces.

Office Quick Solutions