how to take a text file and turn it into a csv file

goldstenag1

Registered Member
Joined
Jan 1, 2014
Messages
81
Reaction score
1
can anybody tell me how to do this, thanks...
i need csv file to upload to a program. thanks
 
there are two steps involved: first make sure the format of the text file (content) is suitable for the csv-format. (you need to know the csv format from your upload program) - usually content is separated by ; or ,

second: change the file extension to .csv
 
I was above to present an answer, though DaQuark has answered perfectly. A thanks going you way :)
 
CSV stands for Comma Separated Value. Assuming it's standard, you'd take your text file and remove all the line breaks and replace them with ", ". That's a comma sign, then a space after it. Then as stated above, click save as, then in the drop down box that says Text Document, change that so that it says All Files, then save it as Filename.csv and you should be all set. If you look in the folder you saved it in instead of saying Text Document as the Type, it will say CSV File.
 
Watch this: Converting .txt file to .csv file.


 
Last edited by a moderator:
Since CSV means comma separated values, the format is value1, value2, value3, and so on.

Although it says comma, the character that seperates the values can be one of many characters.

This may take the form of any data:

size, style, color, length.

12,retro,blue,35inches

or

size; style: color; length

12;retro;blue;35inches

write it in a text file, save it, and change the name to "whatever.csv"

The real trick is the importing mechanism that you use.
 
Back
Top