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
RUclips channel ► / mellontraining
#excel #exceltutorial #wordtoexcel

[@mellontrainingtutorials]

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

[@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!

[@tiffanystoebe4243]

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

[@mellontrainingtutorials]

Thanks Tiffany Stoebe I appreciate it!

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

[@mostwatchedvideos5958]

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

[@mellontrainingtutorials]

Thanks for watching anne matinde!

[@le3659]

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

[@mellontrainingtutorials]

Thank you Lilian Egba for your kind words!

[@dimplejanni9119]

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

[@mellontrainingtutorials]

Thank you Dimple Janni for your kind words!

[@kristilynramos196]

Thank you thank you!!!! Huge help

[@mellontrainingtutorials]

Thanks for watching Kristilyn Ramos!

[@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!

[@jaxonlanghorne9263]

Thx for your help!

[@mellontrainingtutorials]

Thanks Jaxon Langhorne I appreciate it!

[@bilmshimekryptik3612]

you da man

[@ramkinkars]

Thanks for the wonderful help !

[@mellontrainingtutorials]

Thank you Ramkinkar Shastri for your kind words!

[@jhstieglitz]

excellent tutorial Thank you

[@mellontrainingtutorials]

Thank you Jon Stieglitz for your kind words!

[@luciabrenes2102]

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

[@mellontrainingtutorials]

Glad it helped!

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

[@sonmani1994]

Thnkyou so muchhhhhh

[@mellontrainingtutorials]

You are very welcome!

[@msvivi215]

such a great help! thank you :)

[@mellontrainingtutorials]

Thanks MissV I appreciate it!

[@sali1755]

Excellent.

[@mellontrainingtutorials]

Thanks Md. Shahjahan Ali I appreciate it!

[@shravanparam7474]

Thank you so much sir

[@mellontrainingtutorials]

You are very welcome Shravan Parmar!

[@Effa-kyei]

Thanks a million

[@mellontrainingtutorials]

You are very welcome Moski Ent!

[@asankatennekoon7518]

Thanks lot

[@mellontrainingtutorials]

Thanks Asanka Tennekoon I appreciate it!

[@janedarc1471]

Do you proceed the same way for sum files?

[@juliemagallanes811]

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

[@towimacchannel6208]

Thank you. I just did that and it worked.

[@mellontrainingtutorials]

Excellent!

[@XZYZ0R]

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

[@agonz1438]

Thank you so much!!!

[@mellontrainingtutorials]

You're welcome!

[@bananaproduction7232]

Thank you!!!!!

[@mellontrainingtutorials]

You are very welcome Banana production!

[@ajwatypingphotocopying8971]

great dude

[@mellontrainingtutorials]

Thanks AJWA TYPING & PHOTOCOPYING I appreciate it!

[@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!

[@GhabTech]

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

[@mellontrainingtutorials]

You are very welcome Ghab Tech!

[@nitiningawale6075]

thnks...

[@mellontrainingtutorials]

Thanks for watching Nitin Ingawale!

[@mariaa9056]

THANK YOU

[@mellontrainingtutorials]

Thanks for watching María A!

[@krishnavamsiganjimala5385]

Thank you sir

[@mellontrainingtutorials]

Thanks krishnavamsi Ganjimala I appreciate it!

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

[@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 ?

[@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?

[@gummysmileminyoongles9366]

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

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

[@mohammadharun-orrashid7929]

My one row is converting several rows in excel

[@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?

[@hyekyotse]

I cannot because my excel is different than yours. Helppp

[@Lobotommy110]

Dude sounds like a Columbian Cartel boss

[@MassiveSwordAndCards]

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

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