How to save excel worksheet as a comma delimited file

You can save an Excel worksheet as a comma delimited file. I.e. the worksheet columns will be saved in the file separated by commas. This will allow you or someone else who has no Excel, to browse the file in any text editor.

To save the worksheet as a comma delimited file:

1.       In Excel menu click File.

2.       Click Save As. The Save As window will open.

3.       In the Save as type drop down, select CSV (Comma delimited).

4.       Any row in the worksheet will be transformed like this:

“ABC;7268;87368;XYZ;373”

The delimiter is either a “,” or “;” depending on your installation of Excel.

Applies to: Excel 2007, Excel 2010