Microsoft Word Tip: Convert Word table into Excel

Convert MS Word table into Excel: Learn how to move complex tables from Microsoft Word into Excel without having merged cells in the final output. Visit www.advancedwordclass.com for more tips.

[@AlexIvanovdoors]

This is EXACTLY what I was looking for, having spent at least one hour going through other videos and was just about ready to give up. This is definitely a tremendous time saver and exactly what I needed. Thank you so much!

[@jules2679]

I was going crazy trying to figure out how to do this! You're a life saver, thanks so much !!!

[@Ma5haria]

You have no idea how much time this tip saved me. Cheers

[@stewdrumz]

Your video might be more than two years old, but it's just as relavent today as it was the day you made it. I spent about 2 hours last weekend converting maybe 8 tables from Word to Excel due to amount of time to reformat, unmerge and merge several cells. Using your method, I was able to do the same task in about 10% of the time as the manual method. Thank you for sharing this valuable tip. Is Ctrl + J a documented feature by Microsoft. This is one that I have never heard. Again, great job on the video and kudos for sharing such a simple but valuable tip.

[@mareemachin33]

That just saved me HOURS and HOURS of work! Thanks

[@blinkwithoutdelay]

It helped me a lot in my JOB , my senior told me to write all the table content in word to excel , it saved me . thanks a lot genius.

[@kickthestoat]

Thank you kindly, sir!! That's turned a tense 2 hours into a good end to the working day!!!

[@dfsgsdtedyrynreyn]

THANK YOU! You're the best, saved me few days of copying individual lines.

[@gijoe9634]

Thanks a lot. you have explained it so simply. Other You tubers were explaining the same functionality in a very complex way. In a two mts video you have just nailed it. Thanks Bro !

[@nareshkumarpenumetcha5953]

Thank You Very Much. It helps us save considerable time every month.

[@ericmok97781688]

Thank you very much for your teaching, this is really useful. I looked this solution for more than 3 years.

[@lenggroup73]

THANK YOU so much for this- it really saved us time!

[@KariRaquel14]

THANKS!! you saved me so many hours of clean up!

[@juliehumphrey747]

So helpful. Worked like a charm. Your video saved me so much time. Thanks.

[@lucbrodeur2034]

You saved me hours of work. thank you!

[@DianaMiranda-Murillo]

Thank you!! 2:17 it's exactly what I was looking for!!

[@bahri1989]

Thanks mate! Truly helped us out!

[@MSCViolin]

Perfect solution, thank you.

[@t23515]

Thank you. Thank you. Exactly what I needed

[@jimmy6423]

great tip, thank you very much for sharing sir!

[@rabihelias1324]

I really wish that I can put 100 likes on the same video, you saved my life man. Thank you so much

[@SteveSwanson999]

SO MUCH BETTER THAN WOW!! I tried to give it multiple likes but KZbin won't let me. Expletive amazing THANK YOU THANK YOU THANK YOU

[@gsmohanty4458]

Thank you. You solved my problem. Really informative.

[@oupamorudu8536]

Thank you very much. Thats what I was trying to figure out

[@jdyke1234]

You are a hero!!! My goodness I was manually doing it and got so frustrated!!!

[@michaelchen8393]

Thanks very much for sharing. It works

[@mattm7115]

Perfect! Thank you!

[@TeslaInch]

Great work man. Bless up.❤

[@samuelsivakumar9023]

God Bless your heart man. Life Saver

[@Flatsausage]

That was extremely helpful! Thank you very mych for sharing it!

[@earljohngatacilo4536]

Very helpful! Thanks man!

[@lololop58]

Hero of the day. TYSM!!! ❤️🥹

[@nickiduncan8151]

Legend, thanks Brian!

[@ayesukyi8239]

Thanks a lot, it saved my day!

[@MulindeDavid]

Thank you so much. This is so helpful.

[@anandams33]

Thanks man great help

[@MarkJones-hi8db]

Brilliant! Genius. Thank you.

[@paigeward7671]

Hi Brian, Thank you for your video. I have a word document that is set up in this format: Name Address City, State Zip Phone Etc. There is not a table but just running list like that of many addresses. Do you have a way to move that information over into an excel document that would be formatted with the headings: Name, Address, City, Etc... in the columns and then the following information in rows below it. Thank you so much for all of your help in advance.

[@moseskairu2952]

Man, Thank you so much!

[@wipredatoriw6555]

what the heck is this explanation, you are so good man. amazing thank u so much keep up the good work

[@iandavidson6530]

Absolutely awesome!!!!!!!!

[@TWL012]

exactly what I looking for

[@auhrvjzihvezjxhhvvsnjxhxhv]

Very useful video. Thanks a lot.

[@grantshishido3517]

Bless you sir!!

[@sean770710]

Thank u so much for the tip

[@michaeladdisu8043]

thank you broo , this save my time

[@piaellegaard4714]

Thanks. However it does not work with numbered lists in a word table. - Can you recommend the right "Special" for the numbered tables?

[@user-ds3yy6wb6s]

Ho Ho Ho! That was amazing! You're a genius!) Cheers!

[@unknownmen3159]

Thanks so much!

[@bekulugbek]

Thank you!

[@pepomow]

GOD bless you Prien thanks a lot which you happy successful life

[@angelicachristopher7046]

Bless you sir!

[@ketakikhavanekar969]

Awesomeeeee....saves lot of time

[@AjaySingh-ec3nf]

Thank you so much

[@10bremerelanesidlesham78]

many thanks

[@priyadharshinimylwaganam8346]

Thank u so much 👍

[@xMissBlueStarx]

I can't do ctrl J with my macbook in excel, what is the mac equivalent?

[@aandejani5289]

Amazing yiu really saved my life 👍

[@philoutonami]

YOU ARE GREAT

[@umeshsaroha6957]

Awesome work sir.....

[@susan5203]

Thank you

[@jegak5428]

good and fast way , tq

[@aravindss-ll7yb]

Thank u so much

[@brendaburden1930]

This maybe be an old video, but it is still good as of present year

[@Asim-Mias]

Thanks man

[@TommyLent]

Thanks for the help. Putting Word docs into Excel is a pain sometimes.

[@ppergutz9095]

Very useful bro billion thanks to you,like u so much😍😍😍

[@YeshicaYanes]

THANK YOUUUUUU!!!

[@profmalik]

Love u man...

[@nakonekub]

fantastic

[@DanPavelDoghi]

thanks a lot; perhaps the best way of doing it, after seeing dozen of approaches, most giving less quality outcome

[@sukhabehkato9873]

Thanks sir

[@tutsecret499]

What he means by control eyay? The little flashing dot? Where I can get this flashing dot to replace the bar(pipe caracter)?

[@sucramsucram3558]

Legend!

[@RogerDD100]

Worked for me - one glitch was that I noticed that a lot of my text (which was calibri) turned to symbols, but was able to change the text back by reapplying the (calibri) text to the whole excel document

[@biplobsaha7665]

thanks my dear

[@susan5203]

Awesome

[@rocket-lf9rm]

I have data in ms word in id card format I want to convert or export that data in excel in row wise is that possible sir

[@kokalikreations2917]

But how were you able to retain the firmtted text into Excel mine changes inti nirmal text when u cooy paste in Excel Can you share that tip

[@dangerous000]

THANK YOU !!! you saved me tons of work (life saver)

[@marf982b]

Thx

[@aktarulalam2358]

Where is the down line character on the keyboard? I can't find it. Please let me know...

[@Azam_Pakistan]

I need to paste multiple tables in the same columns and the tables have different column widths. Is there a magical solution?

[@muthuveeran4865]

thala sooper thala ne!!!!

[@andydiep4162]

your goated

[@lilaklopfel12]

I am getting an error message saying the 'function is not valid'. Please help!

[@subramanyamguptanalam8029]

Here there is a small problem.. It removed all the formatting which was present before. Can you please suggest how to replace without losing the formatting.

[@tutsecret499]

Disregard the comment below. I find out. He meant to say Control+J. This key is wonderful

[@iiiarmchair]

^j - many thanks for that one!

[@bhupendas8803]

Please teach me Ubuntu 2003 Ms word text direction .

[@khaleddak]

When I try to open your site it"This page isn't working(HTTP Error 500)

[@ssomtom]

in the last step you lost the format of the word text....

[@kaushal09able]

Hats off to you Sir. Share your email id for contact

[@nguyenhoangminhtri8136]

Thank you so much

[@tommyreinaldokurniawan788]

Thank you