Missing cells when converting to spreadsheet

[johng80824719]

I searched this topic and cannot find any solved posts. 

I am converting a pdf to excel and am missing some cells upon the conversion.  I have narrowed it down to the first line on each page after page 1. I have tried exporting each page to a separate sheet and having them come over on one sheet.  In either case, the same lines are missing each time. Is there something I need to check, look for, etc?

[Dave__M]

The first places I would look/experiment would be in the PDF Maker's settings.  Assuming you are using the Acrobat ribbon in Excel, click on Preferences and check your settings that I have highlighted in this screenshot:

The other thing I would explore is whether you have an appropriate Print Area defined on each sheet.  I've had both of these settings mess me up in the past.

If this doesn't lead to a solution, can you provide more info?  What version(s), operating system, etc. 

My best,

Dave

[johng80824719]

I am very new to using any Adobe PDF product beyond Reader.  We just purchased Adobe Acrobat DC last week.  I tried looking at the Excel ribbon but I'm not sure how to "pull" data into Excel from an Adobe file.  I was using the Export PDF feature from Adobe.  I am on Windows 10.

[Dave__M]

One place you may want to look is at your Acrobat preferences.  In Acrobat, either CTRL-K or Edit>Preferences.  You'll find an entry for Convert From PDF.  You'll find the specifics for Excel Workbook.  There are some options in there that can be adjusted, most notably how it handles multi-sheet workbooks.

My best,

Dave

[Dave__M]

The same preferences can be uncovered in the export process by clicking on the gear highlighted below...

[johng80824719]

Yes, I tried all 3 of the "Excel Workbook Settings" but none of them fixed the issue.  I did not try the "Numeric Settings" or change the "Text Recognition Settings" as they did not appear to be applicable to this situation, though I could be wrong in assuming this.

[Dave__M]

Is there anything unique about the formatting of the vanishing rows in the PDF?  Is the typeface used different?  In the original PDF, is that row actual text (can you highlight it with the text select/edit tool?).  Sometimes what looks like text in a PDF can actually be an image of text.

Dave

[Tariq Ahmad Dar]

Hi Johng,

Sorry for the delay in response.

I see most the suggestions have been provided to you by Dave. I would like to ask was this PDF a scanned document?

Also, is it possible to share the files with us, if yes you may share the files using Adobe Send: How to share a file using Adobe Document Cloud if the file is sensitive in nature, you may share the link to download the file via a private message: How Do I Send Private Message

-Tariq Dar

[THSProduct]

Hi

I have this same problem. Was the issue resolved? If so how?

Thanks

Shawn

[THSProduct · Accepted solution]

All,

At least in my case it appears that that the Adobe Acrobat Export to Excel function assumes the first and last line of text on each page is the header or footer (which does not get exported). I was able to correct for this by adding a Header and Footer to the document, via editing the PDF, and then doing the Export to Excel.

This appears to have corrected my missing first and last row issue.

[stefano_3146]

This worked for me!

[S. S]

Hi @stefano_3146,

Hope you are doing well. 

Thanks for writing about what worked for you.

Marking it as a correct answer for future users to use as reference.

-Souvik

[Dave__M]

Sorry John... I misread your original thread - tried to delete my response, but the system did not allow.