Document: Border fence contributors

Convert PDF with embedded font to spreadsheet

Difficulty:

Many PDF tools won't handle embedded font

Convert this PDF of contributors to Arizona Gov. Jan Brewer's border fence -- complete with dates, names, locations and dollar amounts -- into a sortable spreadsheet.

This won't be easy. The document has stumped every PDF conversion system because of what appears to be an embedded font.

DESIRED OUTCOME: Calculate the total donations as $3,796,729.99, the total amount donated from Wyoming as $1,553,730.02 and correctly show the Mellon family from Wyoming as the largest contributor.

 

Test Results

Verdict:

Translates garbled text, converts PDF into near-flawless spreadsheet with minimal cleanup

OmniPage accurately converts massive, garbled PDF

It took an hour or so, but OmniPage is the only software we've tested to date that converted this 1,000-page PDF of border fence contributors into a spreadsheet -- reproducing the original almost perfectly. Its OCR feature was even able to handle the weird font that's consistently foiled other programs.

READ OUR FULL TEST RESULT »

Verdict:

OCR solves font problem, but large file proved too much

PDF2XL tackles embedded font, still fails

Although PDF2XL's OCR feature appears to cleanly translate the tricky font in this list of contributors to Gov. Jan Brewer's border fence project, the document's size stops the conversion in its tracks.

READ OUR FULL TEST RESULT »

Verdict:

Garbled text, formatting the only result of this conversion

Weird font throws off Acrobat spreadsheet

Acrobat's not the program you want to handle a tricky PDF with an embedded font, like this list of contributors to Gov. Jan Brewer's border fence project. It failed two different ways using two different methods.

READ OUR FULL TEST RESULT »

Verdict:

Produces spreadsheet, but text is useless

DeskUNPDF can't handle embedded font

Converting a PDF filled with unusual fonts tripped up the deskUNPDF program. Instead of a sortable, organized spreadsheet, the system produced a 1,052-page document packed with garbled text.

READ OUR FULL TEST RESULT »

Verdict:

Text garbled; data split into multiple pages

Zamzar converts spreadsheet to nonsense

Zamzar was unable to recognize the text in this listing of Arizona border fence contributors, producing a spreadsheet filled completely with useless nonsense.

READ OUR FULL TEST RESULT »

Verdict:

Can't handle embedded font; output just garbled text

Monarch can't translate garbled font

Monarch isn't equipped to handle damaged, corrupted or unrecognized fonts, so any conversion of this table of contributors to Arizona Gov. Jan Brewer's border fence project results in a well-organized but unreadable jumble of meaningless characters.

READ OUR FULL TEST RESULT »

Verdict:

Data entries garbled beyond recognition; maintained document format

Pdftotext returns garbled characters due to embedded font

Because Pdftotext fails to preserve any data, it would be impossible to get any relevant information from this list of contributors for Arizona Gov. Jan Brewer's proposed border fence initiative using the program.

READ OUR FULL TEST RESULT »

Verdict:

Converts unrecognized font to mishmash of unusable symbols

Able2Extract fails with embedded fonts

While the formatting of this table of Gov. Jan Brewer's border fence contributors is perfect after running it through Able2Extract, the information contained within is not. The words are replaced with random characters for the whole spreadsheet.

READ OUR FULL TEST RESULT »

Verdict:

Output in table format, but unusable

Cometdocs turns embedded font into garbled text

Although Cometdocs manages to complete the conversion, the output is nothing but a seemingly random assortment of characters. Nothing useful, sortable or readable here.

READ OUR FULL TEST RESULT »

Verdict:

Embedded font stumps software

Nitro Pro can't handle tricky embedded font

The font in this list of contributors to Arizona Gov. Jan Brewer's border fence project is too hard for Nitro Pro to handle, and it fails completely.

READ OUR FULL TEST RESULT »

Testing

Testing