Importing Data from CSV in Excel
In Excel 2016, we can import data from CSV in a reproducible way. The import wizard allows us to perform a number of transformations that get stored and are accessible from the query / connection that gets retained. This means the import can be re-run at a later date with new data or additional transformation steps could be added.