Forum Discussion
PDF to Excel
- Jul 20, 2023
Afraid that's nothing to do with the file created such way.
I can understand the frustration, especially with 883 PDFs. At that point, even a small extraction problem becomes a huge amount of manual work.
You might want to try CropSheet as an alternative approach.
Instead of relying on Excel to understand the PDF's underlying structure, you select the table as it actually appears on screen and CropSheet reconstructs it in Excel.
That can be useful when the PDF has awkward layouts, merged cells, irregular columns or a structure that Power Query doesn't interpret correctly.
One other thing I find useful is that doubtful cells are flagged, so you can review the questionable values rather than manually checking the entire result.
For a batch of 883 files, I'd test it on a few representative PDFs first.