I am having no luck at all with exporting my .csv file from Excell. When I do it does not put the required "Quote" Marks before and after the "," commas. I have hundreds/thousdands of tires in an excell spread sheet that have the correct headers. Its just not putting the quote marks in my CSV file.

If anyone figures this out please let me know what you did to get your file to correctly save as a CSV from excel.

Thank you Soooooooooooooo Much.

Dave

I have worked in the office and used spread sheets before excel was invented. I never knew you could save a CSV to use quotes. What you can do is open the csv file in notepad and replace all (,)'s with ("," ) .

I can't use SCCP on my big website so I have not had a need to upload my products.

Good luck

Hi Dave,

I had all sorts of problems getting the excel spreadsheet right. I asked Scott for help & he sent this:-

Ok, I think I found the issue. The CSV file is not properly formatted. Each value needs a quotation mark around it. It should look like this:

"sku";"title";"shortdescription";"longdescription";"weight";"weightunits";"showweight";"metakeywords";"metadescription";"featured";"upload";"options1";"options2";"options3";"options4";"options5";"forceoptions";"category";"parentcategory";"retailprice";"discount";"applypercent";"tax";"shipping";"handling";"defaultshipping";"typequantity";"defaultquantity";"minrangequantity";"maxrangequantity";"stockunits";"storeunits";"showstock";"image0";"image1";"image2";"image3";"image4"

No disrespect Scott but I hadn't a clue where to start with that!

This is what I did, not sure if it is right or wrong but it worked for me.

Opened a shop I had created with SCC basic & upgraded it to pro.
Go to "export to .csv" from the file menu.
Select Comma (,) in the "field separator" field.
Click export.

This way you end up with a spread sheet with columns with headings & all the data from your shop listed under the correct headings. I then used this as a template, made some changes then imported it back into SCC pro. Just to see if everything worked. Yah! & not a quotation mark (") in sight.

I tried doing the find and replace but that did not seem to work for me, it added a few extra " marks. which made the file not work... I know excell can save your file as a CSV I have always used it to export contact lists and other database items but I have never seen a CSV file with Quotes like that until now..

Thanks Sue, the whole reason for me to use the import csv function is that I have all my products in an excell spread sheet. I can export to a CSV file with no problem except for the fact that excell does not put quotes around everything and to have to go into each cell and put quote marks in is not going to work for me.

Someone has to have some kind of little software package out there that I can export from excell as a CSV and import into there software and then export it again as a csv with these quote marks....

Dave, I can't understand why you would need quotation marks in the first place. There must be a reason or CoffeeCup would'nt have given it as an option in the first place. I have only ever used excel for spreadsheets, so do not understand formats other than columns with headers. All I did was to click save as in excel, then select "other formats" then select CSV (Comma delimited) from the drop down list under "Save as type". It doesn't put (") marks in & will work in SCC pro.

The reason why is you could have one of those delimiters in any one of these fields:

-For price, weight etc, most countries outside of the USA use a comma instead of a decimal. So $1.00 would be $1,00

-For the long and short description , you may have a coma or semicolon in the description.

This issue also applies to many of the other fields as well. The "" around them allow us to parse the data accurately.

After the last cell entery in row 1 put a " mark, put one more quote mark in the next cell to the right of that.


Cell AM1 put a "
Cell AN1 put a "

Then in cell AO1 put this code (=$AM$1&A1&$AN$1)

Copy these three cells down to the bottom of your list.

Copy cell AO1 down to the bottom to as many cells to the right as you need to put quotes in front of and behind.

Now block and copy all your new data and paste it as values only. Save as CSV and it should work.

You rock man!

Have you tried to save as an excel file and then re open it and save as csv? I bet your formating will be gone.