![]() If you are regularly importing from pdfs and you want new pdfs or updated pdfs to automatically update your spreadsheet, then you should be using Power Query. Microsoft Word also allows you to convert a pdf into a Word document, from where you can also copy and paste. If, however, you first paste into Microsoft Word and then into Excel, it does work. If you have ever tried copying and pasting a table directly from a pdf into Excel, you will know it doesn’t work. ![]() Often the data you want to import from a pdf is in a table. In this video I demonstrate how to import a table of data into Excel from a pdf file.
0 Comments
Leave a Reply. |