How to Import or Convert Data from Word Document into Excel worksheet

Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: bit.ly/3w8yclD
In this video tutorial I’ll show you how to convert a word document with data into an excel worksheet (how to convert Word to Excel or Word to Excel Conversion). Our goal is to take a document with text laid out in paragraphs and turning it into a field of cells.
⌚ Timestamps
00:00 Introduction
00:26 Prepare your Data
01:10 Insert the Data into Excel
01:35 Text Import Wizard Settings
🔥 Subscribe to my Channel ► bit.ly/1KWfq14
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
💎Check Out My Udemy Online Courses ►►►►►►►►►►
📌Excel Dashboards and Data Analysis Masterclass ► bit.ly/35lO8OK
📌Excel Macros & Excel VBA Programming for Beginners ► bit.ly/2D3Ipkw
📌Excel Power Query, Power Pivot, Power Map & DAX Masterclass ► bit.ly/2qwa2jB
📌Excel Shortcuts, Hacks & Tricks: 100+ Tips for Excel 2016 ► bit.ly/2pEMlW8
📌Microsoft Excel Charts, Graphs and Data Visualization ► bit.ly/2qyosQr
📌Python for Beginners: Learn Python in One Day ► bit.ly/2s1nUTy
📌Complete Gmail Course ► bit.ly/2QCaUxQ
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
🚩 Connect with me on social:
Facebook ► / mellontraining
My Blog ► www.mellontraining.com
My Online Excel Courses ► www.udemy.com/u/andrewex
Twitter ► / mellontraining
Linkedin ► gr.linkedin.com/in/andreasexadaktylos
KZbin channel ► / mellontraining
#excel #exceltutorial #wordtoexcel

[@mellontrainingtutorials]

Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: bit.ly/3w8yclD

[@tiffanystoebe4243]

You saved me hours with your explanation! Thank you so much!!!

[@mellontrainingtutorials]

Thanks Tiffany Stoebe I appreciate it!

[@rochellejanewski9587]

Thank you for posting this video tutorial. It was just what I needed to complete an assigned task. Very useful and easy to follow!

[@mellontrainingtutorials]

Thanks Rochelle Janewski I appreciate it!

[@le3659]

Straight to to the point and very helpful. Thank you.

[@mellontrainingtutorials]

Thank you Lilian Egba for your kind words!

[@mostwatchedvideos5958]

Thank you so much this is a life saving video for me.

[@mellontrainingtutorials]

Thanks for watching anne matinde!

[@dimplejanni9119]

Thank you so much. It's better and good for us.

[@mellontrainingtutorials]

Thank you Dimple Janni for your kind words!

[@JJ-no1qc]

thanks a lot. it's very helpful!

[@mellontrainingtutorials]

Thanks for watching JJ!

[@dataplugke9963]

Perfect !!! thank you

[@mellontrainingtutorials]

Thank you Muraya Karanja for your kind words!

[@kristilynramos196]

Thank you thank you!!!! Huge help

[@mellontrainingtutorials]

Thanks for watching Kristilyn Ramos!

[@bilmshimekryptik3612]

you da man

[@jaxonlanghorne9263]

Thx for your help!

[@mellontrainingtutorials]

Thanks Jaxon Langhorne I appreciate it!

[@ramkinkars]

Thanks for the wonderful help !

[@mellontrainingtutorials]

Thank you Ramkinkar Shastri for your kind words!

[@luciabrenes2102]

Super helpful it worked great on my Mac, thank you!

[@mellontrainingtutorials]

Glad it helped!

[@jhstieglitz]

excellent tutorial Thank you

[@mellontrainingtutorials]

Thank you Jon Stieglitz for your kind words!

[@sonmani1994]

Thnkyou so muchhhhhh

[@mellontrainingtutorials]

You are very welcome!

[@shravanparam7474]

Thank you so much sir

[@mellontrainingtutorials]

You are very welcome Shravan Parmar!

[@towimacchannel6208]

Thank you. I just did that and it worked.

[@mellontrainingtutorials]

Excellent!

[@asankatennekoon7518]

Thanks lot

[@mellontrainingtutorials]

Thanks Asanka Tennekoon I appreciate it!

[@sali1755]

Excellent.

[@mellontrainingtutorials]

Thanks Md. Shahjahan Ali I appreciate it!

[@msvivi215]

such a great help! thank you :)

[@mellontrainingtutorials]

Thanks MissV I appreciate it!

[@Effa-kyei]

Thanks a million

[@mellontrainingtutorials]

You are very welcome Moski Ent!

[@GhabTech]

Thank you sir..... It's worked

[@mellontrainingtutorials]

You are very welcome Ghab Tech!

[@michaelolson9881]

I will give this a try. I am unfamiliar with the term "delimiter". I will assume it marks the end/beginning of a new data field

[@ajwatypingphotocopying8971]

great dude

[@mellontrainingtutorials]

Thanks AJWA TYPING & PHOTOCOPYING I appreciate it!

[@bananaproduction7232]

Thank you!!!!!

[@mellontrainingtutorials]

You are very welcome Banana production!

[@agonz1438]

Thank you so much!!!

[@mellontrainingtutorials]

You're welcome!

[@janedarc1471]

Do you proceed the same way for sum files?

[@XZYZ0R]

/it only converts 1 column of my table instead of 6

[@krishnavamsiganjimala5385]

Thank you sir

[@mellontrainingtutorials]

Thanks krishnavamsi Ganjimala I appreciate it!

[@juliemagallanes811]

Need help ASAP! How would i convert only parts of a Word doc(not the entire document) into an existing excel spreadsheet?

[@mellontrainingtutorials]

In this video tutorial I’ll show you how to convert a word document with data into an excel worksheet. Our goal is to take a document with text laid out in paragraphs and turning it into a field of cells. Subscribe to my Channel ► bit.ly/1KWfq14

[@nitiningawale6075]

thnks...

[@mellontrainingtutorials]

Thanks for watching Nitin Ingawale!

[@mariaa9056]

THANK YOU

[@mellontrainingtutorials]

Thanks for watching María A!

[@ochukoesidje4663]

Thank you, however I want to extract some contents of a CV to excel automatically without manual typing.

[@mellontrainingtutorials]

Thank you Ochuko Esidje for your recommendations. I'll do my best to improve it!

[@franciscoenriquecamachomez4757]

Dear Mellon and friends: I haven't been able to transfer data from Word Form to an Excel, because when trying to save as plain text, the "Preview of the file" shows empty blank space instead of the data. The saved document seems to have no data and a size of 1KB. Do you know what may I be doing wrong?

[@jasonthompson7120]

I'm the same I only get 1 column , and its not text wizard ?

[@fouzia8844]

I tried but not working out. My data is in tabular form with header and folder.. Kindly help me out. It's take date in horizontal form.. Where I want it in vertical with column name and header and footer as it saved in plain text and word format

[@mohammadharun-orrashid7929]

My one row is converting several rows in excel

[@hyekyotse]

I cannot because my excel is different than yours. Helppp

[@oluwatobijames1919]

but please how can i import word document wit table into excel

[@mellontrainingtutorials]

Hi there! You can use Copy and Paste Special feature of Excel

[@gummysmileminyoongles9366]

I tried importing my document but it didn't come in table form but just in portrait

[@Berghiker]

So did you do a video on waterfall charts that will work if it goes below zero yet? Did you see my video?

[@mellontrainingtutorials]

Hi Alvin. Can you please give me the link of your video?

[@raams2633]

I want change ms office word text into ms Excel sheet for printing.how to do it. Please explain

[@mellontrainingtutorials]

Hi Raan! Can you explain more?

[@MassiveSwordAndCards]

So much of the video is blurred out it's impossible to fully follow the instructions...

[@Lobotommy110]

Dude sounds like a Columbian Cartel boss

[@workfromhome4793]

I wanted it on one sheet nd it made 52 sheets...WHat a shit..

[@mellontrainingtutorials]

Hi there! Please check the video again, it should do to one sheet only.

[@shadowowplayz1402]

didn't work

[@mellontrainingtutorials]

Hi Shadowow ! Please watch the video again. It is checked that works