Excel For Designer’s | SEO’s

Here’s a short little time saver if you’re working on a old database website or editing links for SEO purposes. What we are trying to achieve here is, Editing/Renaming links and save time through Excel using formula.

In all four methods Column A, Column C & Column E will remain constant.

• Column A : <a href=”
• Column B : Filename
• Column C : .html”>
• Column D : Text-Link
• Column E : </a>

1. Formula Used : EQUAL TO, CONCATENATE



“EQUAL TO” formula copies the exact text from a certain cell. In this case, we have used formula in Cell D2(=B2) and D3(=B3) to copy the text from Cell B2 and B3 respectively. So if you have links which have the same filename’s as links, you can use this. In the end you can join all the columns into a string using “CONCATENATE”. The function would be “=CONCATENATE(A2,B2,C2,D2,E2)”. You can see the final output in Cell A6 & A7.

2. Formula Used : UPPER, CONCATENATE



In this case we have CAPITALIZED the text link only, rest remains the same. So the formula function for D2 will be “=Upper(B2)”  and “=Upper(B3)” for D3.

3. Formula Used : SUBSTITUTE, CONCATENATE



Here, we have used the SUBSTITUTE function to remove the dashes between the filename and have replaced it with spaces.

So the formula function would be, “=SUBSTITUTE(cell,text you wanna replace,text to replace with)” . In this case, D2 function would be =SUBSTITUTE(B2,”-”,” “)

#Seo-Tip : If you keep the title of the file-name and text-link same, you can get a better SEO score for your pages.

4. Formula Used : PROPER, CONCATENATE



PROPER function capitalizes the first letter of every word. The function for D2 will be “=PROPER(B2)”.

Equal TO : “=Cell”


UPPER : “=UPPER(Cell)”


SUBSTITUTE : “=SUBSTITUTE(Cell,Text you wanna replace,Text to replace with)”


PROPER : “=PROPER(Cell)”


CONCATENATE : “=CONCATENATE(Combine Cell)”

You can also make your links bold<b> and italics<i> by simply adding few more columns and combine them using Concatenate.

Tagged as: Excel for Designers, Excel for SEO, Excel Tutorial