I think it also depends on how you have the data. If it is in smaller files, then Excel would be ok, though still time-consuming.
If it is in one huge file, or even if not but you know your way around a database package, importing it into a DB would be better. Then you can build the rule to...