Convert PDF to XLSX Excel

[YOK33]

Trying to convert a .PDF to an Excel file and when completed, only thing that shows in the resulting Excel worksheet are the lines of the table I am exporting.  It was working perfectly up until about 4-6 weeks ago.

Please help.  Desperate!

[stephanief91464426]

I tried converting and got a load of illegible symbols. Dont know why !

[try67 · Accepted solution]

Most likely because of an issue with the font used in the PDF. What happens

if you copy the text in the PDF, copy it and paste it into something like

Notepad?

On 8 January 2018 at 17:59, stephanief91464426 <forums_noreply@adobe.com>

[stephanief91464426]

I'll try that , thanks

[stephanief91464426]

No, it wont have any of it. Will print out pdf's and type into excel by hand. An afternoon's work and 1000 entries pffft.

[stephanief91464426]

ÇÅÖÆÆÙÅè@ÄÖæÕÅâ

Áƒƒ–¤•£@Õ¤”‚…™z@ôôðð@ööõ÷@øóøò@ôø÷ñ Ä…ƒ…”‚…™@ñò@`@с•¤™¨@ññk@òðñ÷@

Áƒƒ–¤•£@É•†–™”£‰–•z

ׁ¨”…•£ É•†–™”£‰–•

 

Áƒƒ–¤•£ ⤔”™¨

 

  ¦¦¦K‚•’–†”…™‰ƒKƒ–”

ԁ‰“@‚‰““‰•‡@‰•˜¤‰™‰…¢@£–z •’@–†@Á”…™‰ƒ

×KÖK@–§@ùøòòóõ Å“@ׁ¢–@ãç@@÷ùùùø`òòóõ

ԁ‰“@—¨”…•£¢@£–z •’@–†@Á”…™‰ƒ

×KÖK@–§@ñõðñù 打”‰•‡£–•@ÄÅ@ñùøøö`õðñù

䢣–”…™@â…™¥‰ƒ…z ñKøððKôòñKòññð

MñKøððKóôöKóñ÷ø@ããè]

    㙁•¢ƒ£‰–•¢                                                                                                                                                                                

㙁•¢ƒ£‰–•            ×–¢£‰•‡                                                                                                                                                                                  Ù…†…™…•ƒ…             Áƒƒ–¤•£

ā£…                        ā£…                      Ä…¢ƒ™‰—£‰–•                                                                                                                                              Õ¤”‚…™                Õ¤”‚…™                                                      Á”–¤•£                                ã–£“

ׁ¨”…•£¢@•„@Ö£ˆ…™@Ù…„‰£¢

ðñaðõ           ðñaðõ          Ö•“‰•…@—¨”…•£@†™–”@ÃÈÒ@÷                                                                   öôõó            ôø÷ñ                                 6ù÷óKöõ

[try67]

Then the font(s) used in these files are badly encoded.
Before you do that, there is another option: Re-creating the PDF files using Acrobat.

To do that you would need to first export all the pages as images (using a lossless format, like PNG), via File - Save As Other - Image, and then create a new PDF from those images and run Text Recognition on it. See if that helps...

[stephanief91464426]

Really think I'll be quicker extracting the lines I need. Thanks anyhow.

[try67]

You just wrote you have a 1000 entries to extract... But whatever. Good luck!

[stephanief91464426]

Exactly...that's why I tried to export it all. Emphasis being on tried. The font is crap so I can understand that not everything will work. i'll have it done by tomorrow lunchtime and a tree worth of paper to shred. I hate it when bank statements get downloaded as pdf not csv. There's another 10 different accounts to do after that, so I shall try your approach with them. Many thanks i know a bit more now

[Karl Heinz Kremer]

Whenever Acrobat cannot extract information from a file (or correctly convert to to a different document format), one way to get a potentially better result is to throw away all the font information that is stored in the PDF file, and the best way to do that is to export your document as a series of high quality TIFF images, and then re-import these images into Acrobat to create a new PDF file. You can then run OCR to convert to text that can be extracted again (this last step can also be done as part of the export function if you have a newer version of Acrobat).

[stephanief91464426]

Many thanks Karl, I will try that

[personal data removed by  forum moderator]