Free pdf to Excel converter

AXISHK
AXISHK used Ask the Experts™
on
Is there any free PDF to Excel converter ? I don't want cloud solution as I'm afraid that the file is disclosed.

Thx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager
Commented:
I haven't seen any free pdf converter  that does an adequate job. The best one that I have found is Able2Extract which unfortunately isn't free.
Hmmm ...

from a basic aspect, PDF is not a format which is easy to convert into the strict limitation of an Excel sheet - it merely consists of text to be formatted and placed at positions on the page, probably garnished with images positioned somehere, too. Scanned documents are simply images on the pages, with (hopefully) OCR text in the background to allow copy&paste.

With that in mind, you could be considreably successfull on importing by just mangling your PDF file thru one of the numerous "PDF to plaintext" converters, and importing the result as .txt into Excel.

Main problem would be to split into the columns correctly.

Converting scanned documents would be far more tricky due to the fact that the additionally needed OCR step would produce lots of spacing irregularities - which would be a hell to fix.
I have used pdftoexcelonline  it is much fast and most of the time gives good result.
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Professor JMicrosoft Excel Expert
Top Expert 2014
Commented:
@AXISHK

here are my thoughts.

first of all  if your PDF is not a scanned PDF meaning the input is not an image then you do not need a software to export it to Excel, you can save as as text file and then open the text file in Excel see this video

if you insist on having free software then here are the two top rated softwares
Nitbits
Bluefox

in case if you have Pdfs that are image meaning the embedded data is not text but an image via scan or photo, then in that case nothing beats the Able2Extract software as Roy pointed and is not free.
Developer
Fellow 2017
Most Valuable Expert 2018
Commented:
"Free" and "not cloud" take away most of my usual recommendations for PDF-to-Excel. Best I can do is a 27-dollar, non-cloud solution. There are two of them:

(1) PaperPort 14 — currently, $27.50 at Amazon:
http://www.amazon.com/Nuance-Communications-Inc-6809A-G00-140-Paperport/dp/B005CELKLM

It can scan directly to Excel and you can drag-and-drop a PDF onto the Excel icon of its Send To Bar, as shown in these two 5-minute EE video Micro Tutorials:
PaperPort Send To Bar - Part 1
PaperPort Send To Bar - Part 2

If you go this way, note that the Amazon product is version 14.0. I recommend upgrading it (free!) to 14.5, as explained in this EE article:
PaperPort 14 - Free Upgrade to Version 14.5

I also recommend installing Patch 1 (free!), as explained in this EE article:
How to install the Patch 1 update for PaperPort 14.5

PaperPort has built-in OCR, so if your docs are image-only PDFs, that won't be a problem — PaperPort will OCR them to create a PDF Searchable Image file, that is, a PDF with both the image and the text from OCR.

(2) Boxoft PDF to Excel — currently, $27.00 at its own website:
http://www.boxoft.com/pdf-to-excel/

But Boxoft requires that the PDF have text. So if your docs are image-only PDFs, you'll need to OCR them first. Here are two ways to do that for free. First, Boxoft itself has a free one:
http://www.boxoft.com/free-ocr/

Second, the free version of PDF-XChange Editor has OCR, as explained in this 5-minute EE video Micro Tutorial:
How to OCR pages in a PDF with free software

There are free cloud products that do PDF-to-Excel, but the two mentioned above are the lowest cost approaches that I'm aware of for a local install. Btw, it is important to understand that no PDF-to-Excel converter does a perfect job — not even the very expensive ones. Some do a good (but not perfect) job of maintaining the formatting, which is always the trick with any PDF-to-Excel (or PDF-to-Word) conversion.

As a disclaimer, I want to emphasize that I have no affiliation with any of the companies mentioned in this post and no financial interest in them whatsoever. I am simply a happy user/customer. Regards, Joe

Author

Commented:
Thx
Roy CoxGroup Finance Manager

Commented:
Glad we could help
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
You're welcome. Good luck on the conversion project. Regards, Joe
Here is a Freemium option that came on the scene about a month ago: Docparser

I have used them quite successfully for parsing out tables, and also single areas of data on PDF's into Excel and Google Sheets. They are however cloud...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial