modifying csv values

[Jonathan More]

Hi, I need to import lots of price tables to web shop and luckily it accepts csv files.
I have all the price tables in excel format and every value is in its own cell. (multiple rows also)
My problem is that in csv the prices should be between double quotes and separated with comma. (like "60","70","80","90","100",)

I have not managed to get that kind of output yet, how could I get this kind of result when saving csv from excel 2010?

[Richard Buttrey]

Hi,

Is it an option to concatenate all the columns together along with double quotes and commas into a single column of text values. Then export the single column as a csv.

[Jonathan More]

Thank you for this.
Would you be kind enough to let me know how exactly to do this in excel, or guide me the right way.

[Richard Buttrey]

Hi

e.g. with values in A1:C1

Please Login or Register  to view this content.

[Jonathan More]

Sorry, still struggling here, if I could offer examples:

This is the price table that I have, row 1 is product width and column A is product height, so prices are for dimensional products.

And this is the way that the shop will accept the csv files:

Any help converting these csvīs would be greatly appreciated!

Edit: Didn't realize that I can also attach files, please find this now updated.

[Richard Buttrey]

Hi,

Please upload the files to the forum. Most of us prefer not to use third party file depositories.

[Jonathan More]

Files are now attached to previous message, thanks for letting me know of this option.

[Richard Buttrey]

Hi,

Have you tried the following

1. Select A1:M12
2. File SaveAs and select the CSV(MS-DOS(*.csv) file type
3. OK
4. Accept the warning message about the file type does not support workbooks that contain multiple sheets and answer OK
5. Accept the warning that the file may contain features not compatible with CSV(MS-DOS) and answer Yes

[Jonathan More]

Hi, sure I have tried that way, but it separates values with semicolon and the shop dont accept that.

[Richard Buttrey]

Hi,

That's presumably because in your Windows Control Panel for Regional Settings you have identified the ; character as the list separator. Temporarily change this to a , and then do the Save As csv operation.

[Xx7]

Hi Jonathan,

This macro should do it for you.

1) Put all CSV file paths in "Column A"
2) Click the button
3) Macro opens each CSV file and put quotes around every cell, then saves with a "_" after file name.

Please Login or Register  to view this content.

[Jonathan More]

Thank you for this great effort, but still something is missing. It didn't place individual values between double quotes, but the whole row. Also the semi colons didnt transfer to comma.

You can find the file I wanted to transfer and the result with this script attached.