PDF to Excel - Second page as an Image Boc

[philip_5863]

When converting a PDF to Excel the second page/every other page is as an "image" in the image box in Excel. 

How can I fix this, is this a page break issue from the program that is making the PDF? 

I need to get the information from the PDF to Excel to use my formulas to get the data out and I cant do this with an image. 

[Amal. · Accepted solution]

Hi there

Hope you are doing well and thanks for reaching out.

Is this an issue with a particular PDF file or with all the PDFs that you try to export to Excel? Please try with a different PDF file and check.

What workflow/steps are you following to export the PDF to Excel? A small video recording of the steps you are taking and the issue as it occurs would be very helpful for more clarity.

It sounds like the PDF you're converting has certain pages that contain scanned images instead of selectable text. This usually happens if the original document was scanned or if the text was flattened into an image before being saved as a PDF. That’s why, when converting to Excel, those pages appear as images rather than editable text.

If you have Adobe Acrobat Pro, you can enable OCR to recognize text within images before converting to Excel:

• Open the PDF in Adobe Acrobat Pro
• Go to "Scan & OCR" (Under Tools)
• Click "Recognize Text" > "In This File" and select the correct language
• Save the file, then try converting it again and see if that works.

Let us know how it goes.