STAUPELL ANALYTICS GROUP - ANALYTICS EXPERTS FOR NONPROFITS, IMPROVING FUNDRAISING
  • Home
  • About
    • Staupell Team
    • Testimonials
    • Partnerships >
      • Prospect Research Institute
      • Lityx
      • TouchPoints
      • Gravyty
  • Services
    • Fundraising Analytics
    • Prospect Development
    • Business Intelligence
    • Database Administration
    • Fundraising Optimization Solution
  • Training
    • Analytics Machine Learning Artificial Intelligence
    • Business Intelligence Visualization Reporting
    • Prospect Research and Management
    • Webinars
    • Classes >
      • Beginner Analytics Using R
      • Analytics Classes
      • Skill Builder Series
    • Workbooks
  • Blog
  • Events
    • Water Cooler Chats
    • Video Replays
  • Contact
  • Product

Driven by Data Blog

How to Create Word Clouds from Your Contact Reports Using Excel

3/7/2023

0 Comments

 
​In our February Water Cooler Chat, we were asked if it were possible to do a word cloud from contact reports using Excel because it’s a tool that is familiar and used often.
Although it is possible, the process is clunky. Since Excel wasn’t built to do word clouds, the process does require the use of a macro.
Typically when the Staupell team does word clouds, our tool of choice is Tableau.
If you’re adventurous and want to dive into using Excel for creating your Word Cloud, here are the steps. Watch this video for detailed instructions.

​Summary of Steps:

  • Upload your contact report into an Excel sheet.
  • Highlight the column containing your free text data.
  • Select Data, then Text to Columns.
    • Choose file type Delimited.
    • Choose Space as your delimiter.
  • Create an empty sheet.
  • Paste the contents of the individual columns from your first worksheet into Column A of your new worksheet. (Clunky process, but hang with us. Refer to video time stamp 1:09-4:51)
  • Sort Column A of all your words to get all the same words grouped together.
  • Remove common words that aren’t necessary to track. (i.e. remove works like “a,” “an,” “and,” “the,” etc. Refer to video time stamp 5:49)
  • Take the word list you’ve just created and make them into a pivot table.
    • Use the Word and the count of the word
  • Sort by largest count to smallest.
  • Select the words with the largest numbers (suggest the top 20%).
  • Download the macro found on Chandoo. (Refer to video time-stamp 10:00)
  • Enable editing.
  • Save As Macro-Enable Workbook.
  • Update columns with your data.
  • Select your contact report words, click Developer on your top menu, then select Macros.
  • Select CreateCloud macro and Run.
Use your word cloud in presentations and reports with your fundraising team.
0 Comments

    Keep Informed
    Sign up for
    notifications when a
    new post comes out

    Sign Up Now


    Authors

    Marianne Pelletier has more than 30 years of experience in fundraising, with the majority in prospect research and prospecting.

    Greg Duke helps Raiser’s Edge clients to optimize their database by implementing data clean-up techniques and creating reporting structures, including dashboards and SQL queries.  He also facilitates data imports into Raiser’s Edge and database administration.

    Categories

    All
    Advancement Svcs
    Annual Giving
    Artificial Intelligence
    Assessment
    Big Data
    Blackbaud
    Branding
    Dashboards
    Databases
    Data Management
    Data Mining
    Data Prep
    Dependent Variables
    Donor Modeling
    Efficiency
    Engagement
    GDPR
    Giving Variables
    Linear Regression
    Machine Learning
    Major Gifts
    NFT
    Participation
    Productivity
    Project Planning
    Prospecting
    Prospect Research
    Push Technology
    Raiser's Edge
    RE NXT
    Reporting
    Research Pride
    RFM
    Statistics

    Archives

    March 2023
    February 2023
    January 2023
    December 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    March 2021
    September 2020
    June 2020
    May 2020
    March 2020
    February 2020
    July 2019
    May 2019
    March 2019
    December 2018
    September 2018
    May 2018
    March 2018
    September 2017
    June 2017
    March 2017
    January 2017
    December 2016
    September 2016
    June 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015

    View my profile on LinkedIn
Picture
© COPYRIGHT 2023 Staupell Analytics Group. ALL RIGHTS RESERVED.
  • Home
  • About
    • Staupell Team
    • Testimonials
    • Partnerships >
      • Prospect Research Institute
      • Lityx
      • TouchPoints
      • Gravyty
  • Services
    • Fundraising Analytics
    • Prospect Development
    • Business Intelligence
    • Database Administration
    • Fundraising Optimization Solution
  • Training
    • Analytics Machine Learning Artificial Intelligence
    • Business Intelligence Visualization Reporting
    • Prospect Research and Management
    • Webinars
    • Classes >
      • Beginner Analytics Using R
      • Analytics Classes
      • Skill Builder Series
    • Workbooks
  • Blog
  • Events
    • Water Cooler Chats
    • Video Replays
  • Contact
  • Product