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

How To Turn A 15,000 keyword list into 15 keyword lists of 1000 for Google Keyword Tool?

Discussion in 'Black Hat SEO' started by SpiderBlast, Feb 17, 2014.

  1. SpiderBlast

    SpiderBlast BANNED BANNED

    Joined:
    Jan 6, 2012
    Messages:
    830
    Likes Received:
    1,283
    I need to transform a list of 15,000 keywords, in .txt format, into 15 separate .txt lists, each with 1000 keywords from the original list.

    This way I can run the keywords through Googles Keyword Planner 1,000 at a time. Then save the searches of 15,000 keywords in 1 folder.

    Any help on this would be greatly appreciated.

    Thank you!

    -SB
     
  2. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,029
    Likes Received:
    638
    Location:
    http://twitter.com/divok
    if you know python here is my code , to do the same thing . Else get a txt splitter www.gdgsoft.com/gsplit
    Code:
    from random import shuffle
    fp = open(r"D:\work\py\tester\combined-bc-feb2.txt","r") #Your big file
    
    
    fplines = fp.read().split("\n")
    lenfp=len(fplines)
    i =0
    newfiles=5 #Number of smaller files you want .
    while i <lenfp/newfiles:
    
    
        filelisti=[]
        mfilename = str(i)+".txt"
        
        for j in range(0,lenfp-1):
        
            if i + j*newfiles < lenfp:
                filelisti.append(fplines[i+(j*newfiles)])
            else:
                break
        sizefilelist=len(filelisti)
        shuffle(filelisti)
        mfile=open(mfilename,"w+")
        mfile.write("{")
        for j in filelisti:
            mfile.write("%s\n" %j)
            
            #remove hash if you want spintx , and add hash to above lines
            #if j < sizefilelist -2:
            #    mfile.write("%s|" % j)
            #else:
            #    mfile.write("%s"% j)
        #mfile.write("}")
        mfile.close()
        i=i+1
     
  3. THUNDERELVI

    THUNDERELVI Elite Member

    Joined:
    Sep 12, 2009
    Messages:
    2,225
    Likes Received:
    1,821
    Gender:
    Male
    Location:
    W3
    Just take Gsplit mate, it will do that in less than a sec!