Relying on macros, however, generally requires some programming knowledge (I’ve written several posts about VBA and macros).Additionally, depending on your situation, you may need to spend time maintaining the procedures you use.
You can find Get & Transform within the Data tab of the Ribbon.
To begin the process of creating a query to import data from a workbook with Power Query, go to Ribbon From Workbook" width="800" height="423" srcset="https://powerspreadsheets.com/wp-content/uploads/new-query-from-workbook-1800w, https://powerspreadsheets.com/wp-content/uploads/new-query-from-workbook-1-300x159300w, https://powerspreadsheets.com/wp-content/uploads/new-query-from-workbook-1-768x406768w" sizes="(max-width: 800px) 100vw, 800px" / Alternatively, you can use the keyboard shortcut “Alt, A, PN, F, W”.
You can get immediate FREE access to the file examples that accompany this blog post by clicking on the button below: The example data that I use throughout this blog post is like that which I use in my Pivot Table Tutorials, such as this one. Notice, for example, how the dates within the first column of the source data below aren’t properly formatted.
Further below I explain how Power Query can help you deal with these issues.
The Import Data dialog box looks as follows: This dialog box may look familiar.
Its design is like other dialog boxes you find when carrying out common Excel procedures, such as opening a workbook or saving a file.This includes, for example: However, regardless of the type of Excel file you import, Power Query limits itself to working with data in cells.In other words, items such as Pivot Tables, charts or macros aren’t imported.Common approaches involve manually importing data or using Visual Basic for Applications to automate the process.In several circumstances, neither of the first 2 approaches to importing data I mention above (manually or VBA) may be the most appropriate.Additionally, as explained by BI expert Chris Webb in Because of the above, learning how to use Power Query has the potential to save you a substantial amount of time and make you significantly more efficient when importing data into Excel.