How To: Get NPC Data From D20PFSRD

[Willot]

Or how I managed it

First goto D20PFSRD's Excellent webpage (if you havnt been there yet You should!)
https://www.d20pfsrd.com/ (https://www.d20pfsrd.com/)

Find The NPC DB (links on the left panel) NPC Stat Block Database. Copyright 2011 Mike Chopswil, d20pfsrd.com

Download the database in CSV

Open this with EXCEL (Im sure other spreadsheet programs could do it too)

Find the section that looks like this https://docs.google.com/file/d/0BwaMe0ApGapgcndNR0lYdS0xQU0/edit?usp=sharing and copy ONLY the BH (Full Text) column to the clipboard

In my case im only getting the stuff from AP 29

I then paste this into Notepad (not wordpad. It may mess with formatting) and then "Save As" "AP29 NPC.html".

You can now open it with a web browser and you should see a nice Stat Block Format now.
https://docs.google.com/file/d/0BwaMe0ApGapgUFpfOTRFeDhmZWs/edit?usp=sharing

"Select all" of this and Paste it back into Notepad.

Now its just a case of removing all the blank lines (cept those between NPCs/MOBS) and move the CR up to be next to the name of the NPC

(I removed all blank lines using Word search/Replace double paragraph mark with single paragraph mark)

NOW you can use Trenloe's Parser (https://www.fantasygrounds.com/forums/showthread.php?t=15475&highlight=parser)
To get them into your Campaign

Hopefully that makes sense

[Callum]

Excellent - thanks for this guide, Willot!

When removing the blank lines, I did a search & replace for "^p^pCR", replacing it with " CR" - moving the CR to the right place as part of it.

[Willot]

Excellent - thanks for this guide, Willot!

When removing the blank lines, I did a search & replace for "^p^pCR", replacing it with " CR" - moving the CR to the right place as part of it.
Oh yeah I did something like that too. Forgot that bit :)
(for Trenloes Parser the CR bit has to be move to correct position)