Insert bulk Parent and Children rows using SQL Query
Once you have normalised you need 2 queries, one to load parents then one to load children (you can only insert into 1 table at a time using sql) 

It sounds like you do this ofter, so why not create a file with the sql commands that you use, and each time you do this task open the file up in your databases sql editor window and run (may-be first modifying) these commands. If it always the same sort of task, you could write a script that connects to the database and runs the sql statments you need - then it is a one click or command task.