Archive for June 2nd, 2009

Tip: Getting word counts from Excel files

Jun. 2nd 2009

Getting word counts from Microsoft® Excel files is a common and frustrating task for translators and writers and general.

One common approach is to save the worksheet as a text file, then open that in Word and use the Word Count feature. This approach has some problems, though: you can only save one worksheet at a time, and text in text boxes isn’t saved, so you could end up with a word count that’s too low. Not to mention the time and hassle involved.

About a year ago, I did a huge translation that literally consisted of hundreds of Excel files and thousands of worksheets. Counting the words in each file using the MS Word method would have driven me batty.

If you use Windows and often need to get word counts from Excel files, I recommend my free program, Count Anything. Just click the “Count” button, drag and drop your Excel files into the dialog, and click OK.

Drag and drop Excel files into the dialog box

You’ll end up with a nicely formatted report that you can drill down on, print, or save as an HTML or text file.

Results of Excel file word count

Click here to download the free Count Anything program.

Posted by Ryan Ginstrom | in Felix | 16 Comments »
  • Search

  • Categories

  • Calendar

    June 2009
    M T W T F S S
    « May   Jul »
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  
  • Pages

  • Meta