Recent Changes - Search:

Menu

Articles

Roadmap

Affiliates

edit SideBar

ConvertingToCSV

This page describes how to convert a file that is separated with Tabs, Pipes or other delimiter into a CSV file. You can do this with several spreadsheet applications. This page shows you how to do this with two. Microsoft Excel and OpenOffice.

Microsoft Excel

These instructions have been drawn up from using Excel 2007 but other versions are very similar if not the same.

Open the file you wish to convert.
Click Save As
In the “Save as type” field choose CSV Comma Delimited
Click Save

Open office

Open Office is a freely available office platform. It can be downloaded from http://www.openoffice.org

Open file you wish to convert
Save As (check filter options)
Choose the comma from the deliminator drop down menu
Save File
Edit - History - Print - Recent Changes - Search
Page last modified on April 13, 2009, at 10:23 AM EST