PDF to Excel conversion: Your final information to one of the best instruments
In a perfect world, the information we have to analyze could be out there in ready-to-use format. On the earth we reside in, although, a whole lot of helpful knowledge is locked inside Moveable Doc Format (PDF) paperwork. The right way to extract that knowledge from PDFs into an Excel spreadsheet? You have got numerous PDF to Excel converters to select from.
There’s software program from main distributors like Microsoft and Adobe, task-specific cloud providers together with PDFTables and Cometdocs, providers from general-purpose cloud suppliers reminiscent of Amazon, and even free open-source choices.
Which is the “greatest” PDF to Excel converter? As with the “greatest pc,” the reply will depend on your particular circumstances.
3 inquiries to ask when selecting a PDF to Excel converter
There are a number of essential issues when deciding on a PDF converter.
1. Was my PDF generated by an utility or is it a scanned picture? There are two forms of PDF information. One is generated by an utility like Microsoft Phrase; the opposite comes from a scanned or different picture file. You’ll be able to inform which one you’ve gotten by making an attempt to focus on some textual content within the doc. If a click on and drag works to focus on textual content, your PDF is app-generated. If it doesn’t, you’ve bought a scan. Not all PDF conversion instruments work on scanned PDFs.
2. How complicated is the information construction? Virtually each software will work effectively on a easy one-page desk. Issues get extra sophisticated if tables are unfold over a number of pages, desk cells are merged, or some knowledge inside a desk cell wraps over a number of strains.
3. Do I’ve a big quantity of information that want batch file conversions or automation? Our greatest-performing software on app-generated PDFs will not be the only option for you if you wish to automate frequent batch conversions.
As well as, as with all software program selection, it’s worthwhile to resolve how a lot you worth efficiency versus value and ease of use.
How we examined the converter instruments
That will help you discover what’s greatest for your duties, we examined seven PDF to Excel conversion instruments utilizing 4 completely different PDF information starting from easy to nightmare. You’ll see how all of the instruments carry out in every state of affairs — and discover out the strengths and weaknesses of every one.
PDF to Excel converters we examined
Listed below are the instruments we examined, beginning with our total greatest performers (however keep in mind that “greatest” relies upon partly on the particular supply doc). All these instruments did fairly effectively on at the least a few of our duties, so rankings vary from “Wonderful” to “Good.”
Adobe Acrobat Export PDF subscription
Because the creator of the Moveable Doc Format normal, you’d anticipate Adobe to do effectively in parsing PDFs — and it does. A full-featured conversion subscription is considerably dear, however there’s additionally a cheap $2/month plan (annual subscription required) that features a limiteless variety of PDF to Excel conversions. (You’ll be able to output Microsoft Phrase information with this software as effectively).
The Excel conversions embody any textual content on pages which have each textual content and tables. This generally is a profit for those who’d wish to preserve that context or a disadvantage for those who simply need knowledge for extra evaluation.
Ranking: Wonderful — our hands-down winner for non-scanned PDFs.
Value: $24/yr
Execs: Excellent outcomes; preserves a lot of the unique formatting; offers effectively with tables spanning a number of pages; limitless conversions of information as much as 100MB; inexpensive for frequent customers.
Cons: No built-in scripting/automation workflow; costly for those who solely convert a number of paperwork a yr.
Backside line: If you happen to don’t have to script or automate a whole lot of conversions and don’t thoughts paying $24 per yr, it is a nice selection.
Amazon AWS Textract
For an AWS cloud service, Textract is surprisingly simple to make use of. Whilst you actually can undergo the standard multi-step AWS setup and coding course of for Textract, Amazon additionally affords a drag-and-drop net demo that allows you to obtain outcomes as zipped CSVs. You simply want to enroll in a (free) Amazon AWS account.
Ranking: Wonderful — this was our greatest possibility for a sophisticated scanned PDF.
Value: 1.5 cents per web page (100 pages per 30 days free to your first three months at AWS)
Execs: Best choice examined for a sophisticated scanned PDF; carried out extraordinarily effectively on all of the app-generated PDFs; affords a selection of viewing outcomes with merged or unmerged cell structure; simple to make use of; inexpensive.
Cons: Uploaded information are restricted to 10 pages at a time. For many who wish to automate, utilizing this API is extra sophisticated than another choices.
Backside line: A superb selection for those who don’t thoughts the AWS setup and both handbook add or coding with a fancy API.
Tabula
If you happen to’re on the lookout for free and open supply, give Tabula a attempt. Not like some free choices from the Python world, Tabula is simple each to put in and to make use of. And it has each a command-line and a browser interface, making it equally helpful for batch conversions and point-and-click use.
Tabula did very effectively on PDFs of low or average complexity, though it did have a problem with the complicated one (as did lots of the paid platforms). Tabula requires a separate Java set up on Home windows and Linux.
Ranking: Excellent — and you may’t beat the worth.
Value: Free
Execs: Free; simple to put in; has each a GUI and scripting choices; means that you can manually change what areas of the web page must be analyzed for tables; can save outcomes as a CSV, TSV, JSON, or script; affords two completely different knowledge extraction strategies.
Cons: Wanted some handbook knowledge cleanup on complicated formatting; works on app-generated PDFs solely.
Backside line: A good selection if value, ease of use, and automation choices are excessive in your listing of desired options and your PDFs aren’t scanned.
PDFTables
A key benefit to this service is automation. Its API is effectively documented and helps every little thing from Home windows PowerShell and VBA (Workplace Visible Fundamental for Functions) to programming languages like Java, C++, PHP, Python, and R.
PDFTables carried out effectively on many of the app-generated PDF tables, even understanding {that a} two-column header could be greatest as a single-column header row. It did have some problem with knowledge in columns that had been principally empty but additionally had some knowledge in cells unfold over two strains. And whereas it choked on the scanned nightmare PDF, at the least it didn’t cost me for that.
Ranking: Excellent total; glorious on automation.
Value: 50 pages free at signup — together with API use. After that it’s $40 for as much as 1,000 pages, and your credit are solely good for a yr.
Execs: Excellent API; higher efficiency on the reasonably complicated PDF than a number of of its paid rivals.
Cons: Expensive, particularly for those who use greater than the 50 free pages however lower than 1,000 web page conversions in a yr. Doesn’t work on scanned PDFs.
Backside line: Performs effectively and is simple to make use of each on the internet and thru scripting and programming. If you happen to don’t want a sublime API, nonetheless, it’s possible you’ll desire a inexpensive possibility.
PDFtoExcel.com
It is a freemium platform with paid choices. It proved to be the lone free selection that was capable of deal with our scanned nightmare PDF.
Ranking: Good.
Value: Free within the cloud, $5/month or $49/yr premium cloud for batch conversions and quicker service, desktop software program $35 for 30-day use or $150 lifetime.
Execs: Plenty of functionality for the free possibility; works on scanned PDFs; inexpensive.
Cons: No API or cloud automation (we didn’t check the desktop software program); paid possibility required for batch conversions; cut up single-row multi-line knowledge into a number of rows.
Backside line: Good stability of value and options. This was most compelling for complicated scanned PDFs, however others did higher when cell knowledge ran throughout a number of strains.
Cometdocs
This web-based service is notable for a number of file format conversions: Along with producing Excel, it might obtain outcomes as Phrase, PowerPoint, AutoCAD, HTML, OpenOffice, and others. Free accounts can convert as much as 5 information per week (30MB every); paid customers get a limiteless variety of conversions (2GB/day knowledge restrict).
Cometdocs is a supporter of public service journalism; the service affords free premium accounts to Investigative Reporters & Editors members (disclosure: I’ve one).
Ranking: Good.
Value: 5 free conversions/week; in any other case $10/month, $70/yr or $130 “lifetime.”
Professional: Works on scanned PDFs; a number of enter and output codecs; typically good outcomes; did extraordinarily effectively on a 2-page PDF with complicated desk format.
Cons: Not as sturdy on complicated scanned PDFs as another choices; cut up one row’s multi-line knowledge into a number of rows; no clear script/automation possibility.
Backside line: Significantly compelling for those who’re fascinated about a number of format exports and never simply Excel.
Microsoft Excel
Many individuals don’t know that Excel can import PDFs straight — however provided that you’ve bought a Microsoft 365 or Workplace 365 subscription on Home windows. It was a sensible choice for the straightforward file however bought extra cumbersome to make use of as PDF complexity rose. It’s additionally more likely to be complicated to individuals who aren’t aware of Excel’s Energy Question / Get & Rework interface.
The right way to import a PDF straight into Excel: Within the Ribbon toolbar, go to Knowledge > Get Knowledge > From File > From PDF and choose your file. For a single desk, you’ll probably have one option to import. Choose it and you must see a preview of the desk and an choice to both load it or rework the information earlier than loading. Click on Load and the desk will pop into your Excel sheet.
For a single desk on one web page, it is a fast and fairly easy selection. In case you have a number of tables in a multi-page PDF, this additionally works effectively — so long as every desk is confined to at least one web page. Issues get a bit extra complicated for those who’ve bought one desk over a number of PDF pages, although, and also you’ll want data of Energy Question instructions.
It’s considerably unfair to check Energy Question knowledge transformation with the opposite instruments, for the reason that outcomes of any of those different PDF to Excel converters may be imported into Excel for Energy Question wrangling.
Ranking: Good.
Value: Included in a Microsoft 365/Workplace 365 Home windows subscription.
Professional: You don’t have to depart Excel to take care of the file; a whole lot of built-in knowledge wrangling out there for individuals who know Energy Question.
Cons: Complicated to make use of in contrast with most others on all however the easiest of PDFs; doesn’t work on scanned PDFs; requires a Microsoft 365/Workplace 365 subscription on Home windows.
Backside line: If you happen to’ve already bought Microsoft 365/Workplace 365 on Home windows and also you’ve bought a easy conversion job, Excel is value a attempt. If you happen to already know Energy Question, undoubtedly contemplate this for extra PDF conversions! (If you happen to don’t, Energy Question is a good talent to be taught for Excel customers normally.) In case your PDF is more difficult and also you don’t already use Energy Question / Get & Rework, although, you’re most likely higher off with an alternative choice.
PDF to Excel check outcomes
Right here’s how the seven instruments fared in our 4 conversion assessments:
1. Easy PDF to Excel problem
Our “easy” job was a single-page app-generated PDF pulled from web page 5 of a Boston housing report. It contained one desk and a few textual content, however column headers and two knowledge cells did embody wrapped textual content over two strains.
All of the platforms we examined dealt with this one effectively. Nonetheless, a number of broke up the multi-line textual content into a number of rows. The problem was simple to identify and repair on this instance, however this concern might be tough in bigger information. For this simple one-pager, although, the PDF to Excel converters that weren’t in first or second place nonetheless had superb outcomes. All had been value utilizing for one of these conversion.
First place: Tie — Adobe and AWS Textract. With Adobe, no knowledge cleanup was wanted. The column headers even had the colour formatting of the unique. Adobe’s conversion included textual content (with pretty formatting), which is helpful if you wish to preserve written explanations along with the information in Excel. You’d have to delete the textual content manually if you’d like knowledge solely, however that’s easy sufficient.
AWS Textract transformed knowledge solely. No knowledge cleanup was wanted.
Shut second: Excel. Knowledge solely. Excel didn’t break wrapped textual content into two rows, but it surely did seem to run textual content collectively with no area with multi-line rows. The information was really right, although, if you checked out it within the components bar — it simply seemed fallacious within the total spreadsheet. This was simply fastened by formatting cells with “wrap textual content.” Nonetheless, not everybody would possibly know to try this when taking a look at their spreadsheet.
Others:
PDFTables: returned knowledge and textual content. Similar points as Excel with showing to maintain wrapped textual content in a single line with no area between phrases. This was additionally simply fastened by wrapping textual content, for those who knew to take action. This outcome additionally would wish cleanup of a few phrases from a emblem that appeared beneath the information. Explanatory textual content outdoors the emblem had no issues, although.
Tabula: knowledge solely. Cut up multi-line cells into a number of rows.
Cometdocs: knowledge and textual content. Cut up multi-line cells into a number of rows. Surrounding textual content was correct, together with emblem textual content.
PDFtoExcel.com: related efficiency to Cometdocs.
2. Average PDF to Excel problem
Our average PDF problem was a single app-generated desk spanning a number of PDF pages, through the Boston-area Metropolitan Water Sources Authority knowledge monitoring wastewater for Covid-19 traces.
First place: Adobe. One of many few to acknowledge that each one the pages had been the identical desk, so there have been no clean rows between pages. Headers had been in a single row and areas between phrases within the column names had been maintained. Knowledge construction was glorious, together with maintaining the multi-line wrap as is. It even reproduced background and textual content colours. The 11-page size wasn’t an issue.
Second: AWS Textract. Header row was right. Every web page got here again as a separate desk, though it will be simple sufficient to mix them. The one unusual concern: There have been apostrophes added at first of the cells — presumably because of how I cut up the PDF, since I wanted to create a file with solely 10 pages. Nonetheless, these apostrophes had been simple to see and take away with a single search and substitute, for the reason that knowledge didn’t embody any phrases with apostrophes. It was simpler to get the precise knowledge I wanted than with Tabula, however extra cumbersome to get the total knowledge set.
Shut third: Tabula. No clean rows between pages, knowledge within the right columns, wrapped cells stayed in a single row. Sadly, whereas the wrapped knowledge appeared correctly if you seemed on the cell contents within the components bar, as soon as once more the information appeared to merge collectively within the full spreadsheet — and this wasn’t as simply fastened by formatting with textual content wrapping as with Excel and PDFTables within the easy PDF.
For instance, this was the content material of 1 cell because it appeared within the components bar:
B.1.1.7
76%
However within the total spreadsheet, that very same cell seemed like
B.1.1.776%
I used to be capable of get that to show correctly at instances by rising the row peak manually, however this was an added step that most individuals wouldn’t know to do, and it didn’t appear to work on a regular basis.
Others:
PDFtoExcel.com: a number of issues. The primary few pages had been fantastic apart from multi-row headers, however knowledge over two strains in single cells broke into two rows within the knowledge, producing clean rows elsewhere that may have to be fastened. As well as, columns had been shifted to the proper in a single part. This would wish cleanup.
PDFTables: a number of issues. All the information got here in fantastic for many of the pages, however towards the top, a number of cells that ought to have been in column J bought merged with column I in ways in which could be harder to repair than PDFtoExcel’s. For instance, this single cell:
Omicron
559 23%
Was speculated to be 559 in a single cell and Omicron 23% within the subsequent cell.
Cometdocs: failed. Conversion failed on the total PDF and even the 10-page model I uploaded to AWS. It was capable of convert a model with simply the primary 5 pages, however the full file ought to have been effectively beneath Cometdoc’s account limits.
Excel: it was doable to get the information in a format I wished, but it surely required knowledge manipulation in Energy Question in addition to wrapping textual content. That’s not a good comparability with different platforms that had been a single add or command. Nonetheless, outcomes had been finally glorious. If you happen to’re an Excel/Energy Question energy consumer, it is a good selection.
3. Complicated PDF to Excel problem
Native election outcomes are a few of my favourite examples of analysis-hostile public knowledge. The app-generated PDF from Framingham, Mass. proven beneath was solely 3 pages however with desk formatting that was not designed for ease of knowledge import. Is there a PDF conversion software that may deal with it?
IDG
First place: Tie — Adobe and PDF to Excel. Adobe returned an Excel file in good format, full with unique cell colours.
Whereas PDFtoExcel.com’s spreadsheet didn’t have the beautiful formatting of Adobe, all the information got here in precisely, and it was usable as is.
Others:
AWS Textract: truthful. Outcomes got here again in 5 tables. In a single case, you’d want to repeat and paste them collectively manually and have a look at the unique to be sure to had been doing so accurately.
PDFTables: poor. Knowledge got here again, however some within the fallacious columns, whether or not I attempted to obtain as a number of sheets or one sheet. This would wish handbook checking and cleanup.
Tabula: poor. Comparable downside as PDFTables with some knowledge within the fallacious columns, however at the least I didn’t should pay for it. I attempted each the Stream and Lattice extraction strategies, and each had some wrong-column points (though the problems had been completely different).
Cometdocs: conversion failed.
4. Nightmare PDF to Excel problem
Our nightmare comes courtesy of a presentation at this yr’s Nationwide Institute for Pc Assisted Reporting convention, for instance of knowledge that may be helpful for coaching college students — if it was in a format that might be simply analyzed. It’s a multi-page scanned PDF with 4 months of knowledge from the federal Refugee Processing Heart on refugee arrivals by nation of origin and U.S. state of vacation spot.
This PDF’s challenges vary from multi-page tables to plenty of merged columns. As well as, the desk on web page 1 proved to be considerably completely different than tables on the opposite pages, at the least when it comes to how a number of instruments had been capable of deal with them, though they appear the identical.
I solely examined the primary 10 pages as a result of AWS 10-page restrict, to be truthful to all of the instruments.
First place: AWS Textract. By far one of the best of the group. That is the place refined machine studying is a bonus. Outcomes are obtain as a zipped file of a number of CSVs, one for every web page. As a substitute of manually importing these information one after the other into Excel, although, you may go to Knowledge > Get Knowledge > From File > From Folder and choose the folder with these newly unzipped CSVs (with no few additional information, reminiscent of one with metadata and one other with all of the textual content in textual content format).
I additionally needed to rename file table-10 to table-910, as a result of the import was placing table-10 proper after table-1 and earlier than table-2 (sorting the filenames alphabetically and never -9 after -10). Whereas I didn’t examine all the information, the rows I spot-checked had been all correct. This was the best solution to acquire all of the pages right into a single, usable spreadsheet.
Second: Tie — Cometdocs and PDFtoExcel.com. Cometdocs had unexplained “Grand” strains on every of the pages — a single row simply with “Grand” within the first column — however in any other case the information seemed superb. And it got here in a single file.
Together with textual content on every web page might be a profit or disadvantage, relying in your wants. Context is helpful, however combining the information into one desk would undoubtedly take extra work.
PDFtoExcel.com’s efficiency was much like Cometdocs — together with the additional “Grand” strains.
Others:
Adobe: truthful. Whereas a whole lot of the information was fantastic, outcomes merged some knowledge on the primary web page and would wish handbook checking and cleanup.
PDFTables: doesn’t work on scanned PDFs with out utilizing OCR software program first — though at the least it doesn’t cost account credit when tables aren’t detected.
Tabula: doesn’t work on scanned PDFs with out utilizing OCR software program first.
PDF conversion instruments we didn’t check
There are a variety of different helpful instruments on the market that require a bit extra setup work or some important coding so as to flip your PDF into knowledge you may analyze. If not one of the ones we examined be just right for you, although, listed here are a number of others:
Excalibur: I obtained a tip about this one, an internet interface constructed for the Camelot Python library. Nonetheless, it includes putting in a number of dependencies, and that set up could also be a turn-off for individuals who don’t have already got Python expertise (regardless that you don’t have to run Python so as to use it).
Google Cloud Doc AI: Google Cloud’s Doc AI setup is considerably extra concerned than utilizing AWS Textract. Plus, when you can add a check doc as much as 5 pages to see what’s extracted, I didn’t see an apparent solution to obtain the outcomes via the net interface as a CSV or Excel file — the one possibility was JSON. You’d most likely want a programming language like Python or R to make use of this successfully.
Microsoft Azure Kind Recognizer: That is additionally extra complicated to arrange than AWS Textract, however for those who’re already an Azure consumer, it is most likely value a glance. 500 free pages per 30 days.
