Guides: getting reports out of PDFs and into Excel
Practical, step-by-step help for the reports your business software prints, whether or not you use Wheelbarrow.
- How to convert a PDF report to Excel without retyping it
Five ways to get a PDF report into Excel: copy and paste, Word, Excel's Get Data from PDF, Adobe Acrobat, and a tool built for the report. What each is good for, and which to use when the report comes back every week.
- Power Query PDF import: fixing repeated headers, page totals and wrapped rows
Excel's Get Data from PDF pulls in the junk too: headers repeated on every page, page totals in the middle of the data, and notes that wrap onto a second row. Here's how to fix each one in Power Query.