Convert CSV to Excel automatically (PowerQuery option)

------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Convert CSV text file into Excel automatically with PowerQuery
00:10 GET DATA from Text files (Excel DATA ribbon)
00:20 Point to the CSV file (does not need to be open)
00:30 Old Text import window does not appear- new PowerQuery window
00:40 Change CSV file delimiter in PowerQuery (comma, semi colon, custom character etc)
01:10 Detect CSV delimiter- where to look
01:24 Load CSV straight away into Excel versus Edit it first with PowerQuery
01:45 Change where PowerQuery must look for CSV file or delimiter (updated CSV's, different folders)
------------------------------------------------------------------------------------------------------------------------------------------------------
Main options: