How To Export Word Form Data Fields To Excel

Рет қаралды 115,776

3 жыл бұрын

HOW TO EXPORT WORD FORM DATA FIELDS TO EXCEL // Learn to take your completed forms and import responses into Excel for ease in tracking and analyzing the data. In this video we cover how to save your Word form data as a delimited text file that is easily imported into Excel and then use Power Query editor to modify columns. This video will show you a way that you can create a spreadsheet of your form field responses. This method is helpful when you want to track form responses on a spreadsheet and you get a few new responses on a regular basis. If you have a lot of data from forms or surveys that you want to export and compile in Excel, be sure to watch my video on How To Create Google Forms so you can easily export response results to Excel: • How To Create A Fillab...
__________
TEMPLATES
Check out my helpful list of templates available for purchase: www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
RESOURCES & GEAR
✦ Screen Recording Software: techsmith.z6rjha.net/NZG5b
✦ Green Screen: amzn.to/2DnHsY2
✦ Camera: amzn.to/39KvpQA
✦ PresenterMedia: shareasale.com/r.cfm?b=417324...
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!
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
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:
➤Creating Fillable Forms: • How To Create A Fillab...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist

Пікірлер: 74

@Flowerloveesun 3 жыл бұрын

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 :-)

@SharonSmith 3 жыл бұрын

Great tip!! Thanks for sharing. I'll have to work on a video for that. Thanks for watching!

@angelamitres9478 Жыл бұрын

This is what I did but do you know how to have the data upload into excel with the new data uploading at the bottom not alphabetically?

@lanamantaray9399 11 ай бұрын

How do you exactly do this?

@adnanpramudio6109 3 жыл бұрын

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

@SharonSmith 3 жыл бұрын

Glad to hear it, Adnan! Thanks so much for watching and taking time to leave a comment!

@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.

@SharonSmith Жыл бұрын

So glad to hear you found my videos helpful! Thanks for watching. Good luck with your project!

@MohAboAbdo 3 жыл бұрын

Thank you very much, my esteemed teacher.

@SharonSmith 3 жыл бұрын

You are very welcome! Thank you for watching my videos!

@itsjenga Жыл бұрын

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

@SharonSmith Жыл бұрын

Glad to hear you found it helpful! Thanks for watching!

@pierrickdefossez3157 2 жыл бұрын

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

@jlfranco1 7 ай бұрын

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

@SharonSmith 7 ай бұрын

Thanks so much for your kind words! Glad you found my videos helpful!

@dennismwangi3573 3 жыл бұрын

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.

@SharonSmith 3 жыл бұрын

Hi Dennis - that is a great suggestion! I will work on more videos! Take care!

@markk364 2 жыл бұрын

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.

@donnyd2823 3 жыл бұрын

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?

@tetiesessoms1300 3 жыл бұрын

Is there a way to add multiple files at once?

@rebuseg Жыл бұрын

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

@matternkaren 3 жыл бұрын

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.

@SharonSmith 3 жыл бұрын

Hi Karen! Great suggestion, thank you! I'm glad you found my videos helpful. Thanks for watching!

@yoryopower2908 3 жыл бұрын

Thank you.

@SharonSmith 3 жыл бұрын

You're welcome! Thanks for watching my videos!

@joannesmith7733 Жыл бұрын

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.

@magnetm399 3 жыл бұрын

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

@susannem6302 3 жыл бұрын

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?

@gromtoke 2 жыл бұрын

I had similar issues.

@ECCLESIAOFBURNINGONESS Жыл бұрын

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

@erictsang789 3 жыл бұрын

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

@SharonSmith 3 жыл бұрын

Hi Eric! Thanks for the tip! Thanks for watching!

@elviralim1315 3 жыл бұрын

How can i connect two plain text content control

@dlt8596 3 жыл бұрын

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

@vincentvandewalle4110 3 жыл бұрын

You have 2 kind of controls when you create a form. The controls in the form should be created using the legacy form controls or the Active X Controls. Do not use the default controls of the ribbon. Ribbon > Developer Tab > Group Controls > DropDown Button "Legacy Tools". Use this controls in your template. Hope this is helpful

@pepetrueno8722 Жыл бұрын

Could a macro be created to convert 200-300 completed forms?

@dannyanim7634 2 жыл бұрын

Sharon please am still finding it difficult in importing the data into excel, i would be glad if you could give me the steps in saving it into plain text because i see some dialogue box before .

@m.a.k.9586 Жыл бұрын

I learned 👍

@SharonSmith Жыл бұрын

Awesome! Thanks for watching!

@cogwheelLearning 3 жыл бұрын

Nice one Sharon

@SharonSmith 3 жыл бұрын

Thank you for watching! Glad you found it helpful!

@Dexxyh 3 жыл бұрын

This seems to break once there are apostrophes in the answers. What's the proper way to deal with that?

@manojbagul1927 2 жыл бұрын

please tell me how to do this in Microsoft office 2016

@TheDeedars 2 жыл бұрын

I'm using a Mac and my data showed horizontally vs. vertically. How do I make data by column?

@LiaqatAli-qk8yp 3 күн бұрын

Thanks

@SharonSmith 3 күн бұрын

Thanks for watching!

@c2overcome Жыл бұрын

Does the document has to be text? Can you use dropdown boxes or button selections? I can't get it to expand to more than 1 column.

@MrIgriX 2 жыл бұрын

my word table is exported as a plain text file.

@ezralastimosa1139 2 жыл бұрын

This is what I presented to my manager but it's too techy for them to use this method. Do you know any other methods wherein filling out the Word will make the Excel updated automatically? The disadvantage of this method is when there are changes to the Word you just filled out, the Excel isn't updated yet automatically unless you do the method of extracting data again.

@laikencleary7201 Жыл бұрын

My word document form spans many rows and so I have only 1 column. How do I declare my columns in the world document to then be the "headers" when transferred into my excel worksheet?

@walthenstein 2 жыл бұрын

the save to txt file procedure doesn't create a csv file.

@LisaEidson 3 жыл бұрын

When I click on Import after I've selected a file to import, nothing happens. Anyone know what I'm doing wrong?

@keewei87 3 жыл бұрын

This video is incident by incident. How to add multiple data at the same time?

@archieandlilysworld6590 Жыл бұрын

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

@mohsenuss91 Ай бұрын

How to do that automatically for multiple files? For example, student's answers ?

@polydorosfrantzeskakis9145 Жыл бұрын

Hi Sharon, when saving as txt it does not save any data (office 365). Only works with legacy data.

@user-iy1bn9wu6v 2 жыл бұрын

Mam you go to data and select "get data" option but in my excell these ribbons not show at all, what can i do? I Used Ms office 2013

@dexterrr9163 3 жыл бұрын

I'm losing all my format when I convert to plain text therefore i cant convert it that way

@yellakarikesavacharyulu9738 3 жыл бұрын

Please add VBA Code also for all your previous lessons for developers

@SharonSmith 3 жыл бұрын

Hello! Please be sure to expand the description below my videos. All VBA code (if used in my videos) is included in the expanded description below the respective video. Hope this helps! Thanks for watching!

@bobbielayton6106 11 ай бұрын

When I drop the fillable form into Google Drive, I loose all the legacy tools. I am assuming that Google Drive blocks them, probably because Google Drive has their own fillable forms. Correct?

@tutsecret499 Жыл бұрын

What if I have 100 clients that had test results, each form with result, so I have to copy and paste 100 times? Is there a another way to import the data from different forms at once.

@jamienimmo6935 3 жыл бұрын

More MS Word videos please Sharon... 😊

@SharonSmith 3 жыл бұрын

Will do! Thanks for watching Jamie!!

@bobbielayton6106 Жыл бұрын

Please Help! Following the tasks that you layout in your video is not working for me. At first, I could not get the Word Doc to transfer to Plain Text and when I finally was able to do that all the information uploaded to excel in the first column. I am feeling frustated...thoughts!

@SharonSmith Жыл бұрын

Hello - looks like you found your answer in the comments on using Legacy form fields. Thanks for watching!

@noormohammed6231 2 жыл бұрын

Really a nice teaching.... Can u pls tell us, presently, I have multiple choice questions & 4 choices, with answers, in word file, Ex: who is the CEO of google? 1. Sundar pichai 2. Peter 3. Helen 4. Francis Answer: 1 Now, I want that in excel format,.. Required Excel Format below, Example: No, question, answer, option 1, option 2, option 3, option 4.

@user-sh1hh9wx7i 10 ай бұрын

I don't know why my form data are all saved in the same column. Can anyone explain to me how to split the fills into different columns?

@bobbielayton6106 Жыл бұрын

I figure it out...Legacy buttons must be used. I found it in the comments!!

@SharonSmith Жыл бұрын

I'm glad you got an answer to your question! Thanks for watching!

@tutsecret499 Жыл бұрын

Here is another alternative: set up everything in excel the form and in another sheet, use some macros or xlookup and will pull all the data from the form while the user is answering the form. The another sheet keeps invisible and protected with password, and when you need open it and you will see all the input data. No need to copy, paste, typing, etc. This method I set up 25 years ago using some basic VBA. You don't want to handle manually 17,000 employees survey and entering the survey results manually.

@tophattommy2 6 ай бұрын

This, but in Excel please!

@abelabdella2670 2 жыл бұрын

💋

@rocket-lf9rm Жыл бұрын

Hi madam I have id card data of students in ms word in Id card design format like student name Class Division Address Contact number This data i want in excel column wise is it possible madam