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:
    554
    Likes Received:
    120
    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:
    3,119
    Likes Received:
    4,104
    Occupation:
    Internet.
    Location:
    Internet.
    Home Page:
    look up concatenate,
     
  3. PrinceVisi

    PrinceVisi Elite Member

    Joined:
    Jan 11, 2012
    Messages:
    1,919
    Likes Received:
    1,015
    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,930
    Likes Received:
    3,437
    Gender:
    Male
    Occupation:
    Dreaming
    Location:
    Pale Blue Dot
    Home Page:
    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:
    3,119
    Likes Received:
    4,104
    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,930
    Likes Received:
    3,437
    Gender:
    Male
    Occupation:
    Dreaming
    Location:
    Pale Blue Dot
    Home Page:
    Hahaha lol :p

    #fifteenchars
     
  7. dikkill

    dikkill Power Member

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

    ija61 Senior Member

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

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,068
    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,325
    Likes Received:
    684
    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:
    753
    Likes Received:
    109
    Yes it will work.
     
  12. ija61

    ija61 Senior Member

    Joined:
    Mar 2, 2011
    Messages:
    969
    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,930
    Likes Received:
    3,437
    Gender:
    Male
    Occupation:
    Dreaming
    Location:
    Pale Blue Dot
    Home Page:
    Yupp that's a cool option too. Shud do it in one click.