Microsoft Excel Tips and Tricks
Easily 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