Word Cloud From Google Chats



Introduction: Word Cloud From Google Chats

I created a word cloud from all of my google chats between my wife and I over 1 year. I used wordle .net to generate the cloud, getting the chats to a single text file was the tricky part. If you have any other tips or tricks to make this easier please let me know...

...after going through this again, you might be able to skip steps 7 & 8 if you create a label in gmail that is all chats from a single person. then you can use the thunderbird export tool to put the entire folder into one text file:  "Tools"-> "ImportExportTools" -> "Export all messages in the folder" -> "Plain Text Format (one file)".  I haven't tested this, but it might work.

Teacher Notes

Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.

Step 1: Enable IMAP in GMail

In Gmail settings, under "Forwarding and POP/IMAP", select "Enable IMAP"

Step 2: Set Chats to Be Shown in IMAP

In gmail settings, find "Chats" and select "Show in IMAP"

Step 3: Install Thunderbird

Install Thunderbird, set it up to you gmail account, make sure it is configured as IMAP and not POP

Step 4: Subscribe to "chats" in Thunderbird

Make sure you are subscribed to "Chats" in the folder tree on the left side of Thunderbird (right click to change)

Step 5: Install Export Tools Into Thunderbird

Install Thunderbird add-on ImportExportTools

Step 6: Export All Chats to a Directory

In thunderbird with the "Chats" folder highlighted, go to "Tools"-> "ImportExportTools" -> "Export all messages in the folder" -> "Plain Text Format" and select a folder to save it to.

Step 7: Prepare Text Files From a Single Person Into a Single Directory.

Copy only chats from desired person into their on directory. Search that directory for a particular persons name and copy those files only to a simple directory like "C:\Chats"

Run batch renaming file to remove spaces from file names and shorten them. Save the "rename.bat" file in that same directory.. [i got it here]. In the command prompt go to C:\Chats and type in:  rename.bat -files " " "_" C:\Chats in order to get rid of the spaces. You may also want to replace the name of the person in the file with initials to make it smaller. rename.bat -files " Bob Dole " "bd" C:\Chats

Step 8: Combine All Chats Into a Single Text File.

From the start menu -> run -> type in "cmd" and enter. 
Navigate to the correct folder using "cd .." and cd "Chats", etc...
Use DOS command:  copy /a *.txt allchats.txt
This combines all of the text files into a single file called "allchats.txt"

Step 9: Edit Chat Text File to Get Rid of Some Common Words/expressions

Open "allchats.txt" in Notepad++ (or similar) and:
 - use find/Replace to remove strings like " me ", " AM ", " AM:", " PM ", " PM:", " minutes ", etc...notice the spaces and colons in there. I ended up going back to this step several times, otherwise some words are really big. You can also remove words from the wordle site.
 - optional: select all and right click to change all to upper or lower case.

Step 10: Run Text Through Wordle.net Website.

copy all text into wordle.net website.

After doing this you can set different coler/text options. You can also remove words by right clicking them.

Be the First to Share


    • Backyard Contest

      Backyard Contest
    • Silly Hats Speed Challenge

      Silly Hats Speed Challenge
    • Finish It Already Speed Challenge

      Finish It Already Speed Challenge