Others

How to Collect Revenue by Country Data in Microsoft Forms

Nimra Malik Oct 12, 2026 869 views

Question details

The user needs a way to collect a selected country and its corresponding revenue amount together in a single section within Microsoft Forms.

How to Collect Revenue by Country Data in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Designing a survey or data collection form to gather financial figures tied to specific geographical regions.
Observed behavior: Microsoft Forms does not offer a dedicated paired question type (like a matrix with text input) to directly link a country dropdown with a revenue amount field in a single question block.

Before you start

Before modifying your form, compile a list of all the target countries you want respondents to choose from, which will make setting up the options much faster.

Solution 1Recommended

Use Paired Choice and Text Questions

Since Microsoft Forms lacks a multi-field question type, the most effective workaround is to place a Choice question for the country immediately followed by a Text question for the revenue amount.

By grouping these two distinct question types together, respondents can intuitively provide both pieces of information sequentially. You can repeat this sequence if you need to collect multiple data points from the same respondent.

Add a Choice Question

Open your form, click 'Add new', and select 'Choice'. Enter a prompt such as 'Select a Country' and list your target countries in the option fields.

Add a Text Question

Click 'Add new' again and select 'Text'. Enter a prompt such as 'Enter the revenue amount for this country'.

Organize and Repeat

If you need respondents to input data for multiple countries, use the 'Copy question' button to duplicate both the Choice and Text questions. You can also use 'Add new' > 'Section' to visually group each country-revenue pair.

Export for Analysis

Once responses are collected, navigate to the 'Responses' tab at the top of your form and click 'Open in Excel'. The country and revenue data will appear in adjacent columns for easy analysis.

Data Validation: To ensure accurate data entry, click the three dots (More settings) on your Text question, select 'Restrictions', and choose 'Number' to prevent users from typing text in the revenue field.

Free Microsoft Office alternative

Analyze Your Form Data with WPS Office

While Microsoft Forms requires workarounds for complex data collection, analyzing your exported data is straightforward with WPS Office. As a free, lightweight suite, WPS Spreadsheet handles Excel files seamlessly, making it easy to analyze revenue by country.

1. Download Form Data: In Microsoft Forms, go to the Responses tab and click 'Open in Excel' to download your .xlsx file.
2. Open with WPS Spreadsheet: Launch WPS Office, open the Spreadsheet application, and load your downloaded Excel file.
3. Analyze Data: Select your country and revenue columns, navigate to the 'Insert' tab, and click 'PivotTable' to summarize the total revenue by region.

Free and lightweight office suite for all your daily tasksFully compatible with Microsoft Excel (.xlsx) formats exported from FormsFamiliar user interface for easy data analysis and PivotTablesSeamless migration of your exported data with no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I collect multiple country-revenue pairs in a single question in MS Forms?

No, Microsoft Forms does not currently support matrix-style questions with text input fields. You must create separate sequential Choice and Text questions for each entry.

How do I ensure respondents enter a valid number for the revenue?

When creating the Text question for the revenue amount, click the three dots (More settings) in the bottom right of the question box, select 'Restrictions', and set the condition to 'Number'.

How does the paired question data look when exported to Excel?

Each question in your form corresponds to a column in the exported Excel spreadsheet. The Choice question for the country and the Text question for the revenue will appear in adjacent columns, organized row by row for each respondent.

Office Quick Solutions