ESO Searchable Reference Database

I have been very unsatisfied with my inability to find the information I look for quickly regarding potion effects, ingredients, food, runes, glyphs, etc. To help combat my struggle, I've been utilizing spreadsheets created by various people to help find information. Many times, these spreadsheets have hundreds of rows and finding the exact potion you need, with the exact affect, can be tedious.

So what I've done is gathered a few spreadsheets into one location for convenience. I've also double checked much of the information contained, and corrected many of the errors/filled in gaps. Additionally, I've spent some time formatting the information in such a way as to many off the fields searchable. A few examples might be:

-All potions that have increase spell resist are now easily searchable in seconds.
-All potions that may use Imp Stool -- now easily searchable in seconds.
-All food that increases health.

The information contained may be intuitive for some of you, but for those of us who utilize spreadsheets to understand crafting, potions, enchanting, and more -- then I think this will be useful to others as well, especially in discovering new potion and food types that include combinations of effects otherwise you may not consider (at least I had never). Much of this information can be found in other locations. I think the true beauty here though is the filter functionality and formatting making searching for information quick and painless.

I can take no credit for creating the original information, but I see no copyrights on any of them so as far as I am concerned, feel free to use it, take it, copy it, share it, modify it, whatever you want with it. I unleash this ESO spreadsheet unto the world:

ESO Searchable Reference Database