In short, Power Query has one primary purpose: to save you time when handling data. More specifically, it can be used to clean up data already in Excel, import and organize data from lots of ...

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.

Need to extract data from PDF files into a spreadsheet so you can analyze it? Find out how seven PDF to Excel conversion tools fared in head-to-head tests with increasingly complex data sources.

Learn how to export Microsoft Power BI data to Excel using this step-by-step guide with examples.

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.