MP3 File Lister
Category: General Files / Developer Files | [Item URL]
- Description: An Excel application that generates a list of MP3 files. To use it, click the 'Start" button and you will be prompted for a directory. The list includes the directory you choose, plus all nested subdirectories. When the macro finishes, the worksheet will contain a list of MP3 files with the following columns: Path, Filename, Artist, Album, Title, Track, Genre, Duration, and Size. The data can be summarized in a pivot table. This is not the fastest application, so be patient (the status bar displays the current file number).
This workbook requires a reference to Microsoft Shell Controls and Automation (shell32.dll). If it doesn't work for you, check the reference using Tools - References in the VB Editor. The VB Project is not protected, so you can view the code or modify it to suit your needs. - Has Macros? Yes
- Download: mp3filelister.xls
Animated Color Scales
Category: General Files | [Item URL]
- Description: A 62x62 range of cells contain simple formulas that use the SIN and COS functions. Color Scales conditional formatting is applied to the range. Click a button, and the colors change randomly. Click another button, and the image rescales randomly. Click the third button, and it moves. Good clean fun for the entire family.
NOTE: This will not work in versions prior to Excel 2007. - Has Macros? Yes
- Download: animatedcolors.xlsm
The Bible, In Excel
Category: General Files | [Item URL]
- Description: Not to be confused with the Excel Bible, by yours truly. This is the King James Bible in an Excel workbook. Each book is on a separate worksheet, and each verse is in a separate cell. It has a handy hyperlink table of contents so you can jump to any book. I also wrote some summary formulas to calculate the number of characters in each book, and the average number of characters per verse. Then I added a word count feature: Enter a word and it displays the number of occurrences in each book. And finally, a random verse generator. If you use Excel 2007 or later, here's an improved version.
- Has Macros? Yes
- Download: king-james-bible.zip
Smiley Chart
Category: General Files | [Item URL]
- Description: The workbook contains a chart that looks like a smiley face. The amount of smiling (or frowning) is determined by the value of a cell. If the cell contains -1, you see a big frown. If it contains +1, the face smiles. Values in between produce a corresponding expression.
- Has Macros? No
- Download: smilechart.xls
Mail Merge Demo
Category: General Files / Developer Files | [Item URL]
- Description: Normally, Microsoft Word is used for mail merge operations. Word can perform a mail merge with data stored in an Excel workbook. The process works well, but in some cases it may be preferable to eliminate Word and do all of the work with Excel. This example demonstrates Word-less mail merge.
- Has Macros? Yes
- More Information: Click here
- Download: mailmerge.xls
Custom Number Formats
Category: General Files | [Item URL]
- Description: This workbook contains several examples of useful custom number formats.
- Has Macros? No
- More Information: Click here
- Download: custmfmt.xls
Hangman Game
Category: General Files | [Item URL]
- Description: The classic word-guessing game, programmed in VBA - complete with cheesy hand-drawn graphics. Includes many words, and you can even add your own. A much better version of this game is available in Power Utility Pak.
- Has Macros? Yes
- Download: hangman.xls
Array Formula Calendar
Category: General Files | [Item URL]
- Description: This workbook contains a VBA macro that creates a "live" calendar in a worksheet. The days are displayed using a complex array formula. Change the month and year and the calendar updates. Once the calendar is created, you can copy the cells and paste them to another range, another sheet, or another workbook. The macro simply generates the formulas and is not necessary for the calendar to work.
- Has Macros? Yes
- Download: array formula calendar.xls
Excel Doodle Pad
Category: General Files | [Item URL]
- Description: Etch-a-Sketch with a new twist.This workbook displays a doodle pad that lets you create attractive symmetrical drawings using the arrow keys on your keyboard.
- Has Macros? Yes
- Download: xlsketch.xls
Guitar Scales And Modes
Category: General Files | [Item URL]
- Description: This workbook depicts a guitar fretboard. Select the key and scale/mode, and you see where the notes fall.
- Has Macros? Yes
- Download: xlguitar.xls
Excel Downloads
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.
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: