converting csv files in google drive to google sheets

This stackoverflow answer seems to be good. Either download and re-upload after enabling "convert uploads" in Drive settings, or use an Apps script.