How to open a csv file using Google Sheets on an iPad?

Question

Level 1

4 points

How to open a csv file using Google Sheets on an iPad?

csv file, when copied from my iPad to my Google Drive, pops up a dialog box on my iPad, “Will need authentication before it can be used”, or something like that. Searching online, it seems that Google apps do not respond to the iPad’s need for authentication therefore no Google apps seem to be able to open the file. A clue that this is true; viewing file listing in the Google Drive app (on my iPad) of my files in on the cloud of Google Drive, I can see the csv file I just copied there listed in the directory I put it in, but the icon shows a small cloud with down arrow and the word, “Waiting”.

Posted on Jan 9, 2024 5:30 AM

Reply

Answer 1

Top-ranking reply

Fargo_World Author

Level 1

4 points

Jan 9, 2024 5:45 AM in response to Fargo_World

This seemed to work:

Save csv file to my iPad device (not iCloud).
Open the csv file using the Apple Numbers app that came on my iPad.
In the Numbers app, export the file as an Excel spreadsheet to my iPad device.
Using the iPad (Apple) Files app (where I have my Google Drive linked), copy the Excel file to my Google Drive.
Goto Google Sheets, open the Excel file.

Not sure why there is not some authentication issue when I copy the Excel file to Google Drive but there is an issue when I copy a csv file, but … that is now only a distraction.

Reply

Answer 2

dumonde

Level 1

15 points

Mar 19, 2024 4:16 PM in response to Fargo_World

You can also long press on the CSV file in iCloud Drive, choose open in new window, select all of the text in the window that opens, copy, go to your Google sheet, and paste.

Reply

How to open a csv file using Google Sheets on an iPad?

Similar questions