You’re absolutely right. I only learned recently that there are different import options for CSV, and just opening the file doesn’t give all the options. You have to go to data -> import to have all the extra options, like setting all the desired data types.