Re: [libreoffice-users] ss not expanding excel csv sheet to multiple columns

On 05/13/2014 12:10 PM, Cley Faye wrote:
> 2014-05-13 20:32 GMT+02:00 John R. Sowden <jsowden@americansentry.net>:
>
> > I have a vendor who allows me to download a spreadsheet of my monthly
> > invoice.  If she downloads it to herself, in the CSV format, she gets 1
> > field per column in Excel.  If I download the sheet in the CSV format, I
> > get all of the fields in 1 column.  See headings below from libreoffice.
> >
> > Hardware Identifier","Device Type","Price","Initial Service Start
> > Date","Station Account","Customer First Name","Customer Last Name
>
> ​When​ you open a CSV file, a dialog appear asking you for many options.
>
>  From the look of your post, you have to choose "Separated by", "Comma", and
> set Text delimiter to double quote ("). You can try this, but to be sure
> having the actual csv file, even with only the first lines, would be useful
> (unless it contains sensitive data of course).
When I downloaded it, I was presented with the 'open with lo' or 'save file'

when I chose to open it with lo, all of the fields went into one column.

When I saved it, and then opened it using lo, I got the dialog you 
referred to.  A couple of clicks are, there we are!

thank you,

John


--
To unsubscribe e-mail to: users+unsubscribe@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