Skip to content

Data cleaning · Medium

What is Power Query and when should you use it?

Short answer

Power Query is Excel's built-in tool for importing and transforming data with recorded, repeatable steps — split columns, change types, merge and append tables, unpivot. Use it whenever you clean the same kind of file repeatedly; next time you just click Refresh.

Detailed answer

Typical steps: import a folder of monthly CSVs → set types → filter blanks → append into one table → load to the Data Model.

The applied steps are visible and editable, which makes the cleaning auditable — an advantage over manual edits.