How to open and edit exported files

Opening a CSV File in a Calc Spreadsheet in Open Office

1. Start OpenOffice.org. You can be in Writer, Draw, Calc - it doesn't matter.

2. Choose File > Open (click the picture to see a larger version of it, if you need to).

3. The next window lets you specify how the file was created: commas separate the data in our .csv file so tick "Commas".

4. Also in the same window, if you have date-format data or other formats you want to specify, you can do that column by column.

5. When you're done, click OK. You'll see the data in a spreadsheet.

6. Opening a .csv File in Excel.

Open a new Excel document and navigate to the Data tab

1. Click From Text

2. Navigate to the CSV file you wish to open and click Import

3. From the newly-opened window, choose Delimited, then click Next

4. Check the box next to the type of delimiter and tick Commas, then click Next

5. Click Finish