You do have Conquests, right?
When you download a scenario you will usually get a folder and a biq file, called something like: Roman Empire (or whatever). Put this folder and this file into the scenario folder which is located inside the Conquest folder which is located inside the main Civilization folder: Civilization/Conquest/Scenarios.
To play it: Now open civ and choose "civ-content" in the menu.