E18 Pokemon Locations Spreadsheet - All Wild and Event Pokemon Plus More

[Aegisth 31]

I created a spreadsheet that includes a list of all Pokemon with the following additional information:

 

1. Every Location the Pokemon shows up in with notes (Locations 3 - 22 are columns currently hidden)

2. What gym badge is needed to get the Pokemon at that location

3. The Pokemon's Type, EV's given, and Base Stats

4. How many evolutions that Pokemon has

5. If that Pokemon has a pre-evolution that's a Baby form

6. If that Pokemon has a branched evolution

 

All of these fields are filterable and sortable, so you can easily filter down for whatever you want. For instance "What Pokemon that evolve twice are available before Florinia?" is easily filterable.

 

Here is the link: https://docs.google.com/spreadsheets/d/1zbFBBm_MvNeWb-d7uswVMZCk_NUU76idjhKXEEjjcGg/edit?usp=sharing

 

Please let me know if you see anything that needs updating or is incorrect.

 

Special Thanks:

Starry Knight's thread 'Void Kissed Pokemon Location Guide'

Friz's thread 'Pokemon Reborn Walkthrough - Episode 17 100% Completion'

Bulbapedia's List of Pokemon by Base Stats, List of Pokemon by EVs, List of Pokemon by Type

Pokemon Wikia's List of Pokémon by evolution

@mantidman for providing some Excel expertise

Starry Knight for pointing out a ton of inaccuracies

Tari for pointing out a ton of inaccuracies

Vinnie for pointing out inaccuracies

 

 

Enjoy!

 

Update 11/10/18:

 

Updated the following

 

1. Added all E17 and some E18 mega-stones

2. Created Filter Views for every monotype challenge run. Data -> Filter View

3. Added a few E18 event Pokemon that were not their previously

4. Added coloring to Gym Leader names to easily tell sections of the game at a glance

5. Added a filter for starter pokemon of an evolutionary tree

6. Add filter view for Pokemon that do not evolve

7. Added a column for the National Dex# for every Pokemon on the sheet

 

Update 1/5/19:

 

1. Added Egg Types for every Pokemon on the sheet.

2. Created Filter Views for each Egg Type. Data -> Filter View

 

Update 2/20/19:

1. Added all Pokemon to the sheet

2. Fixed inaccuracies

 

Update 4/2/2019:

1. Updated inaccuracies pointed about Tari. Thank you! A lot of fixes around Shelly/Shade

2. Updated inaccuracies pointed about by Vinnie

 

Update 4/42019:

1. Updated inaccuracies for mega-stone locations pointed about by Tari. Thanks again for the amount of help you've provided with updated locations

2. Updated when 7th st Pokemon could be located thanks to Connor

 

Update 5/21/2019:

Updated multiple Pokemon locations based on user feedback.

[Aegisth 31]

On 5/24/2020 at 12:35 PM, Starry Knight said:

Beldum is after Argate you cannot get before Argate Circus

Thanks, I'll update.

[Starry Knight 753]

2 hours ago, Aegisth said:

Thanks, I'll update.

Np, people were getting confused about bit on the forums

Also idk if you have it mentioned but squirtle is all rain now

[Starry Knight 753]

Ledian in Tanzan Morning only, had someone from Discord comment on that

[Enderhazard 0]

Klefki can be obtained before the fight with Adrienn instead of before Titania as the document suggests. 

It should also be noted that in order to get the classified information, you need to return a diamond ring, which can be found while diving in Azurine Lake.
Can't remember exactly which dive spot it was, and I can't remember if you need to find the key for it.
There's also a battle when returning the classified information to

Spoiler

Looker

And the difficult battle is more specifically a double battle

[Aegisth 31]

Thanks all, updated info.

[Zemenes 4]

There's a location for Drilbur besides the mystery egg. It's available as soon as you make it back to Neo Reborn.  You can surf over the lake in the Hidden Cove to the cave where the Larvitar puzzle is and Drilbur will be a random encounter inside the cave.

[Starry Knight 753]

5 hours ago, Zemenes said:

There's a location for Drilbur besides the mystery egg. It's available as soon as you make it back to Neo Reborn.  You can surf over the lake in the Hidden Cove to the cave where the Larvitar puzzle is and Drilbur will be a random encounter inside the cave.

There's a small chance on Tanzan after steelix as well u can get into a small area to get it as well

 

@Aegisth I can screenshot u the spot

[Aegisth 31]

On 9/13/2020 at 10:49 PM, Starry Knight said:

There's a small chance on Tanzan after steelix as well u can get into a small area to get it as well

 

@Aegisth I can screenshot u the spot

 

That'd be great.

[Shadow Tack 2]

Can get carbink from the sunkern trade, it also isn't noted on there that the trade is one time only

[Starry Knight 753]

On 10/12/2020 at 7:42 PM, Aegisth said:

 

That'd be great.

Right where facing in a pokeball usually