Applied Users Forums

Hardware & Infrastructure => Open Source => Topic started by: Jan Regnier on November 17, 2016, 10:36:36 AM

Title: Convert Table or List in PDF to Excel
Post by: Jan Regnier on November 17, 2016, 10:36:36 AM
I received this info from "Steve Anderson's TechTips" - has anyone used this or know about it?

"Easily Convert a Table or List in a PDF Document into an Excel File
 
 
Today, I have a quick tip that you might want to tuck away so you can find it later.
 
Some documents contain a list (like a membership list) or a table of information that you want to be able to manipulate as data in Excel.

I came across a very simple website, PDFtoExcel.com, that does just that – converts any table or list in a PDF document (scanned or regular) into an Excel-compatible file.

Following are a few benefits to using this site:

Safe and Secure: According to them, all data uploaded to their servers will be used for conversion purposes only and deleted promptly after conversion. Your files are accessed only by automated software agents.

Full Document Conversion: The website converts documents of all sizes. No matter how complex your data tables are, they will be converted accurately without the need for further formatting.

Exact Spreadsheet Recognition: All tables trapped in a PDF will be extracted accurately. The rows and columns structure will be the same as in the original file, but fully editable and ready for reuse.

Excel's .xlsx Format: The new spreadsheet will be in .xlsx format ready to use in Microsoft Excel (versions 7, 10, 13), LibreOffice Calc, OpenOffice Calc or any other Office Suite compatible with MS Office.

No Email: There is no need to leave an email address or other identifiable data. Upload your file and the document will be converted right on the page.

Extract Scanned Tables: Besides regular PDF files, the service works with scanned PDFs as well. Using the latest OCR technology, it accurately recognizes numbers and data.

Fast and Easy: Conversion speed depends on the file size, but for average size files it will not take longer than a minute.

Drive, Dropbox and OneDrive: Import PDFs from your Google Drive, Dropbox or OneDrive account. Log in, choose a file, and start converting.

Free: This service is completely free. There are no ads, no hidden costs or limits. Try it out right now.

It is hard to verify the accuracy of the statement that no documents or data is retained by the site. I had an email conversation with the owner that reiterated this statement. The website was first established in 2005, so it has been around a while. So, make your own decision about the documents you upload.

I uploaded a two-page attendee list that was converted to an Excel file in just a few seconds. I could not find any errors in the converted document. "
Title: Re: Convert Table or List in PDF to Excel
Post by: Jeff Zylstra on November 17, 2016, 11:20:21 AM
Thanks and +1 Jan.  I think this is one of the reasons why some people kept PaperPort around.  This gives everyone options.  Thank you!

Also, I've noticed more support in Office for PDF files lately.  I know it writes to PDF files, but I'm not sure if it will read them or not.  It wouldn't surprise me if someday there was rudimentary support for reading them as well.