What is the easiest ways to COMBINE .csv keyword research files

Tyler Abernethy · 02-21-2011, 09:57 PM

So ive been doing some... ok a LOT of keyword research.. anybody have any good methods of how i can put all of them into one file?

Theres about 50 of them and it would take forever one by one...

Regards,
Tyler A

Tyler Abernethy · 02-21-2011, 10:09 PM

Doesnt anyone know a way to do this??

I would appriciate the tips

ThrillerAuthor · 02-21-2011, 11:26 PM

If you use Windows, copy all the csv files into one folder. Then open notepad and start a new text file and enter the following lines into the text file:

Code:

copy *.csv bigkwlist.one
ren bigkwlist.one bigkwlist.csv

Save this text file from notepad as MakeBigList.bat (this is a batch file). You can name it anything you want, as long as the file extension is ".bat". You have to save this batch file inside the same folder as all the csv files.

Now run the batch file by double-clicking on it. It will combine all the keyword csv files into one big file called "bigkwlist.csv".

However, if each of the smaller csv files have the headers as the first row, these headers are going to be repeated throughout the big csv file, wherever a new file was merged in.

Hope this helps.

Tyler Abernethy · 02-21-2011, 11:58 PM

thanks thriller!

i actually ended up doin all the searching on Google myself.. lol sorry to waste time but i found one in pretty simple terms for everyone

Copy into a notepad (any .txt file will do)
copy *.csv importfile.csv

then
save that .txt file as kwdatabase.bat

the .bat is all that matters

YESSSS that just saved me SOOO much time

Thanks a Million,

Tyler A

ThrillerAuthor · 02-22-2011, 12:05 AM

Quote:

Originally Posted by TA21

thanks thriller!

i actually ended up doin all the searching on Google myself.. lol sorry to waste time but i found one in pretty simple terms for everyone

Copy into a notepad (any .txt file will do)
copy *.csv importfile.csv

then
save that .txt file as kwdatabase.bat

the .bat is all that matters

YESSSS that just saved me SOOO much time

Thanks a Million,

Tyler A

No problem,

I've actually been using these little .bat files for quite a while now as a quick way to merge articles into one big file which then forms the basis of an ebook

Tyler Abernethy · 02-22-2011, 12:19 AM

it amazes me how close minded people can be,
best of luck to you thriller, glad to see that you are on the opposite side of the game with me

I enjoy spending my time finding things like this.
you should check out the end of the thread that i started earlier tonight that NOONE understood, and see what you think

So thats why Google lets us make money?

The last few posts about integrating adwords into an adsense strategy were what i was making everyone revolve around before someone finally realized.

Anyway, hope to see you there,
Tyler A

02-21-2011, 09:57 PM	#1
Tyler Abernethy Banned War Room Member Join Date: Sep 2010 Posts: 333 Thanks: 12 Thanked 25 Times in 19 Posts	What is the easiest ways to COMBINE .csv keyword research files So ive been doing some... ok a LOT of keyword research.. anybody have any good methods of how i can put all of them into one file? Theres about 50 of them and it would take forever one by one... Regards, Tyler A

02-21-2011, 10:09 PM	#2
Tyler Abernethy Banned War Room Member Join Date: Sep 2010 Posts: 333 Thanks: 12 Thanked 25 Times in 19 Posts	Re: What is the easiest ways to COMBINE .csv keyword research files Doesnt anyone know a way to do this?? I would appriciate the tips

02-21-2011, 11:26 PM	#3
ThrillerAuthor HyperActive Warrior War Room Member Join Date: Oct 2009 Posts: 150 Thanks: 32 Thanked 24 Times in 18 Posts	Re: What is the easiest ways to COMBINE .csv keyword research files If you use Windows, copy all the csv files into one folder. Then open notepad and start a new text file and enter the following lines into the text file: Code: copy *.csv bigkwlist.one ren bigkwlist.one bigkwlist.csv Save this text file from notepad as MakeBigList.bat (this is a batch file). You can name it anything you want, as long as the file extension is ".bat". You have to save this batch file inside the same folder as all the csv files. Now run the batch file by double-clicking on it. It will combine all the keyword csv files into one big file called "bigkwlist.csv". However, if each of the smaller csv files have the headers as the first row, these headers are going to be repeated throughout the big csv file, wherever a new file was merged in. Hope this helps.

02-21-2011, 11:58 PM	#4
Tyler Abernethy Banned War Room Member Join Date: Sep 2010 Posts: 333 Thanks: 12 Thanked 25 Times in 19 Posts	Re: What is the easiest ways to COMBINE .csv keyword research files thanks thriller! i actually ended up doin all the searching on Google myself.. lol sorry to waste time but i found one in pretty simple terms for everyone Copy into a notepad (any .txt file will do) copy .csv importfile.csv then* save that .txt file as kwdatabase.bat the .bat is all that matters YESSSS that just saved me SOOO much time Thanks a Million, Tyler A

02-22-2011, 12:19 AM	#6
Tyler Abernethy Banned War Room Member Join Date: Sep 2010 Posts: 333 Thanks: 12 Thanked 25 Times in 19 Posts	Re: What is the easiest ways to COMBINE .csv keyword research files it amazes me how close minded people can be, best of luck to you thriller, glad to see that you are on the opposite side of the game with me I enjoy spending my time finding things like this. you should check out the end of the thread that i started earlier tonight that NOONE understood, and see what you think So thats why Google lets us make money? The last few posts about integrating adwords into an adsense strategy were what i was making everyone revolve around before someone finally realized. Anyway, hope to see you there, Tyler A