SEO Tycoon

**compassout01** · 09:59 AM

As I start to learn about SEO and actually do some just for fun, I found more and more that Excel skills are very important to successful SEOs. Since SEO deals with large amount of data and sites, good excel skills can help you a lot out there. I can show with an example on how I deal with data on Excel:

You have a list of social bookmarking sites that you've sent links to, but then, you found some more social bookmarking sites. You don't want to send duplicate content to the same bookmarking sites, so you need to decide if these new sites already exist in the old list or not. It sounds like a simple task, but when you try to "delete duplicate", that's when troubles come. Some URLs have http, some don't. Some sites have www, while others don't. Excel can help you with just some simple operators:

For example, if a site URL is: http://www.smithmonitoring.com/

You want to get the top level domain, without http or www. First you can count the number of characters for "http://www.". It's 11, so next, you use below equation in Excel (Say that above URL is in A1)

=right(A1,len(A1)-11)

len(A1) gives the total number of characters in A1. So what above equation means is you want to get characters from right side of A1, the number of characters you want is total number of A1 characters minus 11 characters (which is http://www.).

After this equation, you'll get smithmonitoring.com/. Interesting right?

There are more functions you can try to use such as left, search, etc.

**bloggerhaq** · 01-04-2011, 03:57 AM

IS this skill help SEO, if it is then HOW?

**infomesh** · 01-04-2011, 04:07 AM

Yes you are calculation is correct. but how it is useful in SEO ? can u explain it clearly.

**Click SSL** · 01-04-2011, 04:08 AM

Yes,you are right dear. Excel is most require skill in seo. Thanks for sharing this, I don't know it. But thanks to you I can able to solve some Mystery.

**seo.vijay** · 01-04-2011, 04:46 AM

If you want to know more on excel in seo then read this page:- http://www.searchenginejournal.com/u...of-tips/23077/

It will surely help you.

**Viresh** · 01-05-2011, 07:04 AM

I definitely try this out and let you know my feedback. Thank you for sharing your wonderful information.

**chrishirst** · 01-05-2011, 10:11 AM

Well, not exactly a "great tip" as if the cell content does NOT start with http or contain "www" you would simply remove the first 11 characters.

A far better method would be to use a nested replace function.

Code:

ActiveCell = replace(replace(ActiveCell, "http://", ""), "www.", "")

That would replace the instances of "www." and "http://" in the selected cell with empty strings

take note that the VBA replace function is case sensitive (binary comparison)

a case insensitive function would need to use Text Comparison mode

Code:

ActiveCell = replace(replace(ActiveCell, "http://", "", , , vbTextCompare), "www.", "", , , vbTextCompare)

**humza** · 01-05-2011, 10:47 AM

This is nice trick for those keep record of their resources in Excel, indirectly it would be useful for SEO because your resources are the best tool for you to keep your site up.

**compassout01** · 01-06-2011, 01:38 AM

Quote:

Originally Posted by bloggerhaq

IS this skill help SEO, if it is then HOW?

Dude, SEO involves a lot of data. Are you going to analyse them all manually? You'll have to use Excel unless if you use some softwares... But I feel it's more convenient when you know exactly what you are doing with your data, instead of having a package from a software, not knowing how they process the data.

**CameronHamilton** · 01-06-2011, 01:41 AM

I googled everything this person wrote and a variety of different websites appeared.

This content is syndicated. BAN.

**compassout01** · 01-06-2011, 01:44 AM

Quote:

Originally Posted by chrishirst

Well, not exactly a "great tip" as if the cell content does NOT start with http or contain "www" you would simply remove the first 11 characters.

A far better method would be to use a nested replace function.

Code:

ActiveCell = replace(replace(ActiveCell, &quot;http://&quot;, &quot;&quot;), &quot;www.&quot;, &quot;&quot;)

That would replace the instances of "www." and "http://" in the selected cell with empty strings

take note that the VBA replace function is case sensitive (binary comparison)

a case insensitive function would need to use Text Comparison mode

Code:

ActiveCell = replace(replace(ActiveCell, &quot;http://&quot;, &quot;&quot;, , , vbTextCompare), &quot;www.&quot;, &quot;&quot;, , , vbTextCompare)

Thanks for sharing. Glad that I also learned something from sharing :-)
I still have a question though. After using the "replace", http or www will be replaced by spaces. Will Excel still recognize duplicated items when it comes to "delete duplicate"? For example, if one cell content is tycoontalk.com, the other cell has the same thing but with a space at the beginning. When I do "delete duplicate", will one of the cells be deleted? Thanks.

**chrishirst** · 01-11-2011, 08:57 AM

Quote:

After using the "replace", http or www will be replaced by spaces

They are not replaced with spaces, they are replaced with an empty string.

You can use the trim(string) function to remove leading and trailing spaces from the text or cell value you are testing.

**francis84** · 01-11-2011, 07:39 PM

VERY ELEMENTARY SKILL.... Quite useful for MS Office Apps noobs. LOL!

**Anirban_Das** · 01-12-2011, 01:29 AM

well cited

**johnasthlon** · 08-10-2011, 06:54 AM

This is nice Excel Formulas. There are many way to do this but this one also nice.

In SEO you have to aware about the Excel shortcuts and Formulas and Some basic Knowledge of Excel Functions.

**logoonlinepros** · 08-12-2011, 05:22 AM

Yeah, That's a good resource for all SEO expert to learn some unique techniques of using excel for maintain sheet and reporting.

**brianman** · 08-15-2011, 11:48 PM

Wow, there are a lot of haters on this forum. I think original thread is a good attempt to avoid duplicate content from being put out there. However, I use a far more antiquated and yet successful method. If I use content, I use it once. I trash it. I never go back to it. Yes, it takes longer...but hey...no duplicate content, right?

**amultani** · 09-24-2011, 07:02 AM

not sure how can we do seo using excel ..

**chrishirst** · 09-24-2011, 07:06 AM

Quote:

Originally Posted by amultani

not sure how can we do seo using excel ..

I think that point was covered some EIGHT months ago