I have an excel file that has a series of values stored as their names (dog, cat, snake) as AnimalType.

What I need to do is for each value of AnimalType I want to programmatically determine what type it is:

(something like:
IF AnimalType column = Snake
Then Snake column =1)

THe point is to parse the entire excel and for each predetermined value of AnimalType put a 1 or 0 next to its corresponding AnimalType name.

The end result is I want to be able to query for all of the snakes or cats or both...