I'm trying to get a .csv file with this exact format http://puu.sh/ubMVZ/6d7b9968d5.png to be used in a statistical analysis in metaboanalyst (this is a list of concentrations of metabolites from different patients)
When I save my .xls with my own data in it as a .csv file in excel it gives me this http://puu.sh/ubN3m/24981307b8.png as you can see the delimiters and separators are different, I want commas and quotes but the file I have doesn't give me that. Does anyone know how I can mimic the first example? (which is an example dataset taken from metaboanalyst website) I'm a novice in manipulating things like this with software.
Thanks