This resource is a large, intelligent spellbook (i.e, an interactive spreadsheet) created to help magic users easily sort, compare, and select spells from the Pathfinder 2e TTRPG. The world of magic is vast, and this tool was designed to ensure that you can choose the right spell for every scenario.
The creator of the spellbook, Keth Blackmane, is a barbarian of varying repute. Not a magic user himself, Keth began writing this spellbook after one too many of his magical party mates cast Fireball when a Befuddle really would have been more appropriate. Yet, "Keth", they would say haughtily, "you have it so easy. Just charge in and wave your little axe around. You'll never really understand the depths of reasoning needed in the magical arts." So he began writing this spellbook, to help those poor souls grasp the true power of their art as he grasps the hilt of his blade, and to prove that an understanding of the magical world can be achieved even when you dump Int.
Version 1.3: Contains all 227 cantrips and rank 1 spells. Includes dropdown menus to heighten spells and adjust other pertinent casting options (e.g., actions used to cast, targets, etc.) where appropriate. Formulas designed to function with both Excel and Google Sheets. Spellbook has been beautified, and a "Spell List" column has been added to allow magic users to create their own list of spells. Links to full spell description on Archive of Nethys have been added in the "Name" column for every spell.
In the future I hope to include all spells of all ranks in this spellbook (and maybe a Starfinder 2e spelldrive), so be on the lookout.
Step 1 - Choose your version by clicking one of the buttons to the right.
Google Sheets users will be linked to a "View Only" version of the spellbook and will need to make themselves a personal copy in order to use it (Google account required).
Microsoft Excel users will directly download the spellbook to their computer.
Note that these spellbooks are best viewed a 50-75% zoom.
Step 2 - Do not edit non-dropdown cell contents.
Its a bad idea. You will break your version and need to download a fresh one if you save after editing. Note that many columns used for calculation have been hidden on the far right of the spreadsheet. Be certain you do not delete them or alter them in any way.
Step 3 - Become familiar with the layout by checking the "Meta Data" sheet.
Select the "MetaData" tab in the lower left corner and read the descriptions of what data is contained in each column of the spellbook. The MetaData sheet also contains any definitions for shorthand notation used in the spellbook.
Step 4 - Filter your spells.
All data columns will allow you to filter the spellbook. For example, if you want to view only damaging spells, filter the "Spell Type" column to show only damage spells. If you don't want to see cantrips, filter the "Cantrip" column to exclude them. If you want to see Arcane spells, filter the "Arcane" column so that only arcane spell are shown.
Remember that to reset the spellbook to an unfiltered state, you will need to manually reset any filters you have active (see point A to the right).
Get creative with your filters!
Tip for filtering spells: Don't forget to utilize the search function of the filter menus! Do you want to see only spells that do fire damage? Search for "fire" in the "Damage" column's filter menu and select only those entries that have fire in the listing. The same can apply for specific condition (e.g., Dazzled, Confused, etc.) and bonuses/penalties (e.g., status, circumstance) to see only those spells that cause them.
A. Click the filter button next to the column headings. Notice that filtered column headers appear different from unfiltered column headers. Here, the "Cantrip" column has an active filter while none of the other do.
B. Unfiltered columns will have all options selected by default. Clear the default selection.
C. Click the selection you would like to see.
D. Click okay and view filtered results.
E. To return the spellbook to its original, unfiltered state, identify the columns with active filters (see A), open their filter menus, and click the "Select all" button. Then, click OK.
Step 5 - Heighten your spells and change your casting option using dropdown menus.
Cells with adjustable options are brightly colored for clarity. To adjust those options simply click the dropdown arrow associated with the colored cell and select your option from those listed.
To heighten a spell, select the rank you would like to heighten to from the dropdown in the "Casting Rank" column for that spell. Reference the "Heighten" column to learn where the changes from heightening took place it is not clear.
Changing the spell rank is not all that you can accomplish with dropdown menus in the spellbook. Some spells have other casting options that can be adjusted (e.g., number of actions used to cast the spell, targets, etc.). For some interesting examples, check out Horizon Thunder Sphere, Heal, and Flourishing Flora.
Step 6: Build your spell list!
The first column of the spellbook is labeled "Spell List". In the Google Sheets version it has unchecked check boxes. In the Microsoft Excel version it is blank.
Google Sheets: simply check the boxes of the spells you want to put in your spell list. Then, filter using this column to reduce the selection to only those in your spell list. To uncheck all previously checked boxes, just highlight the entire column and press the space bar.
Microsoft Excel: There are no checkboxes in this version (Microsoft Excel does not have checkbox functionality), so simply add a character or number to these cells in the rows of those spells you want on your list. Then filter the spellbook using this column to reduce the selection to those spells on your list. To unmake your spell list, highlight this column, unselect the header, and press the delete key.
Google Sheets
Microsoft Excel
Step 7: Consider leaving feedback.
This project is in its early stages. There are plenty of spells to be added and improvements to be made. If you have any feedback concerning functionality of the spellbook, suggestions for improvement, or anything else, please visit the feedback form to the right and let me know! Thanks for checking it out. Happy adventuring.
Heightening tip 1: To heighten all spells to a specific level use the Find/Replace function.
For Google Sheets:
A. Highlight the entire "Casting Rank" column by clicking above the header.
B. Unselect the header by using cntl+click.
C. Open the "Edit" menu.
D. Click "Find and Replace"
E. Select "Search using regular expression"
F. In the "Find" bar enter "."
G. In the "Replace with" bar enter the rank you would like to change all spells to. In this case we are resetting to rank 1.
H. Click "Replace all"
I. Check that the spellbook has been heightened properly.
For Microsoft excel:
A. Highlight the entire "Casting Rank" column by clicking above the Header.
B. Unselect the header by using cntl+click.
C. Navigate to the Home tab.
D. Open the Find & Select menu
E. Click "Replace..."
F. In "Find what" bar enter "*"
G. In the "Replace with" bar enter the rank you would like to change all spells to. In this case we are resetting to rank 1
H. Click "Replace all"
I. Check that the spellbook has been heightened properly.
Google Sheets
Microsoft Excel
Heightening tip 2: To un-heighten all spell to their base rank use the use the "Values only" special paste.
For for Sheets and Excel:
A. Highlight the entire "Base Rank" column an unselect the header.
C. Copy the highlighted cells.
D. Highlight the entire "Casting Rank" column and unselect the header.
E. Right click and navigate to "Paste Special" (if using Sheets) or "Paste Options" (if using Excel).
F. Paste only the values.
Google Sheets Microsoft Excel