Here's the link to the sheet
(the thing this entire page is about): 

https://docs.google.com/spreadsheets/d/1S2btU7KWatwNUL5QQ7S8LVIyUIqu1C3mQSZDRrTU3kg

I'm not really able to contribute much to the modding community while I'm learning but I figured that maybe something this simple could actually help a bit.

You have to download the file to be able to endorse but if you felt like doing it that would be ok with me :D

FEATURES

I've broken out different categories into separate lists on different sheets.  At this time the sheets contained within are as follows:

• Tools/Mods
• Actors
• Ammo
• Armor
• Books
• Constructible Objects (recipes)
• Enchantments
• Ingredients
• Keys
• Leveled Items
• Locations
• Magic Effects
• Misc Items
• Potions
• Quests
• Scrolls
• Shouts
• Soul Gems
• Spells
• Weapons
  

These are just exports of the info from the creation kit that have been imported into a Google Sheet and formatted (formatted somewhat that is). I hope this is useful. I've added a couple of boolean columns in; an example is the column "Female" under actors, I added a column next to it with 1 / 0 instead of Yes / No. A number of empty/redundant columns are hidden, and the font size and width of some columns that my novice brain thought were less important have been reduced.

Some advantages to this format that I hoped others would find useful are:

• If you don't have Office and Don't want to DL OpenOffice, LibreOffice or some other program.
• Being able to search for something on all sheets at once.
• Being able to click File --> Make a Copy in order to have your own personal copy to modify
  

If you really want to get powerful use out of this sheet click File --> Make a Copy and then learn to use either VLOOKUP by itself on a sheet you add OR learn to use VLOOKUP from a separate Google Sheets file entirely while making use of the IMPORTRANGE Function which allows for one Google Sheet to retrieve a range of cells from an entirely different sheet. It is the bomb for real.

I'm sure someone else has already provided something similar to this and it more than likely is superior to mine and I'm a terrible person for providing something similar for some reason that I'm unaware of (I am a terrible person btw and am aware of a number of reasons already but this comment is strictly in reference to reasons of which I am currently unaware).

If anyone thinks something could be better or could be added or should be changed please just make a post and I'll see if I can help

CHANGELOG

• Version 0.4
  • Added a sheet for all Quest IDs 
  • Added a sheet for all Location IDs
  • Added a sheet with a list of in and out of game tools as well as some QoL mods I wish I'd known about sooner
  • Copied and pasted values on a bunch of formulas that were slowing the load time (oops)
    
• Version 0.3
  • Added 3 columns: Quantity, Name and ID, for each separate individual component item of each recipe (7 is the max) and then for each separated the quantity and name into their respective columns then finally added the ID of each component into its column
    
• Version 0.2
  • Tried to reorder columns on each sheet to a more standard scheme
  • Narrowed some columns to try to fit a 1920 x 1080 screen
    
• Version 0.1
  • First entry on the nexus... be gentle
    
  
  

PERMISSION

You are allowed to upload this file anywhere as long as you link to the original and give credit. To prevent fragmentation let me know if something is missing or incorrect and I'll try to add/fix it so we don't have a million different crazy copies floating around.
Obviously the majority of the info contained in this resource is all vanilla information direct from the game devs so no need to ask me anything at all about using any resource contained within for any lawful use.
No need to contact me.

I really don't care what any of this is used for as long as it isn't illegal, immoral, unethical or unsafe.

DISCLAIMER

This mod is not made, guaranteed, or supported by Zenimax, Bethesda Game Studios, or any of their affiliates. Except as expressly stated to the contrary this mod is not guaranteed, or supported by any other mod developer or uploader.  Providing a patch does not imply an endorsement, approval or guarantee of compatibility for the patch’s master files.
Credit for mods or other resources contained herein may be incomplete. For further detail visit the mod’s Description page.  Please remember to endorse mods you enjoy! 
THE RESOURCES HEREIN ARE PROVIDED "AS IS" AND WITHOUT WARRANTIES OF ANY KIND EITHER EXPRESSED OR IMPLIED, TO THE FULLEST EXTENT PERMISSIBLE PURSUANT TO APPLICABLE LAW. AUTHOR/UPLOADER DOES NOT WARRANT THAT THE RESOURCES PROVIDED BY THE AUTHOR/UPLOADER WILL BE ERROR-FREE, THAT DEFECTS WILL BE CORRECTED, OR THAT THIS SITE OR THE SERVER THAT MAKES IT AVAILABLE ARE FREE OF INCLUDING BUT NOT LIMITED TO VIRUSES OR OTHER HARMFUL COMPONENTS. AUTHOR/UPLOADER DOES NOT WARRANT OR MAKE ANY REPRESENTATIONS REGARDING THE USE OF OR THE RESULT OF THE USE OF THE RESOURCES PROVIDED HEREIN IN TERMS OF THEIR CORRECTNESS, ACCURACY, RELIABILITY, OR OTHERWISE. YOU (AND NOT AUTHOR/UPLOADER) ASSUME THE ENTIRE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. THE ABOVE EXCLUSION MAY NOT APPLY TO YOU, TO THE EXTENT THAT APPLICABLE LAW MAY NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES.

CREDIT

Bethesda for the game and Creation Kit
Arthmoor for his Disclaimer statement
Don Ho for Notepad++
The GIMP Team for GIMP
Google for Sheets and Chrome
The community here at NEXUSMODS for just being awesome
Robin Scott for this site
My mother and father for my birth
My personally chosen higher power for our existence
CORSAIR for my keyboard
ACER for my monitor
MSI for my motherboard and graphics cards
Intel for my processor
The United States government for my roads, water supply, public engineering
My wife for everything
My contractor for my working plumbing
Starbucks for their coffee
Google for my phone
My unnamed phone service provider for their crappy service
Our baby for being awesome after waiting 12 years for infertility (no such luck) but then finding the perfect baby to adopt!!!

MY STUFF

Scrapping Companion for Ars Metallica
Human Enemies Drop Hearts and Flesh Patches
Navmesh Filtering Method
THE Autumn of Whiterun Patch
Bells of Skyrim Compatibility Patches
NPCs Protected Redux Patches
Lose Some Weight
List of Skyrim IDs & More