1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Black Hat SEO Tools' started by goldstenag1, May 13, 2014.

  1. goldstenag1

    goldstenag1 Registered Member

    Joined:
    Jan 1, 2014
    Messages:
    80
    Likes Received:
    0
    can anybody tell me how to do this, thanks...
    i need csv file to upload to a program. thanks
     
  2. usablognetwork

    usablognetwork Junior Member

    Joined:
    Mar 27, 2014
    Messages:
    107
    Likes Received:
    12
    Location:
    washington
    should just be able to go go file then save as and change the format to csv
     
  3. DaQuark

    DaQuark Junior Member

    Joined:
    Jun 4, 2011
    Messages:
    130
    Likes Received:
    43
    Location:
    home sweet home
    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
     
    • Thanks Thanks x 1
  4. tg01

    tg01 Regular Member

    Joined:
    Aug 23, 2007
    Messages:
    357
    Likes Received:
    103
    I was above to present an answer, though DaQuark has answered perfectly. A thanks going you way :)
     
  5. Tanckom

    Tanckom Power Member

    Joined:
    May 4, 2014
    Messages:
    570
    Likes Received:
    172
    Location:
    ☯ Karma ☯
    Home Page:
    rename the file from name.txt to name.csv
     
  6. akacash

    akacash Jr. VIP Jr. VIP

    Joined:
    Jan 16, 2010
    Messages:
    806
    Likes Received:
    575
    Location:
    The Beach, USA
    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.
     
  7. K.H.R

    K.H.R Jr. VIP Jr. VIP Premium Member

    Joined:
    Dec 9, 2013
    Messages:
    2,931
    Likes Received:
    953
    Gender:
    Male
    Occupation:
    Study + Outsourcing
    Location:
    BHW
    Watch this: Converting .txt file to .csv file.


     
    • Thanks Thanks x 1
    Last edited by a moderator: May 18, 2016
  8. Techxan

    Techxan Elite Member

    Joined:
    Dec 7, 2011
    Messages:
    3,093
    Likes Received:
    3,585
    Occupation:
    Local SEOist
    Location:
    TEXAS (you have to yell, its the law.)
    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.
     
  9. IMCapitalist

    IMCapitalist Senior Member

    Joined:
    Jan 21, 2014
    Messages:
    1,090
    Likes Received:
    60
    Location:
    Google Universe
    COpy the text in to Ms word and Save as .csv