PDF to Excel Converter

Thank you for the amazing tutorial, this is life-changing for work!

There is no option to upload pdf to my excel even though I use Microsoft Office 2019 which has been updated to 365. I can only upload pdf in Power BI

Hi Kevin, great video. I have a question, I often work with large PDF's that no matter what I try I can only get one page at a time to load in to excel. Is there any way to get around that?

What version of excel are you using?

I don't find this on my excel

why do all PDF to excel videos only show just the data. I require all. Page and data as it is in PDF. so as not to copy paste to save countless hrs. but i need it all laid out as it is in PDF. not on separate pages

Assistance Needed with Power Query Error

I have a folder named BankStatPDF that contains one Excel file named ConsolBS and two PDF bank statements named BankStatementMay and BankStatementJune.

I transformed the BankStatementJune PDF file using Power Query in the ConsolBS worksheet, and it worked perfectly. However, when I changed the source file from BankStatementJune to BankStatementMay, I encountered the following error:

Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Id=Table001
Table=[Table]

Note: The PDF file BankStatementJune has 9 pages, so it was converted into 7 tables in Power Query. The PDF file BankStatementMay has only 3 pages. The format and bank statement details are the same for both files, and they are from the same bank.

The Power Query editor has created 7 query tables of these 9 pages for BankStatementJune. I appended them into a new query named "Statement," so I now have a total of 8 queries. All of these 7 query tables showing the same error except the "Statement" query, which displays:

An error occurred in the ‘Table001 (Page 2)’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Id=Table001
Table=[Table]

Please guide me on how to fix this error.

Note: The PDF file BankStatementJune is used to transform data in power query that has 9pages so it converted into 7tables. The PDF file BankStatementMay have only 3pages. rest the format and bank statement are same and of one bank.

Thank you for your assistance.

I really enjoyed your informative video! You might want to consider using the VeryPDF PDF to Excel Converter. This Windows software automatically converts PDF files into Excel spreadsheets and can even combine multiple PDF files into one while preserving formatting.

What if I have 2 tables in different pages, can I use this method now?

Exactly what I needed, thanks a ton

Great👍

I don't have thr same options in the data dropdown menu. No "from file" option :(

I have Microsoft 365 proplus, doesn’t have get from pdf in data from file. It doesn’t even have xlooup. Or clipboard from status bar

There is no such option in Excel 2007

Superb

How are you? I want to see the another PDF to excel demonstration from you for APPEND QUERY, which would contain various tables and various other information. Thanks,

"From pdf" not showing in my Excel (MS Office 2019 Plus) and I want to "import" multiple pdf files. Can you help please.
I am aware of the single file workaround with "= Pdf.Tables(File.Contents....", but is is only for a single file. Is there away to add multiple files?

Does not work with my copy of Excel 365. Data\Get Data\Get Data From File causes Excel to freeze almost from the moment I click on it. I tried clearing the Power Query cache but that didn't help. And in the most recent versions of Excel 365, Microsoft removed the option to disable hardware acceleration, so I can't do that either.

Great Information! I transfer information from a PDF to excel all the time. I also import tables from Word to Excel.

Thanks for the informative video. Need more tips and help on the Power Query. Changing column widths and data type (you showed the detech function but how to tell the column should be $$) Thanks you!

Your videos are stellar.

Awesome!

Thank you for explaining what the Cancel button does! That was super helpful!

Great

HI KEVIN NOT SHOWING PDF FORMAT PLS HELP OFFICE 2021

Thanks a lot. Applied accodingly, but new files in the folder are not taken as an update after refresh. How to fix?

Hi i got your tutorial but when i repeat it the pdf option is missing on get data

This is insane, love it🎉

My drop down doesn't show a PDF option, it has other options like Text/CSV, ISON... but no option to import from PDF?

I have multiple excel in some excel data is available in table 3 and in some excel same data is available in table 4 . So how to transform both table? Pl support me

sir i can't save the file through word message appears its file is read only

Thanks for the upload, I have excel 365 but the "From File" does not show up. Anyone know how to rectify that ? Thanks

This function not available in our excel

Great video and explaination. However my stand alone install (v2016) NOT 365, does not have the intial choices of file types. PDF is not in the list.
Downloading the the msi and reinstalling is redundant as the installer tells me immediately it is already installed. So I sense I am missing something. How do I configure to expose the same choices as your video.
This is a great option for me as I currently use Powershell scripts, for the the same task which is very tedious. Can anyone help here.
Thanks a lot.

where can i find the get data toolbar

Great video, doc! What about if the PDF files have each a password?

i dont have that option from pdf on my excel

I was trying this data but when ur pdf table values are long for example stanfordhospital university. When u try to transform data it gets adjusted in 2-3 rows in excel and whole data gets overlapped or chaotic

Hi Kevin my excel 2019 I do not have the function to import from PDF is there something one should do to get it as an option?

In the GET DATA drop down and FROM FILE I have no PDF option. Where did it go? What do I do now?

Great video and tutorial Kevin. I've just been introduced to this pdf to excel feature and want to use it to grab my monthly bank statements and insert into excel. However, my pdfs usually consist of two pages and 3 or 4 tables. The first one is irrelevant as it consists of my account, name, balances and various notes and comments. The actual data I want is in the other ones. Could you do a demo on how to do something like that?

The idea of automatically adding a new month's worth of data is very exciting.

Thanks

>>Dear Cookieman:
>>I take a number of prescriptions that must be renewed on a regular, NON-synchronized basis (30-60-90 days for the insurers' best price for me, not the retail pharm price and six month limit on standing orders for the pharm).
>>Although I have a spreadsheet, I still have to count all the pills in each vile -- VERY tedious. Each of us has differing date requirements, too!
>>Both my doctor and pharmacist need updates and order data, including Rx numbers plus new scrips as the MD issues these new standing orders; he drives the system forward and together we all steer the helm! Doc needs to oversee my use, and Pharm has to comply, presenting a rich minefield of discontented high functioning people.
>>Going into the Dr.'s pill renewal drop down does not connect all three users with their DEA licenses, much less me, the patient. HELP!
Respectfully NHG

For a one page simple invoice this is fine. I have never experienced a single page simple invoice in my entire career and unfortunately this video was not helpful.

Hi Kevin, This is great, in my PDFs there are rows not in every single PDF, for example particular item is not sold on every invoice, when it's missing, I get error column not found. how to handle that type or error?

Hello Kevin, in your video about importing PDF files, what version of Excel are you using?

in my excel there is no pdf file choice.. please help me.. how to add pdf file choice

Has get and transform gone on the newest 365? i can't find this in my excel

HI Kevin thanks so much! Is there an easy way to work with this method for bank statements? Thanks

Hi Thank you for this amazing tutorial. I have one more question I would like to integrate SAGE INTACCT and Dynamics to exchange data on customer through the webservices account. Or any other way as long the two platform will communicate.