Opening CSV and .TXT delimited files as spreadsheets in OpenOffice.org Calc

How do you open this

as this?

If you just choose File > Open, a text file will open in Writer.

Here's how to open it as a spreadsheet.

Choose File > Open.

In the File Type list, select Text CSV. The easiest thing is to click in the file type list and type T four times.

Then select the file you want and click Open.

You'll see this window. It might not look right at first.

So be sure to select the right delimiter (and deselect the wrong ones) in the Separated By section.

If it's a fixed-width file, select Fixed Width then drag the field separator to the right spots.

Click OK. You'll see the file in spreadsheet format.

---

---

Comments

[JR]

You're the best!! I do this all the time and the OO help files tell you to go into Insert> Page from file... which works, but can be a real pain.

Thanks!

[Solveig]

Hi JR,

Glad it helps. Looks like you're located somewhere near my old stomping grounds; I worked and went to school in Fargo, lived briefly in St Paul. Hope you're staying dry.

Solveig

[sorin]

These is a known issue in Ooo, please login and vote for these bugs in order to resolve this issue the right way:
http://www.openoffice.org/issues/show_bug.cgi?id=15220
http://www.openoffice.org/issues/show_bug.cgi?id=72627