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

Columns to comma separated list?

Discussion in 'Black Hat SEO Tools' started by dikkill, Jan 22, 2014.

  1. dikkill

    dikkill Power Member

    Joined:
    Jul 27, 2011
    Messages:
    534
    Likes Received:
    118
    Location:
    Other World
    Hi,

    Anyone know how can i modify a column of keywords to comma separated keyword list?Manually will take ages :).
     
  2. Panther28

    Panther28 Elite Member

    Joined:
    May 2, 2010
    Messages:
    2,268
    Likes Received:
    3,405
    Occupation:
    Internet.
    Location:
    Internet.
    look up concatenate,
     
  3. PrinceVisi

    PrinceVisi Elite Member

    Joined:
    Jan 11, 2012
    Messages:
    1,916
    Likes Received:
    1,009
    Occupation:
    BusinessMan
    Location:
    Tropoja

    Using a Mouse Macro.

    Do the first one by yourself and leave the rest to the mouse.
     
  4. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,066
    Likes Received:
    2,872
    Gender:
    Male
    You can do that in excel. Do as mentioned here:
    Code:
    http://superuser.com/questions/240858/convert-a-column-into-a-comma-separated-list
     
  5. Panther28

    Panther28 Elite Member

    Joined:
    May 2, 2010
    Messages:
    2,268
    Likes Received:
    3,405
    Occupation:
    Internet.
    Location:
    Internet.
    dude, if neg rep was possible i would power slam u through the floor! lol, thats a terrible idea :)
     
    • Thanks Thanks x 1
  6. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,066
    Likes Received:
    2,872
    Gender:
    Male
    Hahaha lol :p

    #fifteenchars
     
  7. dikkill

    dikkill Power Member

    Joined:
    Jul 27, 2011
    Messages:
    534
    Likes Received:
    118
    Location:
    Other World
    You guys are the bomb :D
    Nice method, you tried lol.
     
  8. ija61

    ija61 Senior Member

    Joined:
    Mar 2, 2011
    Messages:
    960
    Likes Received:
    634
    Gender:
    Male
    Occupation:
    The first SEO economist:)
    Location:
    Romania
    Home Page:
    Really..?!!!!!!!
     
  9. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,015
    Likes Received:
    634
    Location:
    http://twitter.com/divok
    in notepad plusplus , Press ctrl+f and choose extended mode . Replace \n with , .
     
  10. ziplack

    ziplack Senior Member

    Joined:
    Feb 18, 2010
    Messages:
    1,193
    Likes Received:
    603
    Location:
    BHW
    i use this lil soft

    Code:
    http://download.cnet.com/CSVed/3000-2351_4-52868.html
    You add your csv file (comma separated) and the software export it to excel format (tab)

    regarts
     
  11. seosky

    seosky Power Member

    Joined:
    Feb 4, 2013
    Messages:
    731
    Likes Received:
    106
    Yes it will work.
     
  12. ija61

    ija61 Senior Member

    Joined:
    Mar 2, 2011
    Messages:
    960
    Likes Received:
    634
    Gender:
    Male
    Occupation:
    The first SEO economist:)
    Location:
    Romania
    Home Page:
    I will say it again.. Really?

    Did you ever try open the excel and then go to "import from text"?
     
  13. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,066
    Likes Received:
    2,872
    Gender:
    Male
    Yupp that's a cool option too. Shud do it in one click.