How To Make a Tag Cloud

June 24, 2005

Jeffery Zeldman proclaims that tag clouds are the new mullets. However, as I'm sure you're aware some people just can't resist the mullet.

I actually find my tag cloud quite handy because it lists all my tags on one page, and I can see what topics I post about most frequently quite easily. I also use it as a way to see which tags I have already used, so I can be consistent when tagging posts.

Anyways a lot of folks would like to know just how you can get one of these mullets, er tag clouds. I have shown how I do it below using CFML. If you don't use ColdFusion you should still be able to follow along.

At this point you may be wondering what's a tag cloud? If so consult the picture below:

tag cloud

Ok, now let the mullets reign...

Step 1 - Get a list tags, and their frequency

<cfquery datasource="#dsn#" name="tags">
	SELECT COUNT(tag) AS tagCount, tag
	FROM tblblogtags

In my tag cloud I list all my tags, but if you have a lot of tags you may want to limit the min number of occurrences using a HAVING statement. For example HAVING tagCount > 5

Step 2 - Find the Max and Min frequency

<cfset tagValueArray = ListToArray(ValueList(tags.tagCount))>
<cfset max = ArrayMax(tagValueArray)>
<cfset min = ArrayMin(tagValueArray)>

Step 3 - Find the difference between max and min, and the distribution

<cfset diff = max - min>
<cfset distribution = diff / 3>

You can define the distribution to be more granular if you like by dividing by a larger number, and using more font sizes below. You will probably need to play with this to get your tag cloud to look good.

Step 4 - Loop over the tags, and output with size

<cfoutput query="tags">
	<cfif tags.tagCount EQ min>
		<cfset class="smallestTag">
	<cfelseif tags.tagCount EQ max>
		<cfset class="largestTag">
	<cfelseif tags.tagCount GT (min + (distribution*2))>
		<cfset class="largeTag">
	<cfelseif tags.tagCount GT (min + distribution)>
		<cfset class="mediumTag">
		<cfset class="smallTag">
	<a href="/tag/#tags.tag#" class="#class#">#tags.tag#</a>

Step 5 - add css classes to your stylesheet

.smallestTag { font-size: xx-small; }
.smallTag { font-size: small; }
.mediumTag { font-size: medium; }
.largeTag { font-size: large; }
.largestTag { font-size: xx-large; } 

There are probably lots of different ways to build a tag cloud, but this is the first method that came to mind.

Related Entries

61 people found this page useful, what do you think?



awesome post! thanks alot for posting this, along with some code... much appreciated ;) /foO
I made this: "TagLines" it's an auto-folksonomy tool built using the Term Extraction APIS. It combines Ajax with Folksonomies and Yahoo Web Services to allow you to search on RSS feeds, News, Movies, Images or just obtain the original story, all without a page-refresh. Would love to get some feedback on it or suggestions for improvement. regards, -fs
Coolness, now I will just need a mullet to match. I might even let my hair grow in the middle back into a "tail" like we used to in the 80's now that would be cool!!!! I need to implement this on my site :) Minus the mullet!
Cool Site Scott, "Not Even in Beta", I like it!
Hehe, I'm glad you like that. I figured I might as well jump on the whole "BETA" bandwagon. Did you sign up? You should check it out, I have added some nice Ajax and Effects to some of the admin.
Great Post.
Oh man! I wish I'd found this earlier... I'm working on the new version of BlogFusion (v5.0) and am building in tags. I did the font sizing a bit differently, but it's the same basic premise. The task I'm working on now, however is: How would one add the capability to display at least one tag for every letter of the alphabet? Assume for a second that you have 5500 tags in your tag table. That's alot of tags to display - so what I would want to do is find enough tags to fill out a max of 100 tags, for instance, with at least one tag from each letter of the alphabet. (otherwise, you might have the first 100 tags be A-G, rather than A-Z...looks strange to users, and skips cool content in the H-Z range) Anyway, tags are cool, and thanks for the ideas!!
Muchos gracias! I used your ideas here:
Hi Pete. New year greetings. Nice work. Tagging will be used on the Do Me a Favor Buddy site soon too. I'll keep you posted:
Awesome, once again, you are the man
Awesome, I hope I can use this. I have an idea, and it involves tagclouds. :D
Hi! i loved the idea of having my own tag cloud. i tried eurekstr and zoomcloud but this seems like a better idea. I tried cutting an pasting this in my template under the sidebar section and I get no results. I also tried adding <script> and </script> after now the #tag thingies disappear but there is no tag cloud. I know that I doing something wrong. I hope it is simple and I hope you can help.
Great post. The method presented here is very simple and very easy, which results in being extremely useful. Thanks!
Hey! Thanks for this article! I was just talking with a friend about how to create a tag cloud for my blog but I wasn't sure how to go about it. Although I don't use ColdFusion, your article was (as you said!) easy enough to follow. I'm going to get to work on creating my own tag cloud today! (I use WordPress as my blogging engine so I guess I'll be writing my code in PHP as a plugin. Thanks for this helpful article!
alright, no matter how far i search though google, i always end back up here, so would anyone be able to help me change this into php & mysql so i can use it on my small site. Thanks you in advance, and i'll be willing to do a web design or promote your site or what ever, just either post here or email me ar
Thomas: I've written a entry on how I implemented this for my WordPress blog (in PHP).
I had no idea tag clouds were as cool and hip as mullets.
Hi Pete, I used your script and have it running on my CF powered article directory. Thanks!
Could you provide details of your table structure so this method of implimentation can be used on other systems.
Hi all, I only started looking into tag clouds since yesterday and I have to say I am a bit confused. I am an excellent user on html and DreamWeaver but I have never touched Coldfusion. Does anyone now any other articles or tutorials that would help me understand more about tag clouds, where they are used and how! Some of my questions: Are they only or mainly used for blogs? What kind of tags do I use to link the key words with the tag link generator (tag cloud links I supose). Does the above script goes in the head or the body of the page. As you can understand I am completely lost. Thank you all in advance
What's your database table like for that?
Hey, love the idea, but also am having issues trying to figure out how the database table is set up. Any help?
great site with very good look and perfect information?is a very good site? like it
Jeff, I just wanted to say thanks for this, you saved me loads of work and the cloud works beautifully. I adapted it to run with percentages rather than a straight COUNT. Anyway, it seemed only polite to say thank you :-)
I do not sure how this tag cloud work What DB you connect it and what language is that??XML??
Fantastic information. I could build a cloud in django using this.
Very nice, simple yet effective. I translated it to Java 5 for usage in my website
Thanks, I've created a design primer for developers who want to implement tagging in their applications and I've linked to your article for creating a Tag Clouds in Coldfusion.
We made this tag cloud: We have added a little bit "colors" to the final styling (selected a main color and blended it).
I couldn't post HTML so go here to see my version of this (allows as many tag sizes as you like).
we made this tag cloud
Have this:n
Have this:n
Or (if one still have the list of tags) one could use this script to generate a tag-cloud. It is described in german but you could translate it - or you read the sources.. ;-) Many regards, exl
I have bought the paid module. Works without problems. I recommend
I'm a Chinese girl, and Google guides me to your site.Thanks to your idea. It's very cool.
I'm a Chinese girl, and Google guides me to your site.Thanks to your idea. It's very cool.
I recommend It offers a very easy way to make a tag cloud and embed it in a blog or anywhere else.
U r a genius.I was very new to this bt then after reading this,I am feeling very comfortable.
Hi, Do you think that I can implement this tag clouds on my html website? or it's working only on php sites, Thank you
I find that using log functions gives better results.
lreeeeeeeeeeeeeeeeeeeeeeeeeehrgesg jkvfjkldjklbnklbklbvklbvckljjg ;htri;otomjytbypbnm6kgvfjklsrusypsdfmgnlnvcmavher to f artiapoce c8dfaepo eea ee v era ef t rtyovhvuia t auhrlhfvreuifypsa4ehpapepasuprfgljrsaghlrhjsgahlrjghrjkgerhgrjhjrehtu4yt8p4r458499344jr89eeeeeeeee gjksvhgrsghlp;svhgdn;ugjkjl;gjs
If anybody's having trouble, just replace step 4 with something like this -- <cfloop query="tags"> <cfif tagCount EQ min> <cfset class="smallestTag"> <cfelseif tagCount EQ max> <cfset class="largestTag"> <cfelseif tagCount GT (min + (distribution*2))> <cfset class="largeTag"> <cfelseif tagCount GT (min + distribution)> <cfset class="mediumTag"> <cfelse> <cfset class="smallTag"> </cfif> <cfoutput>[wrapper]#tag#[/wrapper]</cfoutput> </cfloop> With this mod, I had a working tag cloud in about 15 minutes. Thanks a lot!
Here is a nice tag cloud script with mysql database, easy to configure : Enjoy.
Great code! I used it on my essay about tag clouds. You can find it here:
I think Tag Clouds can be a good way to get visuals (that arent really visuals!) into your site / blog without using a bog standard image. They can break up a page of text with something that looks creative. However, Im sure there are advantages to having a keeping your neck warm!
interesting, but a few things. 1: as someone said elsewhere, all tutorials seems to assume you know how to populate your database, and 2: all the techniques i've seen assume one has a fresh site to which one can start adding tags for articles/pages with each added article/page from scratch. But what can be done for sites which already have tens of thousands of pages of content in database and where it is impossible to add tags for each of these articles because it would take forever? Secondly i dont understand how the tags sizes in your tag-cloud relate to anything at all (such as number of pages using the word)? because each tag simply links to one page, and I can't see any relationship between tag size and anything which loads when one clicks a tag (?) Also this assumes one's site loads pages based on a single word at the end of the address-string, so how would one do this for sites where content page links require full link addresses rather than the tag-word itself? Simply put, i couldnt find a single decent documented page on this subject for beginners anywhere on the www in 6 hours of searching, which is quite incredible given tag-cloud popularity. All articles assume the user knows a hell of a lot already. But this is a general shortcoming of most computer peoples' tutorials online - they are good at coding but hopeless at understanding the principals of teaching a subject. There is simply no real explanations at all given with this tutorial although i realise this may not have been made for beginners.
In your opinion, what's the best movie ever created?
Hi , anyoane can put here the cod of the SQL database -table of this script tag cloud ? THX
Very cool script, I was able to get it up and running almost immediately. One question though, how do you recommend dealing with multiple tags for an entry? I initially set up a test DB Table that had a "tag" field with multiple tags separated by a comma, obviously this code wasn't able to break up the list into various keywords, and simply grouped them all into one big tag. Looking through it I don't really see how it could be modified to deal with a list. Is having a separate tags table that is then linked back to the master record the answer? That seems like the only plausible way, as having only one tag per record seems very limiting.
Late in the game, but... And, for those asking about the db table, it should look something like.. (Here's to hoping it lines up..) +---------+-------------+ | Field | Type | +---------+-------------+ | id | numeric | | tag | varchar | +---------+-------------+

The today blog structure have more than one tag.

So your new blog table might look like this.
"BlogId", "Title", "Description", "Content", "Date", "AuthorId" and "Tag"

You can try cold like
1. Pull all the Tags from the table,
2. Create a new query with "Tag" and "TagCount" and populate it with step 1.
3. You can know continue from step 1 of the this original post.

Looks like a loot of code, you might catch your result for better performance.
how can i create tag cloud in webpart could plz tell me step by step
Great article, thanks for sharing your tag cloud technology. I have found a completely free (including commercial websites) tag cloud script written in PHP on I like it because it has a built-in text-to-tags parser and it filters out common words - if you inspect the code they provide you will see maybe a
thousand common words. For fact, I have actually added more words to it. The styling options are pretty decent.
i just update some tag cloud for my site
Here's a question for you: can you store more than one tag in the sql table for each picture? Or do you need separate columns (i.e. Tag1, tag2, tag3)?
I just sent this post to a bunch of my friends as I agree with most of what you’re saying here and the way you’ve presented it is awesome.
I just sent this post to a bunch of my friends as I agree with most of what you’re saying here and the way you’ve presented it is awesome.
Great Post. I add this Blog to my bookmarks.
Man does not live by bread alone
Great Post. I add this Blog to my bookmarks.
Awesome Blog. I add this Blog to my bookmarks.
i am happy to find it thanks for sharing it here. Nice work.
Good journey and experience!
Nice post...Thank you for sharing some good things!!
Awesome Blog. I add this Post to my bookmarks.
Very Interesting Post! Thank You For Thi Blog!
I just sent this post to a bunch of my friends as I agree with most of what you’re saying here and the way you’ve presented it is awesome.
Thank You For This Post, was added to my bookmarks.
Thanks very good for report, I follow your blog
I just sent this post to a bunch of my friends as I agree with most of what you’re saying here and the way you’ve presented it is awesome.
Very Interesting Blog! Thank You For Thi Information!
good quality with mbt shoes like
top quality of tory burch shoes like this website
if U are interestring with good quality of handbags,clike this link
I like coming to your website for the blog post are all superb.Keep update and I will come here at any moment.
This is my first blogg post I'm just testing my shiny new blogg
wow.. i'm very

enjoy reading your post. great.
Well, you mention here things that really made me think.

I want to add a tag cloud to my website but i don't know if it can be added to a simple HTML website..? Also, i am not a technical person... could just do very small things in HTML. so would this code work for me as well or is there a better option for me.

Many thanks in advance for your response.
Good point, though sometimes it's hard to arrive to definite conclusions
how are you?

Awesome post, just want to say thanks for the share
Keep working ,great job!
Keep working ,great job!
where should i place the generated Tags in my site
where is better place to put the tag clouds
In searching for sites related to web hosting and specifically comparison hosting linux plan web, your site came up.
I wish getting over a broken heart can be so easy as following a few steps.. but its not…
Keep focusing on your blog. I love how we can all express our feelings. This is an extremely nice blog here
Someone suggest me how to create tag clouds in social bookmarking sties

Thanks in advance
There is obviously a lot to know about this. I think you made some good points in Features also.
Keep focusing on your blog. I love how we can all express our feelings. This is an extremely nice blog here
I don’t usually reply to posts but I will in this case.
msoo owyxh http:/ mphfxd f bq l aww
Professionable blog, go on!
The article is usefully ,excellent!
Hey very nice blog!!
Great post. The ColdFusion Tag Cloud method presented here is very simple, which results in being extremely useful. Used here
So thats what a tag cloud is, thanks!
Can I clone your article to my blog? Thank you…
@Priest No you may not clone my article. Why not just link to it from your blog?
Yes there should realize the opportunity to RSS commentary, quite simply, CMS is another on the blog.
It's to complicated for me but I found an interesting tag cloud here

Recent Entries