Follow the steps below to convert your Excel spreadsheet to a CSV file:
Download the macro from this link: Macro.xls.
Open both the spreadsheet you want to convert to CSV and the macro.xls, and if prompted, Enable the Macro. You might also need to Enable Content.
All values must be entered into the Spreadsheet before the Macro is run.
Select the fields to be included in the file; do not select entire columns and rows. You can choose to include the Header fields.
Once the values have been highlighted, go to View and click the Macro button. If the Macro.xls file isn't open when the Macro window opens, there will be nothing to select. Close the Macro window and Open Macro.xls.
Click Run, and the Quote-Comma Exporter window should open. If it doesn't open, check to see if the Excel icon in the taskbar is flashing. If this is the case, click on the icon, and you should be able to see the Quote-Comma Exporter window.
Enter the Path, file name, and extension (this should be CSV) and press OK.
Note: When entering the destination, put in the full path when prompted. The file shouldn't be the same name as the original file, as this will overwrite the original and create a file with no data in it, which means that you would lose all of the data from the original file. If you receive an error about not being able to open the file, it could be because your selection includes cells that don't include any data. Check the selection and try running the Macro again.