Every month, I have to import up to 20 csv files in to Excel on my Mac. I usually copy the content of the file to the clipboard then from the Excel toolbar, Paste->Use Text Import Wizard because it is right there in the toolbar.
For every file, I have to change the delimiter setting - deselect Space then select Comma. It's only two clicks but for some reason, it annoys me intensely.
If I use File->Import and choose the (default) CSV file setting, it defaults to TAB, so either way, I have to change it.
This question - how to permanently set the default separator for CSV - must have been asked thousands of times, and I can see answers for Windows, answers for Excel 2008, but no answers for Excel 365 on Mac.
Can I change the default column separator for the Text Import Wizard for Comma Separated Values files to actually be a comma?
Mac OS is Mojave 10.14.6
Excel for Mac is 16.46
Thanks for your help,