{"id":1336,"date":"2021-03-21T17:18:30","date_gmt":"2021-03-21T09:18:30","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1336"},"modified":"2021-03-21T17:19:16","modified_gmt":"2021-03-21T09:19:16","slug":"extract-pdf-tables-to-excel","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2021\/03\/21\/extract-pdf-tables-to-excel\/","title":{"rendered":"Extract PDF tables to Excel"},"content":{"rendered":"

So you need to extract data from tables in PDF files to Excel.\u00a0 The first thing you need to try is to copy the data from the PDF file in your PDF reader and paste it into Excel.\u00a0 It might just work.\u00a0 \u00a0Not if you’re using Acrobat Reader though – it’ll just appear as lines of text.\u00a0 Try Foxit PDF Reader – if your table looks something like this:<\/p>\n

\"\"<\/p>\n

copying and pasting should do the trick.\u00a0 However, if your table has empty cells like this:<\/p>\n

\"\"<\/p>\n

or is free form like this:<\/p>\n

\"\"<\/p>\n

you’ll still end up with wrongly formatted text.<\/p>\n

Your next option is to explore the online extraction services like PDFTables, which is quite good at extracting tables.\u00a0 However, you may not be comfortable submitting your sensitive files to a third-party.\u00a0 If so, consider using PdfToXls<\/a>.<\/p>\n

It’s a FREE Windows application that lets you extract data from PDF tables into Excel.\u00a0 It runs on your machine, so your files stay on YOUR computer<\/span>.\u00a0 You define the table and column locations, and the application does the rest.<\/p>\n

If your table layout is complex, PdfToXls provides you the tools to adjust the data easily prior to exporting it.<\/p>\n

Download<\/a> your FREE copy now.\u00a0 Visit our web site<\/a> for more information.\u00a0 We also have a couple of videos showing the product in action.<\/p>\n