Import Data from a pdf document
But sometimes systems only produce PDF reports. That’s a sticky problem and you can try to use OCR software or specialist conversion software that does some of the job but it’s hard work, usually not repeatable and can’t be automated.
But Matt Allington’s fairly recent post Import Tabular Data from PDF using Power Query is really a clever innovative approach to this common problem centered around saving the document to Word and then saving as a web page and importing it Power Query and then manipulating and cleaning the data from there with Power Query. A query within Power Query then allows download to your workbook in an Excel table of data. Really good article as Matt’s always are.
Matt is a passionate instructor in Power Pivot, Power Query and Power BI and I attended his Power Pivot course a few years back which I can highly recommend. He also kindly invited me to ‘test drive’ his really practical and reasonably priced book “Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI”. It get’s you up and running on Power Pivot and it’s DAX formulas in a very fast, hands on and practical way in a tutorial style format.