It kind of sounds like you need to normalize the data? What I would do is 1) Create a new schema reflecting the data normalization you want. Meaning creating

It kind of sounds like you need to normalize the data? What I would do is 1) Create a new schema reflecting the data normalization you want. Meaning creating all the tables foreign key relationships, etc. 2) Use programming language of your choice (my quiver would be rails), just for the ORM to read in the csvs then write the data out to the tables.