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

by Tyler Abernethy

Posted: 13 years ago 5 replies

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

#combine #csv #easiest #files #keyword #research #ways

Tyler Abernethy

13 years ago

Doesnt anyone know a way to do this??

I would appriciate the tips

Thanks
1 reply

Signature

[1.25 MILLION keywords] YOU CAN CHOOSE NICHE - adwords+prefixes+suffixes - DONE FOR YOU! [+reviews]
--------------------------------------------------------------------------
Relax While Quality* Backlinks [**Drip Feed**] to Your Website - .edu/.gov included

{{ DiscussionBoard.errors[3408013].message }}

ThrillerAuthor

13 years ago

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.

[ 1 ] Thanks
1 reply

Signature

Click here for Unique Pre-made Kindle and E-Book Covers

{{ DiscussionBoard.errors[3408381].message }}

Tyler Abernethy

13 years ago

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

[ 1 ] Thanks
1 reply

Signature

[1.25 MILLION keywords] YOU CAN CHOOSE NICHE - adwords+prefixes+suffixes - DONE FOR YOU! [+reviews]
--------------------------------------------------------------------------
Relax While Quality* Backlinks [**Drip Feed**] to Your Website - .edu/.gov included

{{ DiscussionBoard.errors[3408537].message }}

ThrillerAuthor

13 years ago

Originally Posted by TA21

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

[ 1 ] Thanks

Signature

Click here for Unique Pre-made Kindle and E-Book Covers

{{ DiscussionBoard.errors[3408572].message }}

Tyler Abernethy 13 years ago

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

http://www.warriorforum.com/main-int...ml#post3408601

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
- Thanks
Signature

[1.25 MILLION keywords] YOU CAN CHOOSE NICHE - adwords+prefixes+suffixes - DONE FOR YOU! [+reviews]
--------------------------------------------------------------------------
Relax While Quality* Backlinks [**Drip Feed**] to Your Website - .edu/.gov included
{{ DiscussionBoard.errors[3408622].message }}

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

Trending Topics

Newbie

How did you turn it all around?

A healthy fascination for Hollywood...

best high quality crypto traffic.

Any thoughts on golf's latest phenom...Scottie Scheffler??