IMPORTDATA Google云端硬盘上的Google Sheet CSV [英] IMPORTDATA Google Sheet CSV on Google Drive

问题描述

因此，我开始真正开始利用Google云端硬盘简化我的许多个人项目.我想做的一件事是弄清楚如何将CSV文件下载到我的Google云端硬盘中，并让Google表格自动对特定目录中的任何新.csv文件执行 = IMPORTDATA .

So I'm starting to really get into utilizing Google Drive to streamline my many personal projects. One of the things I'd love to do is figure out how to download CSV files onto my Google Drive, and have Google Sheets automatically do an =IMPORTDATA on any new .csv files in a specific directory.

我试图解决这个问题时遇到了许多问题，但是最大的问题是，在Google云端硬盘中放置任何类型的文件都不会为您提供文件本身的链接，而是类似这样的东西:

I've come across a number of problems trying to figure this out, but the biggest issue is that putting any kind of file on the Google Drive doesn't give you a link to the file itself, but rather something like such:

https://drive.google.com/a/xxxx/file/x/xxxxxxxxxxxxxxxx/view?usp=sharing

= IMPORTDATA 无法将其识别为.csv文件.我该怎么做呢?

=IMPORTDATA doesn't recognize this as a .csv file. How can I go about doing this?

推荐答案

我从另一个论坛找到了答案:

I found the answer from another forum:

如本文所述，生成直接下载链接似乎可以与 = IMPORTDATA 函数配合使用.

Generating a direct download link, as described in this article seems to work fine with the =IMPORTDATA function.

总而言之，您从共享链接中获取SITE_ID字符串:

To summarize, you take the SITE_ID string from the sharing link you have:

https://drive.google.com/file/d/FILE_ID/edit?usp=sharing

使用此方法，您可以生成直接下载链接，以与 = IMPORTDATA 函数一起使用:

Using this, you can generate the direct download link for use with the =IMPORTDATA function:

https://drive.google.com/uc?export=download&id=FILE_ID

这篇关于IMPORTDATA Google云端硬盘上的Google Sheet CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！