Is there a way to make this data import easier?

Can you make it into a JSON file? I think that will simplify matters a lot. And if you don't quote the numbers in the JSON file, they will be imported as number (I believe/hope.)

See my answer here about importing a JSON file: