BigQuery:加载excel文件 [英] BigQuery: loading excel file

问题描述

有什么方法可以将excel文件直接加载到BigQuery中，而不是转换为CSV.

Is there any way we can load direct excel file into BigQuery, instead of converting to CSV.

我每天都以 excel 格式获取文件，需要加载到 BigQuery 中.现在手动转换为 CSV 并加载到 BigQuery.

I get the files every days in excel format and need to load into BigQuery. Right now converting into CSV manually and loading into BigQuery.

计划安排作业.

如果无法将 excel 文件直接加载到 BigQuery 中，那么我需要编写一个过程(Python)在加载到 BigQuery 之前转换为 CSV.

If not possible to load the excel files directly into BigQuery then I need to write a process(Python) to convert into CSV before loading into BigQuery.

如果有更好的选择，请告诉我.

Please let me know if any better options are there.

谢谢，

推荐答案

我认为您只需点击几下即可实现上述目标，无需任何代码.您需要使用 Google 云端硬盘和外部(联合)表.

I think you could achieve above in a few clicks, without any code. You need to use Google Drive and external (federated) tables.

1) 您可以手动将您的 excel 文件上传到 Google Drive 或 同步它们

1) You could upload manually you excel files to Google Drive or synchronise them

2) 在 Google 云端硬盘设置中找到:

2) In Google Drive Settings find:

"**Convert uploads** [x] Convert uploaded files to Google Docs editor format" 

并检查它.

要访问上述选项，请转到 https://drive.google.com/drive/my- 驱动，点击齿轮设置图标，然后选择设置.

To access above option go to https://drive.google.com/drive/my-drive, click on the Gear settings icon and then choose Settings.

现在您可以通过 Big Query 访问 Excel 文件

Now you excel files will be accessible by Big Query

3) 最后一部分:https://cloud.google.com/bigquery/external-data-drive您可以通过 URI 访问您的 excel 文件:https://cloud.google.com/bigquery/external-data-drive#drive-uri 然后 手动创建表 使用上面的uri.

3) Last part: https://cloud.google.com/bigquery/external-data-drive You could access you excel file by URI: https://cloud.google.com/bigquery/external-data-drive#drive-uri and then create table manually using above uri.

您也可以通过 API 完成最后一步.

You could do last step also by API.

这篇关于BigQuery:加载excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！