You could dump the sheets to csv and use this app that I made that you can clone:
It lets you auto-create the columns and select data types. Similar to something like phpmyadmin. You can create custom parsers as well.