Manipulate data from a CSV or XML file

I have a file (CSV and/or XML) with data I need to display on a site. The first link is the head of the tables and the rest of the lines contain product data.
What is the easiest way to read that file and be able to select just the matching categories (ie. products from category "shirts")?
Thanks!

See original post by Fracisc