Importing a CSV located in Google Drive

Good morning,

You have to export the drive as CSV: https://xfanatical.com/blog/how-to-export-google-sheets-as-csv/

In this way it will work.

Hi Javier,

Thank you for responding so quickly.

I am afraid we are not understanding each other. When you say “You have to export the drive as CSV”, I am assuming you meant “exporting a Google Sheet as CSV”. If that is correct, I need to re-emphasize the fact that the CSV is NOT an export of a Google Sheet. It is GENERATED programmatically (by a Google Script) as a CSV file and written directly as a file in a Google Drive folder. So there is no export involved here.

If you didn’t mean “exporting a Google Sheet as CSV”, then I don’t understand your statement.

Can you clarify either way?

Thanks.

Pierre

Can you share a url like the one you comment to see the data? Use example data.

Hi Javier,

Here is the publicly available link to a sample data CSV file
https://drive.google.com/file/d/1Ucji4cKU47Tx6Ip1X5b-I-WDdikxEPJ3/view?usp=sharing

I tried the above link for the import URL as well as
https://drive.google.com/uc?export=download&id=1Ucji4cKU47Tx6Ip1X5b-I-WDdikxEPJ3

Both failed. Thank you for looking into it for me.

Pierre

This kind of link: https://drive.google.com/uc?export=download&id=1Ucji4cKU47Tx6Ip1X5b-I-WDdikxEPJ3

Will work in version 1.26.10 that has just been released.

Muchas Gracias Javier, for successfully fixing your plugin in record time for me. I am truly impressed and grateful for your support. 5-star support.

Pierre
P.S. I am going to send you a separate email from your website so as to not clog this forum for something unrelated. Thanks again.

Thanks for your words! And for your help!