Search Engine Optimization

AOL Leaked keyword List 20 million search queries

Over ~650 online users, 3 months data. Data is sorted by user number, showing 3 months search history. Get your copy here.

Organize AOL Leaked Keywords

Leaked keywords are from AOL search database(Google powered search), sorted in columns. Each file is over 200 MB in size and takes 4 FULL excel spreadsheets(total 40 spreadsheets, 4 per file)

You can export AOL leaked keywords into your own database or use excel as I did. The recommendation is to use a searchable database, but if you’re limited, excel does a good job too. If you have 2007 excel, open it up and go to the “Data” tab. (in 2003 go to Import in the file menu)

Import to Excel

• Tutorial on how to import data into excel 2003

On the left top side find this icon (2007)

Click on it and leave everything as is. Start importing. Excel will choke for a bit since each AOL .txt is over 200MB so give it some time.

It notify you it cannot fit all data into one spreadsheet. Click OK and let it import whatever can fit.

Once finished you should have one full spreadsheet of leaked AOL keywords.

The Tricky Part

One .TXT file takes 4 spreadsheets. Once you imported first part you got 3 more to go. This is where Excel goes nuts. If you try to specify a row where it stopped last time, it won’t do anything.

I’ve tried everything and it refuses to work.

The Solution to Import Leaked AOL Keywords to Excel

To solve this problem you will have to open each AOL keyword .TXT file, find the row where you stopped, delete imported data and save the file.

Here’s how to do it.

Go all the way to the bottom of your AOL spreadsheet. At the very bottom, find a key phrase that can be easily searched, for example : “5 year credit card percentage rate information”.

The point is to find a long tail keyword phrase that is easy to search for with CTLR+F command.

Open AOL keyword .TXT file. This is going to take from 2 to 20 minutes, depending on your RAM, so be patient. Avoid heavy duty tasks. Once opened, press CTRL+F and search for the key phrase copied from the bottom of your spreadsheet.

Once you locate the key phrase, select everything behind it. To do this quick use shortcuts. Highlight the keyword(one you searched for) and press SHIFT + CTRL at the same time.

Do not let SHIFT and CTRL go and scroll all the way up using the scroll bar. Once at the top click at the start of the document and all the data will be selected.

Now press BACKSPACE to delete all selection. Give it 2 to 20 minutes. Once deleted, save the keyword document. Give it 2 to 20 minutes.

You’re ready to import AOL leaked keywords into excel again. Go to a new spreadsheet click on this button again to export from .TXT file.

Once finished repeat the process. There are total 10 .TXT files. Each file will give you 4 spreadsheets in a single Excel file.

Once imported you can start organizing AOL leaked keyword data. The first step is to create a “list” in 2003 version or use “filter” function in 2007 version

• Using Leaked AOL Keywords