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: jslozier@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
> jslozier@gmail.com
>
>
> -- 
> For unsubscribe instructions e-mail to: users+help@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+help@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