A repeatable Excel macro workflow can import a bank CSV, clean dates and amounts, normalize merchant names, apply categories, ...
No more Power Query needed.
Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...
You can insert or generate the data for the CSV file in Microsoft Office Excel 2007 and then save the file in CSV format. CSV files outputted by Excel 2007 can be used in any program that can read ...