The mod tool and the main game are considered to be separate applications. That means mods you put in the _Data folder of the game and the mod tool are exclusive to each other, e.g. you can’t put the mod you want to upload to the main game folder, and the mod you put in the mod tool can’t be read by the main game.

Example of modding flow:

Some of these steps can obviously be skipped if you just want to upload a mod without testing it, though it is very much recommended to test the mod using the main game first.