How do I retrieve Data from a PDF in Excel?

How to enable get Data from PDF option in Excel?

So far I found some options to achieve what you want, but I am still looking for something better.

So far these are the ones I know and I will explain how to use them: 1) You can use Microsoft's own PdfReadRtf function in Excel, as described here: This will however only read the text content of a document. 2) You can use the COM Addin PDFExtract: It is a very reliable tool and easy to use. After extracting the pdf you can read it like any other Excel file.

Hope that helps! Using PdfSharp with C# will get you the data from the pdf file.

How do I retrieve Data from a PDF in Excel?

I'm trying to pull data from a PDF in Excel.

When I go to get the data, it comes up blank. There are no "text blocks" or anything. All I want is the titles (names, phone numbers, etc.) of the PDFs. Any ideas on how I can do this?
Thanks for your help! --David. If I'm reading your question correctly, you're asking how you can extract a table from a PDF in Excel without having to manually extract and paste them into the workbook as a table. I've used something like the following. It will open the tab delimited data directly into the workbook without a new worksheet.

Sub ImportData(). 'Open PDF. Shell "c:Program FilesAdobeAcrobat Reader 8.0ReaderAcroRd32.exe", vbNormalFocus
'Import Data into "Workbook Name". ActiveWorkbook.Sheets("Workbook Name").Cells.CopyFromRecordset TextFile("File Path", 1)
'Close Acrobat reader. Application.Quit AcroRd32.exe
End Sub. A couple of notes on this script; one is the need to use the 'File Path' which I've taken from the Script Editor and converted to a constant. And the 'Save As Type' of Tab delimited text; I'm not 100% on what this means but it should be compatible with most text file types in your system.

You will need to put the 'File Path' where it says 'File Path', obviously. This needs to be some file format you can open in Excel and import as a table.

When I ran the above I got the following: Hope that helps!