General Overview
Step 1)

Create a insert statement manually and test it out. You will want to look at existing similar records to see what values are populated

Step 2)

Export Your reference data into excel

Step 3)

Build your insert statements using excel formulas

Step 4)

Run Insert Statements

Gotchas

1. paste data into excel, make sure to click on formula bar otherwise you will get multiple lines
2. after you paste into SSMS use find replace to replace double quotes
3. use variables for better reuse extendibility

TODO - add video from YT

add Example with inserting schools