This feature now available to Excel 365 for Windows, Fast Track Insiders v 2006 build 12905. It would be useful if Get & Transform could unlock a PDF with a saved password.
Important data is more likely to be locked in a passworded PDF. Press CTRL+V or COMMAND+V to copy the selected table on the new Word document. Open the Word program on your device and click on Open New document. Select the table you wish to copy and press CTRL+C on a Windows device or COMMAND+C on Mac. That’s a pity and a little strange because Word can open a PDF after prompting for the password. Open the PDF file you wish to copy a table from. Password protected PDF’s are not supported. Using Get & Transform means that the PDF import options are repeatable and refreshable.įor example, a weekly PDF of values can be imported into Excel using the same settings each time. This uses the powerful PowerQuery part of Excel with all it’s nifty features for transforming the data to make it suitable for your needs. Importing details from PDF files isn’t ideal but sometimes it’s the only option available.Įxcel can detect tables in the PDF, choose one or more tables to import into Excel. Microsoft has gone ‘one better’ and made PDF’s a refreshable data source using Get & Transform. Excel 365 for Windows is getting a long-wanted option to import PDF’s into worksheets.
0 kommentar(er)
