When uploading CSV or Excel files to Google Drive in order to collaboratively edit, be certain to convert the file on upload.
-
Naviage to the Google Drive settings menu:
-
Check the convert uploads box:
-
After upload, the message should indicate that the file was converted: