Print

Task: Create a .csv file from a text file using Microsoft Excel

1. Open Microsoft Excel.
2. Click the Office Button, and choose Open (or if your version of Excel has a File menu, choose File > Open).

The Open form is displayed.

3. Choose All Files (*.*) and navigate to the text file.



4. Click Open.

The Text Import Wizard form is displayed.

5. In Original data type select Delimited.



6. Click Next.
7. In Delimiters select the delimiter type for your data.
8. Select Treat consecutive delimiters as one.



9. Click Finish.
10. Click the Office Button menu (or the File menu if your version of Excel has a File menu), and choose Save As > Other Formats.

The Save As form is displayed.

11. In the Save as type box select CSV (Comma delimited)(*.csv).
12. Enter a file name and click Save.