Cleaning Excel Datasets with Power Query Key Takeaways : Import your dataset into Excel via the Data tab, selecting the option to import from a text or CSV file.