Usage
To load the CSV Exporter tool, press Ctrl+Shift+C with Excel active.
Default View
Click any image for a larger version, if available.
To indicate the desired output folder, click Select, browse to the folder, and click Select in the picker dialog (here, choosing C:\).
Folder Picker Dialog
Enter the output file name, the number format, and the field separator, and indicate append or overwrite. For the 'General' number format, generally the code @ works satisfactorily.
Output Settings Entered
Select the desired range to export to the indicated file.
Exporting a Range
Click Export.
The dialog box for the tool is modeless, so you can leave it open while navigating worksheets and/or opening new workbooks in order to find the data to export.
Alternatively, as long as Excel remains open and no uncaught errors occur, the dialog stays in memory even after being closed. Thus, it will remember the folder, filename, and other settings when it's reopened with Ctrl+Shift+C.