How do I create a .csv file?

[Muse]

I have a string with comma separated values:

AEM,AMED,FWLT,GEN,GMXR,HL,IBN,LCC,LLY,RIMM,STP,T,TLAB,UAL,UNG,UNH,WFR,WLP,XLV

I saved a text file, calling it values.csv and the program I'm using that's supposed to be able to import the values from a .csv file is unable to import the list. I used Metapad.exe to create the .csv file, having simply pasted the string above into the file and saved it, calling it values.csv. Do I have to use Excel or something? What's the trick?

 

[thebomb]

I have a string with comma separated values:

AEM,AMED,FWLT,GEN,GMXR,HL,IBN,LCC,LLY,RIMM,STP,T,TLAB,UAL,UNG,UNH,WFR,WLP,XLV

I saved a text file, calling it values.csv and the program I'm using that's supposed to be able to import the values from a .csv file is unable to import the list. I used Metapad.exe to create the .csv file, having simply pasted the string above into the file and saved it, calling it values.csv. Do I have to use Excel or something? What's the trick?

I've never used metapad but I assume it's similar to notepad. When you save the file it is not enough to give it the .csv extension in the name: You need to make sure you save it as 'All Files' under 'Save As Type' and not the default that Metapad is saving it as.

 

[IronWing]

Some implementations of .csv files require non-numerical values to be wrapped in quotation marks.

8,7,"steve",45
7,34,"bill",43
4,54,"mike",56
6,99,"fred",77

 

[Muse]

I've never used metapad but I assume it's similar to notepad. When you save the file it is not enough to give it the .csv extension in the name: You need to make sure you save it as 'All Files' under 'Save As Type' and not the default that Metapad is saving it as.

Thanks, actually it was saved as "All Files." The import must have worked one time I tried it but not some other times. 😕 I changed the file name to lower case, it had been upper case. In Windows (7) it shouldn't matter the case, so I don't think that had anything to do with it. However, the import did work. The program is kind of kludgy, it didn't ask me what folder name I wanted to use, didn't give any confirmation. The only feedback I got was a denial a time or two. But I do see the folders now. I can change the name the program gave to the folder.