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:
    546
    Likes Received:
    119
    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 Jr. VIP Jr. VIP

    Joined:
    May 2, 2010
    Messages:
    2,788
    Likes Received:
    3,769
    Occupation:
    Internet.
    Location:
    Internet.
    Home Page:
    look up concatenate,
     
  3. PrinceVisi

    PrinceVisi Elite Member

    Joined:
    Jan 11, 2012
    Messages:
    1,919
    Likes Received:
    1,013
    Occupation:
    BusinessMan
    Location:
    Tropoja

    Using a Mouse Macro.

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

    Gogol Jr. VIP Jr. VIP

    Joined:
    Sep 10, 2010
    Messages:
    3,478
    Likes Received:
    3,106
    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 Jr. VIP Jr. VIP

    Joined:
    May 2, 2010
    Messages:
    2,788
    Likes Received:
    3,769
    Occupation:
    Internet.
    Location:
    Internet.
    Home Page:
    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 Jr. VIP Jr. VIP

    Joined:
    Sep 10, 2010
    Messages:
    3,478
    Likes Received:
    3,106
    Gender:
    Male
    Hahaha lol :p

    #fifteenchars
     
  7. dikkill

    dikkill Power Member

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

    ija61 Senior Member

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

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,067
    Likes Received:
    648
    Location:
    .IN
    in notepad plusplus , Press ctrl+f and choose extended mode . Replace \n with , .
     
  10. ziplack

    ziplack Supreme Member

    Joined:
    Feb 18, 2010
    Messages:
    1,297
    Likes Received:
    666
    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:
    739
    Likes Received:
    107
    Yes it will work.
     
  12. ija61

    ija61 Senior Member

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

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

    Gogol Jr. VIP Jr. VIP

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