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: 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
>                                         
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+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