Macro to extract data from Word table to Excel | Excel VBA

Learn how to extract data from tables in a word document to Excel using a macro (VBA). You can use this approach to automatically extract useful data from word documents that follow as same template.

Subscribe and Like to keep me motivated and see more such videos.

You can ask questions in comments section.

[sford]

Really useful in helping me automate some table extraction..thanks for sharing/posting.

[JoshuaWayt]

So much value in this video! Thank you so much!

[ragulkrishnamoorthy]

Helped me with a small project, thanks for the video

[henriqueto]

Excellent video. I will sub to this channel. Best regards from Brazil

[deepakkakara]

Thank you so much, a very much useful video

[dondiroberts]

Excellent video and instruction. I would like to combine this lesson with the lesson you indicated about extracting from multiple Word documents, which you stated was already on your channel. I just can't find it. Thank you again so much for the clear and concise instruction.

[syms]

Thank you sir, this video is great. I will be looking at the rest of your channel to learn more about using VBA in the future. You mentioned at end of video about extracting from multiple word documents, could you please link that video so others and I can find it easier? This video, plus that video will cover 90% of my needs!

FOR INFO IF CURIOUS: For my current task, I have multiple word files that have the same templates, same tables, etc. The files all have different names, so I want to be able to put them all in a single folder and extract the file name into A3 then data from that files 3rd table into B3-H3 then move onto next word document and extract name and data into next row, until all word files have been processed. Then maybe a splash screen to say how many word files had been processed would be a nice end to it, but that would be optional :-)

[techtbe]

Great video Bro, It helped me lot. thanks

[usmansardarmuhammad]

Hey Thank you, I helped me a lot. Stay Blessed.

[sanjayklal]

Thanks so much. Exactly what I was looking for. What if the word document has multiple pages but values from all the pages have to go to one sheet of excel? How to look for a page break and repeat the code for the page?

[rkhyami]

Thank you for the amazing video and code. I am not a programmer and trying to collect the first table info from multiple docs in a folder into an Excel sheet. Would you be kind to share the update to the code to collect from multiple word documents please?

[sharmilachaudhari]

I have a 100+ tables in word file with 2 columns where 1st columns rows are same for all tables and 2nd columns has values for each row of 1st column. How to get it in excel?

[p.r.chandru]

hi, i have 100 page word document and its contains text and also 100 tables with text, how do i copy only text from the 100 tables into excel, help me

[kensonnicholas]

How do I extract multiple files with the same format and place them into the same excel file, you made a reference to this scenario at the end of the video.Is there a video or specific line of code which can help me with my question

[anitalalwani]

Hi, I do have plain text format with the data which I wish to extract in excel automatically,
O am not a programmer so can you help me out for the same.

[abubakar]

Thanks for the video. How can I prompt the user to select the word file and also how can we do it for mulitple documents.

[viswanathan]

How to change the properties of multiple word/excel/ppt files on a click using VBA by extraction of properties in an excel and hen changing it as desired

[limitone]

yes, I have a question... what if I want to extract a calendar.doc or calendar.docx from WORD (meaning I created a calendar of the month and on each day/particular square of the calendar is a date and on that date there are specific word such as "transplant". Now I need excel to capture that word "transplant" and the Date square (Dec 3, 2022) it was entered on to Excel sheet1 with names and ID number of that particular Word document. Each calendar Word doc is associated with an employee name and ID. hope I explained it well... thank you!

[elizabethhusain]

Great video . Nice job with that . Do you know if I can use macro to extract the list values from the drop-down list of some templates and put the list of options under the header for each column . There is not reference cells or table just the list values .

[kellykay]

Excellent video! How can I determine if the color of a row in a Word table is red or not? I want to return the value 1 if RED.