Power Query Problems

How to Sort Microsoft Forms Responses with Added Excel Columns

Kushani Nimanthika Sep 30, 2026 870 views

Question details

The user needs to sort an Excel worksheet containing exported Microsoft Forms responses alongside manually added internal columns without breaking the row alignment.

How to Sort Microsoft Forms Responses with Added Excel Columns

Product: Microsoft Excel / MS Forms
Device & OS: not provided
Scenario: Organizing and sorting survey or form data that has been appended with internal tracking or notes columns in Excel.
Observed behavior: Sorting the worksheet only sorts either the original response columns or the added columns independently, causing the dataset to become misaligned.

Before you start

Before proceeding, ensure your Microsoft Forms response data and your added columns are formatted together as a single Excel Table, and save a backup copy of your workbook.

Solution 1Recommended

Use Power Query to Sort and Align the Complete Dataset

Power Query allows you to link the response table and your added columns, sorting them as a unified dataset before loading them back into Excel to maintain strict row alignment.

Because Microsoft Forms maintains an active connection to the original response table in Excel, standard sorting can sometimes decouple manually added internal columns. By routing the table through Power Query, you create a robust, unified view of your data that sorts reliably without altering the original Forms data.

Verify the Excel Table Range

Ensure your forms responses and your newly added custom columns are recognized as a single table. Click any cell within the data, press Ctrl+T, verify the range encompasses all columns, and click OK.

Load the Data into Power Query

Navigate to the 'Data' tab on the Excel ribbon. Click 'From Table/Range' in the 'Get & Transform Data' group to open the Power Query Editor.

Sort the Combined Data

In the Power Query Editor window, locate the column header you wish to sort by. Click the drop-down arrow next to the header name and select either 'Sort Ascending' or 'Sort Descending'.

Load the Results Back to Excel

Once the data is sorted, click the 'Close & Load' button located on the Home tab of the Power Query Editor. This will output a new, fully aligned, and sorted table into a new worksheet.

Use Power Query to Sort and Align the Complete Dataset

Data Integrity Maintained: Using Power Query ensures that any future refreshes of the Forms data will maintain the correct sorting rules and alignment with your custom internal columns automatically.

Free Microsoft Office alternative

Manage Your Spreadsheet Data Seamlessly with WPS Office

While Microsoft Forms and Power Query require specific workflows to keep data aligned, you can easily manage, sort, and analyze survey data using WPS Office. It offers a lightweight, highly compatible alternative for all your complex spreadsheet tasks.

1. Download WPS Office: Install the free WPS Office suite on your device to access WPS Spreadsheet.
2. Open Your Data: Open your exported Microsoft Forms .xlsx file directly in WPS Spreadsheet without losing any formatting.
3. Sort Safely: Highlight your combined dataset and use the built-in 'Sort' feature under the Data tab to organize your responses perfectly.

Fully compatible with Microsoft Excel formats including .xlsx, .csv, and .xls.Intuitive data sorting and filtering tools to keep appended survey columns aligned effortlessly.Free and lightweight, avoiding the heavy resource usage of standard Office suites.Familiar user interface makes migrating your daily data workflows seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my added columns misalign when sorting Microsoft Forms data in Excel?

When Microsoft Forms data syncs to Excel, it often treats the original response data as a specific linked table range. If manually added columns aren't properly integrated into that exact Table boundary, Excel sorts the original data independently of your new columns, causing misalignment.

Can I add internal tracking columns directly in Microsoft Forms instead of Excel?

No, Microsoft Forms is designed strictly for data collection and survey presentation. You cannot add internal hidden columns, grading rubrics, or tracking fields within the form itself. All post-submission data management must be done in the exported Excel workbook.

Does using Power Query permanently alter my original Forms response data?

No, Power Query only reads the data from your source table. It processes the sorting and formatting in the background and outputs a brand new table, leaving your original Forms data link completely untouched and capable of receiving new responses safely.

Excel & Data Problems