• Vehicles • Fashion • Recipes • Blogs • Hunt • Travels • Sport • Fun • Handmade • IT • Education
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
PDF to Excel Converter - Kevin Stratvert

PDF to Excel Converter - Kevin Stratvert

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
PDF to Excel Converter - Kevin Stratvert learn how to bulk extract data from multiple PDF files into an Excel spreadsheet. To extract data, we use Power Query functionality that is built into Microsoft Excel and this requires no third party add-ins. - Additional resources: - Sample PDF files if you want to follow along: https://1drv.ms/u/s!AmxrofZZlZ-whK5VdVJgd9yhcLqMXA?e=gSHkFj
Date: 2022-03-15

Comments and reviews: 10


I have trouble scaling this trick. It works well with around 30 PDFs, but when I try to load 600 PDFs it can not handle it. Additionally, it sometimes shifts the data in some of the columns to the right. It does not apply this to all of the columns however, so I can not simply delete or merge a column. Otherwise, really neat trick!!! Thank you for all the help!
reply

it seems like the latest version of excel doesn't allow you to do this. when i click on 'get data' there is no dropdown that looks like that, it's much smaller. there is no get data from file option. weird cos i have used your technique to do this before i have no idea why office would take this function away?
reply

what if you do not get the drop down list -from file- and the option -from PDF- I have microsoft 365 and it doesn't give the same drop down list. I think it would be good to let others know, other wise its a piece of cake when it all works fine and dandy............
reply

Hello Kevin, I tried this and it worked but when I tried to do it again with other pdfs, when I click on the file to go into excel it showed on the Display Options but when I click on the folder or the pages, they are blank, what am i doing wrong? Help, Help!!!
reply

hello kevin i canwt understand why when i want to convert PDF folder after i have the sample file edited and i cancel the last step all the other pdf file do not uoloaded and i get a row with errorrs???? and i'm following your video step by step?????!!!!
reply

Hello , Is it possible to convvert selective pages of pdf file into excel spreadsheet. I receive a pdf file of 200 pages and i want to convert only few pages of it into excel . Is it possible or not ?
reply

Excellent job Kevin. It might be handy to show how the corded for a cookie converts into an invoice and send it back to the customer. Putting invoice into another folder in the process.
reply

excelent video. I'm having trouble with configuring the import of data because my pdfs have many pages. How do I format the transform to include all the pages in each original pdf?
reply

Real cool and awesome to learn great discovery from Mr.Humble Kevin as our online coach in all fields of computer new technics update..Thanks a lot Kevin..
reply

This video is great Kevin. Thank you so much. It will help me with my project big time! But now I want a cookie and I don't have one.....oh man!
reply
Add a review, comment






Other channel videos