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, indicate append or overwrite, and set any desired options. For the 'General' number format, generally the code @ works satisfactorily. For the header row configuration, the From value can be left blank to indicate row 1.
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.