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.
Credit Leila Gharani