Counting Words in Excel
Struggling With How to Analyze Text Data in Excel?
QI Macros Word Count Wizard Counts Unique Words and Two Word Phrases.
Most data tracking systems contain note or comment fields for customer service reps, healthcare workers and even customers to input into. These fields contain interesting and valuable data, but it is often hard to analyze.
What are your options? You can spend hours reading through these comments and attempting to tally them. That can be grueling and fatigue will quickly set in. Or you can use a tool like QI Macros Word Count Wizard.
QI Macros Word count function parses the words out of sentences and paragraphs and uses Pivot Tables to count the occurrences of individual words and two word phrases. Then it displays the totals in a descending order for analysis and creating charts.
Here's how the QI Macros Word Count Wizard Works:
- Click and drag over your data to select it.
- Click on QI Macros menu and select Data & Text Mining, then Word Count.
- QI Macros Word Count Wizard will create two pivot tables. One for single words and one for two-word phrases.
- From here you can get a much better sense of what the data says and you can even use QI Macros to draw a Pareto Chart.
Note: Microsoft will not allow Word Count to PivotTable a workbook if there are square brackets in the name:
Excel Pivottable Error.
As a workaround, simply remove the square brackets from your file name and rerun the Word Count on your data set.