Generate A Word Frequency List
- Description: A workbook that demonstrates a VBA macro that creates a word frequency list. Put your text in Column A, with no blank cells. The text can consist of sentences, titles, etc. Run the macro, and you get a pivot table that lists every word, and the number of times it's used. The demo file contains three examples: Beatles song titles, the first few paragraphs of Moby Dick, and a George W. Bush speech.
- Has Macros? Yes/il>
- More Information: Click here
- Download: wordfrequency.xls
This section contains free Excel workbooks and add-ins. With a few exceptions, all of these files were developed by me -- John Walkenbach. Some of the files demonstrate useful techniques that you can adapt to your own work. Others are simply for fun.
The files are grouped into three categories: General Interest, For Developers, and Add-Ins. The files may not be compatible with all versions of Excel.
Browse Downloads by Category
Also of Interest
How to download
Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results: