Generate A Word Frequency List

Category: General Files / Developer Files | [Item URL]

  • 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
  • More Information: Click here
  • Download: wordfrequency.xls

Search Downloads


All Downloads

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:

  1. Right-click the download link
  2. From the shortcut menu, choose Save Link As or Save Target As
  3. Specify the location for the downloaded file.
© Copyright 2017, J-Walk & Associates, Inc.
Privacy Policy