RE: [libreoffice-users] Opening a CSV file with Calc
On Sat, 2012-09-29 at 03:12 -0400, Jeff Hahn wrote: > Thanks. Unfortunately the suggestions did not work. I am using Windows 7. > The only way I have been able to open the file with LO is as a TXT file. > When I try to open with Calc the "text Import" window comes up. The > Character Set is "unicode" and the language is US English. I have tried > every combination for "Separator Options" and "Other Options" but nothing > seems to work. As I stated in my original post, Excel opens the file without > difficulty. What I have been doing is opening the downloaded file with Excel > and saving it to and ODS file. Thanks. Jeff > > Date: Fri, 28 Sep 2012 22:26:50 -0400 > > From: jsloz...@gmail.com > > To: users@global.libreoffice.org > > Subject: Re: [libreoffice-users] Opening a CSV file with Calc > > > > On 09/28/2012 09:41 PM, Jeff Hahn wrote: > > > > > > I download financial information from Yahoo Finance. The download is a > > > CSV file format.Athought I am able to open it with MS Excel I am not > > > able to open it using LO except as a text file. Any suggestions on how > > > I can open the file with Calc? > > > Thanks. Jeff > > Jeff, > > > > I assume you are using Windows. If so, right click and select "Open > > with" then select Calc if the file extension is csv. The csv import > > wizard should start automatically. Alternately, open Calc and then > > INSERT >>Sheet from File. The second method will allow to import *.txt > > as well as *.csv files. Either way you should see a dialog box showing > > the current import settings and a preview of the import. If the columns > > are incorrect you can change the column delimiter. Common delimiters are > > comma, semicolon, tab, and pipe (|). > > > > If you have any dates, click on the "standard" above the date column and > > select an appropriate date format. This will ensure the date is imported > > as a date. Often dates are shown as 2013-26-05 00:00:00. > > > > -- > > Jay Lozier > > jsloz...@gmail.com > > > > > > -- > > For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > If the file contains floating point numbers make sure you click on detect special numbers. Regards, Les H -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening a CSV file with Calc
Hi Jeff, Jeff Hahn schrieb: Thanks. Unfortunately the suggestions did not work. I am using Windows 7. The only way I have been able to open the file with LO is as a TXT file. When I try to open with Calc the "text Import" window comes up. Then you are using the wrong filter. Start Calc. File > Open and in that open dialog select your file. In the lower part of the dialog use the drop-dow list "file type", scroll the list till item "Text CSV (*.csv, *txt)". That item is forth last of the "spreadsheet" section. Open. If it still opens in Writer, then the file is not a csv file and someone gave it a wrong file name extension. In that case open the file in an editor and post the start of the file here. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Opening a CSV file with Calc
Thanks. Unfortunately the suggestions did not work. I am using Windows 7. The only way I have been able to open the file with LO is as a TXT file. When I try to open with Calc the "text Import" window comes up. The Character Set is "unicode" and the language is US English. I have tried every combination for "Separator Options" and "Other Options" but nothing seems to work. As I stated in my original post, Excel opens the file without difficulty. What I have been doing is opening the downloaded file with Excel and saving it to and ODS file. Thanks. Jeff > Date: Fri, 28 Sep 2012 22:26:50 -0400 > From: jsloz...@gmail.com > To: users@global.libreoffice.org > Subject: Re: [libreoffice-users] Opening a CSV file with Calc > > On 09/28/2012 09:41 PM, Jeff Hahn wrote: > > > > I download financial information from Yahoo Finance. The download is a CSV > > file format.Athought I am able to open it with MS Excel I am not able > > to open it using LO except as a text file. Any suggestions on how I can > > open the file with Calc? > > Thanks. Jeff > Jeff, > > I assume you are using Windows. If so, right click and select "Open > with" then select Calc if the file extension is csv. The csv import > wizard should start automatically. Alternately, open Calc and then > INSERT >>Sheet from File. The second method will allow to import *.txt > as well as *.csv files. Either way you should see a dialog box showing > the current import settings and a preview of the import. If the columns > are incorrect you can change the column delimiter. Common delimiters are > comma, semicolon, tab, and pipe (|). > > If you have any dates, click on the "standard" above the date column and > select an appropriate date format. This will ensure the date is imported > as a date. Often dates are shown as 2013-26-05 00:00:00. > > -- > Jay Lozier > jsloz...@gmail.com > > > -- > For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening a CSV file with Calc
Hi Jeff, Do you apply the correct separator (,;tab) and coding when opening the csv-file? Regards Heinz On Sat, 29 Sep 2012 03:41:17 +0200, Jeff Hahn wrote: I download financial information from Yahoo Finance. The download is a CSV file format.Athought I am able to open it with MS Excel I am not able to open it using LO except as a text file. Any suggestions on how I can open the file with Calc? Thanks. Jeff -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening a CSV file with Calc
On 09/28/2012 09:41 PM, Jeff Hahn wrote: > > I download financial information from Yahoo Finance. The download is a CSV > file format.Athought I am able to open it with MS Excel I am not able to > open it using LO except as a text file. Any suggestions on how I can open > the file with Calc? > Thanks. Jeff Jeff, I assume you are using Windows. If so, right click and select "Open with" then select Calc if the file extension is csv. The csv import wizard should start automatically. Alternately, open Calc and then INSERT >>Sheet from File. The second method will allow to import *.txt as well as *.csv files. Either way you should see a dialog box showing the current import settings and a preview of the import. If the columns are incorrect you can change the column delimiter. Common delimiters are comma, semicolon, tab, and pipe (|). If you have any dates, click on the "standard" above the date column and select an appropriate date format. This will ensure the date is imported as a date. Often dates are shown as 2013-26-05 00:00:00. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening a CSV file with Calc
On Fri, Sep 28, 2012 at 6:41 PM, Jeff Hahn wrote: > > > I download financial information from Yahoo Finance. The download is a > CSV file format.Athought I am able to open it with MS Excel I am not > able to open it using LO except as a text file. Any suggestions on how I > can open the file with Calc? > Thanks. Jeff > I think that the easiest way is to open up Calc and drag the file into the window. nvsoar -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
