Microsoft Excel Tips and TricksEasily combine multiple PDF files with one click and get them properly formatted in Excel. Don’t waste your time copying and pasting because copying and pasting a pdf into Excel doesn’t work. Everything ends up in a single column and you will have to manually correct each field. In this video I’ll show you how to import all PDF files from a folder by using Excel’s Power Query – Get Data functionality. You’ll also learn how to make it automatic so when a new file is dropped in the folder, you just need to refresh your combined result and you get the latest data added.
Credit Leila Gharani