Extract tables from word document

[Anonymous]

Hi there

Does anyone manage to scrape data from word documents via PowerBI / Power Query?

Is this doable?

Thank you so much

[v-caliao-msft]

Hi @Anonymous,

Yes, we can achieve this requirement. You need to leverage the fact that Microsoft Word .docx files are actually ZIP files containing a group of XML files.  We will decompress the ZIP file and parse the XML to pull information into Power Query.

Reference
http://www.excelandpowerbi.com/?p=201
http://www.excelandpowerbi.com/?p=146

Regards,

Charlie Liao

[Anonymous · Accepted solution]

@MattAllington has a pattern to extract tables into Power BI from Word saved as HTML - see http://exceleratorbi.com.au/import-tabular-data-pdf-using-power-query/