Csv vs Csv

HI,

While on this site I noticed some difference with the format of CSV files.
I have created a file that has the "Hikashop" header names in row 1 from column A to column F. ( This format worked for me.)
Now, I also see that some user have the "Header" in column A only. But, the headers are separated with ";".

I know this is a generic example. But, can someone tell me why the difference?

Thanks

charlesdh wrote: HI,
Now, I also see that some user have the "Header" in column A only. But, the headers are separated with ";".

Korzo,

Thanks for your reply. But, I'm not sure if I explaned myself on I'm not understanding your response.
Attached you will see what I'm referring to.
Attachment 1 is a file that I created and saved as "CSV".

Second csv (hikashop-test.csv) is faulty.
There is mix of separators and in from second line, all separators are enclosed in quotes and therefore not recognized.
For example, here is snippet from csv:

"100003-1000;""Hoyt Handle Formula RX 25"""""";101;11;1",

"100003-1000";"Hoyt Handle Formula RX 25";101;11;1;

Korzo,

Thanks for the update on the correct format for the product information. But, in "A1" there is a string of data that I would assume is the formatted "Header" information( attachment2). This data is different than the formatted "Header" information in attachment 1.

This is what I was referring to in my first reply.
According to your time zone and what you wrote, I suppose you have comma as csv separator in your regional settings.

File Test_2015-01-10.csv has comma as separator and it opens correctly in your Excel.
File hikashop-test.csv has semicolon as separator and it opens all data in one column.

For me it's exactly opposite situation as I have semicolon as default separator in regional settings.

If I missed the point of your question, please post the screenshot of your problem.

Korzo,

Thanks. I'll check into changing my settings.
To see how attachment2 loads.
All I have to do is find the option for this. The web site you referred me to say's I need to change "Regional" settings. I can not locate it per the direction on the web site.

You don't have to change your regional settings.
If Excel doesn't recognize your csv file format, use "Get external data from text" on Data tab to import data from csv.
There is interactive interface where you can select delimiter, data format etc.

Thanks.
In attachment2. That is the "Exported" file to excel.
I can now see why the "Header" is in "A1" and different than my file.

My file attachment1 is a file that is to be uploaded to "Hikashop".
I wrote a code to convert this file.

nicolas,

Thanks. I reset the option and the export worked.
But, my primary concern was the format for a excel file (Csv) to be uploaded.
Between you and Korzo my thoughts are now straight.

nicolas,

Thanks.
My original confusion was when I look at a file that another user posted the "Hikashop Headers" were in "A1" and not across the columns.
With the file file that I uploaded thru "Joomla". I exported it and the data had a lot of ";". I then changed the Hikashop setting to ";" and exported again. This time the download was what I expected to see.

Once again thanks to you and Korzo.