Best workflow for bulk data acquisition

I’m interested in creating a reference architecture for our overarching org that my sub-org can map/reference. It is quite large with a Glossary of Terms that include 47,000 records. These terms are of approximately 50 different types.

I’m looking for the best pattern for getting this data into VP as Terms and then converting/copying them to the specific model elements they represent and then develop models from there without having to type text that is already entered and defined…

Suggestions of any kind are helpful…

Sorry for a late response, I’ve been a bit absent lately.

I don’t have hands on experience with this (obviously) but I’d probably try to write and utilize a plugin of some sort.