Power Query in Excel is the data connection and transformation tool, accessible through Data > Get Data. It imports data from files, databases or the web, cleans it through recorded steps (types, filters, merges) and reloads it on refresh. The steps are written in the M language.
Example
Import a folder of monthly CSV files, stack them and remove blank rows in one replayable query.