How to Create a Word Cloud

Step 1: Go to http://www.wordle.net.

Step 2: Click "Create" 

Step 3: 

In Survey Monkey, download your responses by clicking on the "Analyze Results" tab

Click "Download Responses" on the left hand side of the page.

Option 1: Choose "Summary Report" and make sure to choose the option to "Include open-ended responses" 

Option 2: Choose "Excel Format" 

Click "Request Download"

Step 4: 

You will be brought to the download page, click "Download" next to the report that has the name of your Survey Monkey. The downloaded responses will be available in your "Downloads Folder" 

Step 5: 

Open a new spreadsheet or word document and copy and paste all of the responses from your downloaded document into one column. Your document should look something like this. Make sure to fix all spelling and grammar errors. 

Step 6: 

Copy and paste all of "Column A" into the "Paste in a bunch of text" box on the Wordle website and click "Go"

Step 7: 

You will get something that looks like this. 

Step 8:

You may notice that there are words that should be the same such as "People" and "people" or "culture" and "cultures"

You will need to go back to your spreadsheet and do a word find and replace by pressing "command + F" 

Click "Replace" and type in the word you need to change "People" in the "Find What" box and "people" in the "Replace With" box and click "Replace All" 

You will have to do this for every word that doesn't show up the way you want it to. 

Spelling, grammar, punctuation, capitalization are all very important and will make a difference if incorrect. 

When finished replacing all of the necessary words, copy and paste again in the Wordle box. 

Step 9: Making it Pretty! 

Click the "Font" "Layout" and "Color" options at the top of your word cloud and choose the color scheme, design and layout that looks the most appealing to the eye. You may have to click "Re-Layout with Current Settings" in the "Layout" box a few times to ensure that it is easy to read and visually appealing. 

The below options are what have worked best and have been well received by our clients.

STEP 10: FINISHED PRODUCT! CLIENTS LOVE THIS STUFF! 

By pressing "Command + Shift + 4" you can take a screen shot of your finished word cloud to insert into your presentation. The screenshot will be on your desktop as "Screen Shot"

Here are 2 word clouds that we have created and presented to clients that have been well received. 

Voila! 

Have Fun Wordle-ing!!!!!!