Is there any way to generate Microsft Excel from Bigquery result using Google appscript?

up vote
-2
down vote

favorite

I want to export data from bigquery to ms excel using appscript as google spreadsheet has only 10 million cell limitation. Is there any way to do it?

asked Nov 9 at 3:44

Sourav Chatterjee

196

add a comment |

up vote
-2
down vote

favorite

I want to export data from bigquery to ms excel using appscript as google spreadsheet has only 10 million cell limitation. Is there any way to do it?

asked Nov 9 at 3:44

Sourav Chatterjee

196

add a comment |

up vote
-2
down vote

favorite

I want to export data from bigquery to ms excel using appscript as google spreadsheet has only 10 million cell limitation. Is there any way to do it?

asked Nov 9 at 3:44

Sourav Chatterjee

196

I want to export data from bigquery to ms excel using appscript as google spreadsheet has only 10 million cell limitation. Is there any way to do it?

excel google-bigquery appscript

asked Nov 9 at 3:44

Sourav Chatterjee

196

asked Nov 9 at 3:44

Sourav Chatterjee

196

asked Nov 9 at 3:44

Sourav Chatterjee

196

asked Nov 9 at 3:44

Sourav Chatterjee

196

asked Nov 9 at 3:44

Sourav Chatterjee

196

add a comment |

1 Answer
1

active

oldest

votes

up vote
1
down vote

You could export the table data into CSV (however, you could only export the data to Google Cloud Storage): https://cloud.google.com/bigquery/docs/exporting-data

Then, you could download the data from GCS to your local machine. Here is a post about how that can be done: Downloading table data as CSV to local machine in Big query

answered Nov 10 at 22:15

Ng Leo

112

CSV is not an option to me.. I simply need XLSX
– Sourav Chatterjee
Nov 15 at 12:48

Then, you could just open the CSV in Excel and save it as xlsx.
– Ng Leo
Nov 16 at 13:39

opening csv in excel changes data like '000445' to '45'. I know we can change it by changing the datatype but is there any automated version of that?
– Sourav Chatterjee
Nov 19 at 7:22

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53219558%2fis-there-any-way-to-generate-microsft-excel-from-bigquery-result-using-google-ap%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
1
down vote

You could export the table data into CSV (however, you could only export the data to Google Cloud Storage): https://cloud.google.com/bigquery/docs/exporting-data

Then, you could download the data from GCS to your local machine. Here is a post about how that can be done: Downloading table data as CSV to local machine in Big query

answered Nov 10 at 22:15

Ng Leo

112

CSV is not an option to me.. I simply need XLSX
– Sourav Chatterjee
Nov 15 at 12:48

Then, you could just open the CSV in Excel and save it as xlsx.
– Ng Leo
Nov 16 at 13:39

opening csv in excel changes data like '000445' to '45'. I know we can change it by changing the datatype but is there any automated version of that?
– Sourav Chatterjee
Nov 19 at 7:22

add a comment |

up vote
1
down vote

You could export the table data into CSV (however, you could only export the data to Google Cloud Storage): https://cloud.google.com/bigquery/docs/exporting-data

Then, you could download the data from GCS to your local machine. Here is a post about how that can be done: Downloading table data as CSV to local machine in Big query

answered Nov 10 at 22:15

Ng Leo

112

CSV is not an option to me.. I simply need XLSX
– Sourav Chatterjee
Nov 15 at 12:48

Then, you could just open the CSV in Excel and save it as xlsx.
– Ng Leo
Nov 16 at 13:39

opening csv in excel changes data like '000445' to '45'. I know we can change it by changing the datatype but is there any automated version of that?
– Sourav Chatterjee
Nov 19 at 7:22

add a comment |

up vote
1
down vote

You could export the table data into CSV (however, you could only export the data to Google Cloud Storage): https://cloud.google.com/bigquery/docs/exporting-data

Then, you could download the data from GCS to your local machine. Here is a post about how that can be done: Downloading table data as CSV to local machine in Big query

answered Nov 10 at 22:15

Ng Leo

112

You could export the table data into CSV (however, you could only export the data to Google Cloud Storage): https://cloud.google.com/bigquery/docs/exporting-data

Then, you could download the data from GCS to your local machine. Here is a post about how that can be done: Downloading table data as CSV to local machine in Big query

answered Nov 10 at 22:15

Ng Leo

112

answered Nov 10 at 22:15

Ng Leo

112

answered Nov 10 at 22:15

Ng Leo

112

answered Nov 10 at 22:15

Ng Leo

112

CSV is not an option to me.. I simply need XLSX
– Sourav Chatterjee
Nov 15 at 12:48

Then, you could just open the CSV in Excel and save it as xlsx.
– Ng Leo
Nov 16 at 13:39

opening csv in excel changes data like '000445' to '45'. I know we can change it by changing the datatype but is there any automated version of that?
– Sourav Chatterjee
Nov 19 at 7:22

add a comment |

CSV is not an option to me.. I simply need XLSX
– Sourav Chatterjee
Nov 15 at 12:48

Then, you could just open the CSV in Excel and save it as xlsx.
– Ng Leo
Nov 16 at 13:39

opening csv in excel changes data like '000445' to '45'. I know we can change it by changing the datatype but is there any automated version of that?
– Sourav Chatterjee
Nov 19 at 7:22

CSV is not an option to me.. I simply need XLSX
– Sourav Chatterjee
Nov 15 at 12:48

Then, you could just open the CSV in Excel and save it as xlsx.
– Ng Leo
Nov 16 at 13:39

opening csv in excel changes data like '000445' to '45'. I know we can change it by changing the datatype but is there any automated version of that?
– Sourav Chatterjee
Nov 19 at 7:22

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Xtykutl