EXTRA: A fun use of Wordle

Do you ever have those middle-of-the-night brainstorms? I’ve been playing around with Wordle for a client so it was in my mind when I got to thinking of other possibilities. I wondered if it would be possible to create a Wordle out of the artists in my iTunes playlist. I have figured out a method that I’d like to share with you for use in your class or just for a spring break project.

How to Create a Wordle of your Playlist:

  1. Open iTunes and click on one song. (You could create a particular playlist if you want to here, but my mission was to sample everything that I listen to)
  2. Choose “Select All…” from the Edit menu. (CTRL+A on pc; ⌘-A on mac)
  3. Copy all of that content (CTRL+C on pc; ⌘-C on mac)
  4. Open Excel (or use http://www.editgrid.com if you don’t have Office)
  5. Paste in the data from your clipboard (CTRL+V on pc; ⌘-V on mac)
  6. Highlight and right-click/Delete every column except for the ARTISTS so that it is the last remaining column
  7. Choose “Select All…” from the Edit menu. (CTRL+A on pc; ⌘-A on mac)
  8. Copy all of that content (CTRL+C on pc; ⌘-C on mac) to put all of the artists in the clipboard.
  9. Visit http://www.wordle.net and click the CREATE button at the top.
  10. Paste in the data from your clipboard (CTRL+V on pc; ⌘-V on mac) in the box entitled, ‘Paste in a bunch of text’ and press ‘Go’.

Once the artists are in Wordle, play around with the settings until you’re happy with the results! You can print, turn it into a PDF, take a screenshot or save it to the public gallery.

Click for the full sized image…”

Shelley Davis Forman suggests using Tagxedo.com as well!


Click for the full sized image…”

One thought on “EXTRA: A fun use of Wordle

  1. Shelley

    You can upload an image to make the cloud shape specific depending on the theme of the words.
    Maybe a guitar for Pete’s word cloud?
    I’ve been very pleased with how detailed I’ve been able to get the words to form to any pictures I’ve used.
    I’ve even used photographs of student’s faces.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *