One simple way to capture values in Word Table via Excel

There is one daily task from my colleague that she has to input a lot of values from Word files. The content of Word files is in simple form (table-like) format. However, the providers refused to provide in Excel files, which have further using possibility. So she would print out Word files in hard copy and input values into a fixed formatted Excel file.

The difficulty of applying automation or easier methods is in the following items:

1. we are not able to “ask” the Word format to be fixed. There might be some extra lines in rows of the table in Word.

2. The wording or expression is not unified due to people understanding “V” as well as “■”, and redundant spaces meaning nothing.

Therefore, I have come up with a simple and also stupid method to covert Word table into Excel.

I will share the procedure later.