Paddy Moogan Blog

Exporting Keyword Ranking Data from SEO Rank Monitor into Excel

8th March 2010 · Paddy · No Comments »

I recently wrote a review of SEO Rank Monitor and if you read it, you will know how much I like the software!  Well I came across a small problem with exporting keyword ranking data into Excel.  It was only a small problem which was easily fixed after I dropped a quick email to support.  But I thought that it would help to show the process here as well in case others have the same problem.

Basically when I export a report I ended up all the data being combined into one cell – not very much use to anyone!

To overcome this problem you just need to import the data in a certain way and reformat it by following these steps.

1. Open a new Excel spreadsheet

2. Go to Data > Import External Data > Import Data

3. Navigate to your CSV file that you’ve just downloaded from SEO Rank Monitor and import it

4. Select Delimited and click next on this screen:

5. Select semicolon from this screen and click next:

6. Click Finish followed by Ok

Thats it, you should now have all the data seperated nicely into columns which is much easier to manage, sort and manipulate.

If you haven’t tried it yet, read my SEO Rank Monitor Review or go over and get a free trial and see what you think.