| View previous topic :: View next topic |
| Author |
Message |
charliegrigg
Newbie
Joined: 25 Apr 2008
Posts: 2
|
 Posted: Fri Apr 25, 2008 4:06 pm Post subject: Is there a way to import a txt file into Calc |
 |
|
In Excel you can import a txt file so that it opens as a spreadsheet. It asks you where you want the column breaks ect.
Everytime I try this in Calc, it opens up the world processor!
How can I do this import?
I am new to this posting stuff, so excuse me if I an not doing it correctly! |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Fri Apr 25, 2008 5:55 pm Post subject: |
|
|
Try renaming the file as "filename.CSV" instead of "filename.txt".
David. |
|
| Back to top |
|
|
hol.sten
Super User
Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany
|
| Posted: Fri Apr 25, 2008 10:56 pm Post subject: Re: Is there a way to import a txt file into Calc |
|
|
| charliegrigg wrote: | | How can I do this import? |
Call "File" > "Open..." and use the appropriate File type "TextCSV (*.csv;*.txt;*.xls)" from the list. |
|
| Back to top |
|
|
charliegrigg
Newbie
Joined: 25 Apr 2008
Posts: 2
|
| Posted: Mon Apr 28, 2008 7:07 am Post subject: |
|
|
Changing it to a CSV file worked! Thank you.
Using open, and selecting the txt file type did not work, it still opened up the Writer.
Thanks to both of you for your suggestions! |
|
| Back to top |
|
|
hol.sten
Super User
Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany
|
| Posted: Tue Apr 29, 2008 12:28 pm Post subject: |
|
|
| charliegrigg wrote: | | Using open, and selecting the txt file type did not work, it still opened up the Writer. |
I suggested the usage of the File type "Text CSV (*.csv;*.txt;*.xls)" (which opens in OOo Calc, because it is an OOo Calc Import Filter) and not the File type "Text (*.txt)" (which opens in OOo Writer, because it is an OOo Writer Import Filter). |
|
| Back to top |
|
|
|
