Export Word (fillable) Form data to Excel

[Kaycee831]

hi there, Could someone guide me how I can export data from a fillable Word form into excel to analyse the results please?

I have a membership survey with over 40 questions.

For each question, the respondent will have to fill out 2 text columns (evidence/improvement) - 1 ranking column (1 to 5) and 1 checkbox column (tick).

Obviously excel would be perfect for this, however it has to be sent out in Word.

I've read that Word fillable forms can export data to excel to analyse/chart the responses. I've viewed some of the youtube guides, but they don't seem to work for me.

any help is much appreciate.

regards

PS: apologies if this has been submitted before, I couldn't find anything in the search.

[thenewkidd]

An example of this survey with the desired outcome of what it should look like would help us better understand what you are looking for.

I'm sure there is away however without an example, we would be shooting in the dark as to what would best fit your needs.

Regards.

[Kaycee831]

Apologies, I should have added more.

Here is the link to the survey https://www.charitygovernancecode.or...es-2020-3.docx

We are a charity and are required to complete this with our Board / Committee members / execs and others.

We've adapted this so it has 2 additional 'response' columns to indicate how each area is ranked and whether it's a priority area, so the table headings looking like this:

Attachment 732514

I'm therefore trying to see if the Word Fillable form would be best to use to export the response into excel.

hope that gives more context?

thank you in advance.