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

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).

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