Forum Discussion

ExcelAthlete's avatar
ExcelAthlete
Copper Contributor
Apr 19, 2023

Report text data from Microsoft Forms

Hi!   I was wondering how people usually report text feedback they've received from a Microsoft Forms Survey. I feel like I have a pretty simple problem that should be prevalent but I can't really ...
BI & Data Analysis
excel
office 365
Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 19, 2023

Hi ExcelAthlete 

 

TBH I'm not clear re. what you're asking - might be due to my lack of knowledge of Word's MailMerge functionnality

The following is a quick and dirty Power Query approach that does "This is the text of a report that won't change and should only be once at the top of the document"

 

 

(see attached file) Does this help?

  • ExcelAthlete's avatar
    ExcelAthlete
    Copper Contributor
    Apr 19, 2023

    Hi!

    Thanks a lot for your reply! Technically the list would be what I'm looking for. By "technically" I mean the data itself is there and in the right order as well but I need to be able to format it similar to how I could do it in Word. The "Feedback" can be a few hundred words in multiple paragraphs so having this in Excel will make it unreadable. Furthermore I already have a report in Word that gets populated by hand but is way too cumbersome to deal with. Sorry I should've maybe mentioned this in the beginning.

     

    What the Word "Mailings" function essentially does is enable you to set up a "template" that gets populated with data from an excel sheet over and over, but unfortunately it seems very inflexible. So I wanted to know if there's some other way before taking my question to the Word forum.

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Apr 19, 2023
      Not sure I can help you further with this :(( - Sorry

Resources