Tag Archives: word cloud

How to create a word cloud with word counts, Excel, and Wordle

When you’ve got the right purpose in mind, word clouds can be very useful. But when you only have a list of words and their counts, particularly when the word counts are large,  how do you turn a short list of words into word cloud?

Well, let’s take an easy example and work with this list of words. Because this is an easy list, we could just re-write it into this: Cake, cake, cake, cake, cake, brownies, brownies, brownies, cookies, cookies, pie, pie, pie, tarts, tarts, tarts, tarts, tarts, tarts, tarts, tarts, tarts, squares, squares, squares, squares. That took me about 1 minute to write out.

Cake 5
Brownies 3
Cookies 2
Pie 3
Tarts 9
Squares 4

But what happens when your list looks like this? Are you really supposed to write out each word thousands of times just so they can be copied into Wordle? And what happens if there are several hundred words in your list and they all have hundreds or thousands of mentions? It could take an hour to do to accurately and, as you’ll soon find out, is a complete waste of time.

Cake 4522
Brownies 3492
Cookies 2431
Pie 3142
Tarts 878
Squares 3627

Have no fear! A quick little Excel trick is in order. Have a peek at the picture here and notice the equation. This handy little equation tells Excel to choose the word in column A and then repeat it by the number in column B. The concatenate portion inserts a space between each word which is important for Wordle to distinguish between each word.

excelwords

Now all you need to do is copy the contents of column D into Wordle.

wordletext

And then click on Go! Now you can try it with a really long list of words and it will just take a couple minutes. Enjoy!

wordle

Tagxedo for colorful shapeable saveable word clouds

[tweetmeme source=”lovestats” only_single=false]The internet has been wanting this for a while and it’s finally here! Try Tagxedo for yourself! It’s text analysis for the graphically inclined.

The first one is my resume and the second is this blog.

Read these too

  • MRA Boston Day 1 – Tweeple save the day! Turning down business is good for business
  • 5 random things about me
  • A Do Not Call list for the internet. Primed for failure? #MRX
  • U wanit cheep or would you like it done correctly?
  • Shy Friendly Shopping
  • Word Cloud of my Resume – Wicked Cool!

    Have a look at this! It’s a cloud version of my resume. I just copied the text into wordle and it spit this out. I don’t know why I was surprised to see that it really represented who I am in the work world.

    Try out your own word cloud at http://www.wordle.net

    AnniePettitConsulting

    Related Articles

    %d bloggers like this: