Forum Discussion

Copper Contributor

Oct 10, 2018

Additional columns added to Form results in Excel

When viewing responses to a Forms file in Excel, it appears that if a question was edited in the creation process, each edit is it's own column. For example, in the attached screen shot you can see ...

microsoft forms

Survey

TorrieB4224

Copper Contributor

Feb 28, 2023

Hello Daniel Kronstadt,

Was your question ever addressed?

Mandy_Fowler
Copper Contributor
Nov 15, 2023
TorrieB4224 I have this same problem and am seeking a response; do you have any guidance please?
- Robert_Wst
  Copper Contributor
  Dec 21, 2023
  Mandy_Fowler
  Hit the 3 dots, and sync all to a new workbook.
  - Octofinger
    Copper Contributor
    Feb 18, 2025
    Thank you, this solved my issue with columns being a mess across rows. The new workbook synchronized all the answers and looks as it was supposed to.
ILO-12
Copper Contributor
Aug 16, 2023
TorrieB4224
We have the same issue of Additional columns added to Form results in Excel
and would like to know how to remedy it to stop the extra columns showing in the spreadsheet answers please.

https://techcommunity.microsoft.com/t5/microsoft-forms/additional-columns-added-to-form-results-in-excel/m-p/269635

https://answers.microsoft.com/en-us/msoffice/forum/all/forms-with-duplicate-columns-and-information-added/3e6f5ef0-f96c-4dc0-870d-af2d487d7023

Thanks