ss not expanding excel csv sheet to multiple columns

users
#1

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

I tried to save it in one of the excel formats, no change.

Thoughts?

John

#2

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

#3

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