Wizard’s Spellbook Generator for Pathfinder (in Excel)

This Excel spreadsheet works pretty well. Input the level of the Wizard (1 through 20), his INT (10 through 45), and how developed the book is. The last is binary in nature. Either he only the spells that he got from going up each level (which is very few), or he has purchased other spells over time (normal). The sheet isn’t perfect; it still generates some duplicate spells, so you’ll need to swap those out. It also doesn’t generate lists for specific schools. It also doesn’t prioritize spells, so you’ll get lots of random spellbooks rather than ones filled with Magic Missile, Fireball, Web, Enlarge person, and the other standard spells. Again, if that doesn’t fit your needs, just swap them out. When you have a list that looks good (hit f9 to generate another one), just cut and paste it.

The sheet does use recursive iteration, so if it isn’t working on your system, click on the Window Button (top left), select Excel Options/Formulas, and turn on recursive iteration. Using 100 iterations should do the trick.

And if you’re interested in Pathfinder Wizards, you might also want to look at my older post on Selling Wizard Spells in Pathfinder.


About lostdelights

An old gamer flying his freak flag, I've been playing table-top role-playing games since 1978. I've been building my own system (Journeyman) since 1981.
This entry was posted in Gaming Tools & Accessories, Pathfinder. Bookmark the permalink.

4 Responses to Wizard’s Spellbook Generator for Pathfinder (in Excel)

  1. Griff says:

    Thank you SO MUCH for this, it’s exactly what I was looking for!

  2. Arlith says:

    This is really neat, is there an easy way to go in and add spells? It looks like it just pulls from APG and CRB.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s