Test Data Generation: How to automate? [Excel -> SQL]

I want to automate my test data generation and hoped for some approaches.

My current situation: I have two excel sheets with static data (patients and doctors) and some with dynamic data [for example weight records for an active patient, weight records for an inactive patient, etc.] (these values are not static, because it should be different for every patient and I want to see trends and dependencies). But what I want is to create INSERT INTO Statements out of this. It needs to be considered that for every patient a dynamic sheet must be calculated and that there is a foreign key relation.

What is the best way to do this?

Best regards and thanks in advance.