http://darkreign40k.com/drjoomla/index.php/component/docman/doc_download/346-40k-adversaries

This is a nearly complete list of every NPC, monster, alien, template, etc. in Dark Heresy, Rogue Trader, and Deathwatch published books, complete with book references, page numbers, and brief descriptions. Unfortunately Darkreign won't let me upload it as a spreadsheet file, but I'll post an alternate link to a spreadsheet file as soon as I make it. This file will be periodically updated as books are released. Enjoy and Merry Christmas/Happy Holidays everyone.

Thank you! This is awesome, I was hoping someone would do something like this.

Very cool! Thanks so much.

Thanks! I always love this kind of time-saving compilation. Stellar work!

Just a short bump, the list has been updated with NPCs and adversaries from the following books:
Dark Heresy GM Kit
Deathwatch: Final Sanction
Deathwatch: GM Kit
Rogue Trader: Frozen Reaches
Rogue Trader: Forsaken Bounty
Dark Heresy: Shattered Hope
Dark Heresy: GM Kit
Dark Heresy: Edge of Darkness
And here's the link to Excel spreadsheet version (which is much more manageable and is searcheable to boot!): http://www.filefactory.com/file/b4fhg93/n/40k_adversaries.xls as promised

Thank you most kindly.

the excel file is gone now.

I just checked the link and it's working fine. However, Filefactory could've been down for maintenance and that's why the link was not working.