How To Export Word Form Data Fields To Excel

__________
TEMPLATES
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
RESOURCES & GEAR
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
__________
FREE DOWNLOADS:
__________
CONNECT WITH ME:
__________
KEYWORDS: #MSWord, #MSExcel, How To Export Word Form Data To Excel, How To Export Data From A Word Form To Excel, Export Word Form Data To Excel, Exporting Word Form Data To Excel, Word Advanced Save Options, Save Form Data As Delimited Text File, Get Data As Text/CSV, Excel Power Query Editor, Load Excel Data, Import Data To Excel, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:

[adnanpramudio]

Seriously sharon, this is what I am looking for lately, thank you!

[Flowerloveesun]

This is really helpful Sharon, want to add on your process to take it to the next level. We can put the text files in a single folder, the power query can extract data from all the files in that folder and then by appending the data we can get a single master table. By this steps we can even eliminate the recurring connection and copy paste steps :-)

[ijvega]

This is a very helpful video and just what I needed as I was stuck with over 30 templates to design for a client. Thanks very much, Sharon.

[itsjenga]

Thanks for the very detailed solution! Just what I was looking for.

[MohAboAbdo]

Thank you very much, my esteemed teacher.

[jlfranco]

Well Done Sharon, you're really a master on excel!

[pierrickdefossez]

Thank you Sharon. How do you deal with checkboxes and radio buttons?

[markk]

Excellent Video, Thank you.
I have a complexity: I need to transform data from the original file download - so copy/paste does not work.
I created several Excel tabs for each form, Form1, Form2, Form3 ... Then I used PowerQuery to join the current workbooks into a new tab. From there I create a "begins with" Form text filter so that each new Form added (Form4) is recognized by the query.

[dennismwangi]

Again very helpful. Word fields are very powerful features that many Word users may not know how to use. Mayb u can make informational videos on how they can be leveraged to improve someone's productivity.

[rebuseg]

Great video! Just what I needed. What if the forms have additional columns and informations sometimes?how to overcome that?

[donnyd]

Can you automate the process of saving a whole folder in that exact way? Thank you for the video but what if I have hundreds coming in?

[joannesmith]

Thanks for your helpful videos! I may not be reading the comments below correctly (I'm not an Excel guru by any stretch of the imagination.), but once I receive the data from individual form submissions, how can I export that data to an Excel spreadsheet? Or.. is there a particular code I could insert to make that happen?

Also, if I convert this form into a PDF form for those users who do not have Excel, can I collect data that way somehow? And finally, is there anything I can do to aid users who do not have Outlook?

Thanks for your help.

[matternkaren]

Could you please create one on userforms and capturing data into a table please and thank you for your videos, very helpful and easy to understand.

[magnetm]

This nice..
I want to create a button when the end user pressed the filled data will be in excel file

[ECCLESIAOFBURNINGONESS]

Thanks so much for your video. Unfortunately i am unable to locate "save a copy" on my imac. Help please?

[susannem]

Thank you for the video, it was super easy to understand. I tried it out but had problems when importing the data. The different fields were always shown below each other and not as columns. What do I do wrong?

[tetiesessoms]

Is there a way to add multiple files at once?

[erictsang]

Sharon,

thanks for your footage, and i think you can use Power Query by Upload folder !

[dlt]

when i try to save the document as a text file I get a file conversion dialog box and it does not show any of the data. the same occurs when i attempt to open the text file in excel. I have attempted created the form fields within tables and with out with the same result

[archieandlilysworld]

Is there anything else you can do, that collects data from a word booking form to excel database? This video is the closest I’ve seen. Thanks Sharon