The cons for this method are simple: Excel doesn’t do a great job of interpreting PDF content. Since PDFs are not dynamic, this means saving a new file with updated information in the same place with the same name. The pros for this method include lasting queries and connections from your source so that, if you wish, you can update your workbook data simply by updating the original file. In Excel 365, you will use the Get & Transform tools to convert PDF data into a worksheet. They are not, then, collections of letters and numbers easily converted to other programs that deal more elegantly with text and data. By design, PDF files are graphic, visual documents meant to be viewed as a set of pixels organized in relationship to each other. The nature of the PDF file format, however, makes this problematic.

Powerful tools are destined to collaborate. It is no wonder, then, that every now and then the need to convert information stored in a PDF into an Excel worksheet comes up.

The Portable Document Format, known best by its acronym and file type “PDF”, was developed by Adobe Systems in 1993 and has remained the standard for consumer printing, publishing and electronic sharing ever since. By Tepring Crocker Categories: Basic Excel, Excel®, Functions Tags: data, Excel, pdf, pdf files

Import table from pdf to excel