Skip to main content
P
philip_5863
Participant
February 19, 2025
Answered

PDF to Excel - Second page as an Image Boc

  • February 19, 2025
  • 2 replies
  • 446 views

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. 

Correct answer Amal.

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.

2 replies

jmikeragusa
jmikeragusa
Participant
April 7, 2026

Try converting a PDF bank statements to Excel!  Cluster fu@k! ITs easer copying, pasting and typing the vendor name, because Adobe reads and puts all the vendor information in one text block instead of appearing in rows like the date and charge amount .  If there's a way to separate text, in one big text block, to show in rows, like the date, and amount.  I cant find it. 

Amal.
Amal.Correct answer
Legend
February 19, 2025

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.

jmikeragusa
jmikeragusa
Participant
April 7, 2026

Tried Recognize text, before and after deleting unnecessary block text, and logos, not pertaining to date, amount, and vendor info.  It is the design of bank statement that makes it difficult.  

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices