Open the program which you want to use to export the data to CSV file. This example will use the Microsoft Excel Spreadsheet.
Click the “File” option at the top-left corner. A drop-down menu will appear on the screen. Choose “Open” and you will see a new dialog box appearing the screen, asking you about the location of the data file, which will be in “.xls” or in “.xlsx” format. Navigate to the file directory and click on it.
Click the “Open” button and you will see your data appearing in the program window.
Open the “File” menu and click the “Save As” option. A new window will appear on the screen, asking you about the type of file you want to create.
Click the “Save as type” field and you will see a drop-down menu, from which you need to select the "CSV (Comma Delimited)" file format. This will save the file in your required CSV file format.
If you want to make any changes to the name of the data file, then you need to highlight the “File name” field and write the new file name. Otherwise, the name of the file will remain the same, while the extension will be converted to CSV. When you are done with finalising the name of the file, click the “Save” button and your file will be saved on the hard drive.
You can now use the CSV file with another program. For that purpose, open the program and repeat the same process which you used to open the XLS file in MS Excel Spreadsheet.