From time to time, you find yourself with a load of data that you need to do something with quickly but are sometimes lacking the idea or tools to manipulate it. Well, now your troubles are over (well hopefully) as you will see some possible solutions for manipulating and using your data below.
Sections in this article
- SEOMOZ offline crawl analyser database
- Open Multiple URLs from Excel
- Strip URLs back down to sub/root domain level
- HTAccess Concatenator
If you find it hard look at the crawl report data extract from SEOMOZ then just download the database below and print out all the report sections in a readable format! You will need Microsoft Access 2002 or above to use the database.
Download: SEOMOZ offline data analyser database
This sheet was created so that you can open multiple URLs from excel in your web browser at the click of a button. A possible use for this is if you want to see how many of the sites still exist, very useful for checking to see if submission directories are still there!
Download: Open URLS from Excel
Striping URLs back down to their sub/root domain form is necessary when you want to compare 2 separate lists of domains that need a relationship between the 2 columns. A good use for this would be to compare your website's backlinks against all the submission directories that have been blacklisted by Google.
A simple way to do this would be to use the sheet to strip the URLs then put the data into Microsoft Access and compare the 2 tables of data for matches. If you need a database for doing this then let me know.
Download: Strip URLs
This spreadsheet will allow you to paste in your current URLs that you want directing to a new URL. With the click of a button, the text that you need to place inside your HTAccess file will be generated.
Download: HTAccess Concatenator
Leave a comment
What's your SEO score?
Use these free sites to
website and show you
room for improvement
Monitor your keyword
positions in Google and
track their rise and fall. Show me
Track keyword competition
and search volumes using
Are your website visitors
having to wait more
than 2 seconds for
your pages to load?
Free web browser plugins that
will make your SEO efforts
a whole lot easier.