Google Sheets exporting CSV with UTF8 encoding via URL
I have a Google App Script in a spreadsheet. It constructs a URL to download one of the sheets in the spreadsheet as a CSV file, then presents it to the user. An example output URL may look like this:
https://docs.google.com/spreadsheets/d/<spreadsheet ID>/export?format=csv&id=<spreadsheet ID>&gid=<sheet ID>
The resulting URL works fine, but the CSV is encoded in us-ascii. I'd like to be able to encode the CSV as utf-8. Is this possible? Is there some documentation I've missed?
javascript csv
google-apps-script google-sheets edited Nov 22 at 19:37
Federico Grandi
2,64521127
asked Nov 22 at 18:41
Simon
14
add a comment |
I have a Google App Script in a spreadsheet. It constructs a URL to download one of the sheets in the spreadsheet as a CSV file, then presents it to the user. An example output URL may look like this:
https://docs.google.com/spreadsheets/d/<spreadsheet ID>/export?format=csv&id=<spreadsheet ID>&gid=<sheet ID>
The resulting URL works fine, but the CSV is encoded in us-ascii. I'd like to be able to encode the CSV as utf-8. Is this possible? Is there some documentation I've missed?
javascript csv
google-apps-script google-sheets edited Nov 22 at 19:37
Federico Grandi
2,64521127
asked Nov 22 at 18:41
Simon
14
Possible duplicate Google Spreadsheets CSV Encoding not UTF-8?. Read the links regarding Q&A on Super User regarding the "real problem". Reuben also posted an answer for how to "fix" the problem when importing into Excel. FWIW, you could try "Publish to Web", "Link"; choose only the sheet that you want to export, choose comma-separated values, copy the url. FWIW, the format of the URL is entirely different from the style that you described. My text editor says UTF-8.
– Tedinoz
Dec 6 at 4:34
add a comment |
I have a Google App Script in a spreadsheet. It constructs a URL to download one of the sheets in the spreadsheet as a CSV file, then presents it to the user. An example output URL may look like this:
https://docs.google.com/spreadsheets/d/<spreadsheet ID>/export?format=csv&id=<spreadsheet ID>&gid=<sheet ID>
The resulting URL works fine, but the CSV is encoded in us-ascii. I'd like to be able to encode the CSV as utf-8. Is this possible? Is there some documentation I've missed?
javascript csv
google-apps-script google-sheets edited Nov 22 at 19:37
Federico Grandi
2,64521127
asked Nov 22 at 18:41
Simon
14
I have a Google App Script in a spreadsheet. It constructs a URL to download one of the sheets in the spreadsheet as a CSV file, then presents it to the user. An example output URL may look like this:
https://docs.google.com/spreadsheets/d/<spreadsheet ID>/export?format=csv&id=<spreadsheet ID>&gid=<sheet ID>
The resulting URL works fine, but the CSV is encoded in us-ascii. I'd like to be able to encode the CSV as utf-8. Is this possible? Is there some documentation I've missed?
javascript csv
google-apps-script google-sheets javascript csv
google-apps-script google-sheets edited Nov 22 at 19:37
Federico Grandi
2,64521127
asked Nov 22 at 18:41
Simon
14
edited Nov 22 at 19:37
Federico Grandi
2,64521127
asked Nov 22 at 18:41
Simon
14
edited Nov 22 at 19:37
Federico Grandi
2,64521127
edited Nov 22 at 19:37
Federico Grandi
2,64521127
edited Nov 22 at 19:37
Federico Grandi
2,64521127
2,64521127
asked Nov 22 at 18:41
Simon
14
asked Nov 22 at 18:41
Simon
14
asked Nov 22 at 18:41
Simon
14
14
Possible duplicate Google Spreadsheets CSV Encoding not UTF-8?. Read the links regarding Q&A on Super User regarding the "real problem". Reuben also posted an answer for how to "fix" the problem when importing into Excel. FWIW, you could try "Publish to Web", "Link"; choose only the sheet that you want to export, choose comma-separated values, copy the url. FWIW, the format of the URL is entirely different from the style that you described. My text editor says UTF-8.
– Tedinoz
Dec 6 at 4:34
add a comment |
Possible duplicate Google Spreadsheets CSV Encoding not UTF-8?. Read the links regarding Q&A on Super User regarding the "real problem". Reuben also posted an answer for how to "fix" the problem when importing into Excel. FWIW, you could try "Publish to Web", "Link"; choose only the sheet that you want to export, choose comma-separated values, copy the url. FWIW, the format of the URL is entirely different from the style that you described. My text editor says UTF-8.
– Tedinoz
Dec 6 at 4:34
Possible duplicate Google Spreadsheets CSV Encoding not UTF-8?. Read the links regarding Q&A on Super User regarding the "real problem". Reuben also posted an answer for how to "fix" the problem when importing into Excel. FWIW, you could try "Publish to Web", "Link"; choose only the sheet that you want to export, choose comma-separated values, copy the url. FWIW, the format of the URL is entirely different from the style that you described. My text editor says UTF-8.
– Tedinoz
Dec 6 at 4:34
Possible duplicate Google Spreadsheets CSV Encoding not UTF-8?. Read the links regarding Q&A on Super User regarding the "real problem". Reuben also posted an answer for how to "fix" the problem when importing into Excel. FWIW, you could try "Publish to Web", "Link"; choose only the sheet that you want to export, choose comma-separated values, copy the url. FWIW, the format of the URL is entirely different from the style that you described. My text editor says UTF-8.
– Tedinoz
Dec 6 at 4:34
add a comment |
active
oldest
votes
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',
autoActivateHeartbeat: false,
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53436614%2fgoogle-sheets-exporting-csv-with-utf8-encoding-via-url%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53436614%2fgoogle-sheets-exporting-csv-with-utf8-encoding-via-url%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Possible duplicate Google Spreadsheets CSV Encoding not UTF-8?. Read the links regarding Q&A on Super User regarding the "real problem". Reuben also posted an answer for how to "fix" the problem when importing into Excel. FWIW, you could try "Publish to Web", "Link"; choose only the sheet that you want to export, choose comma-separated values, copy the url. FWIW, the format of the URL is entirely different from the style that you described. My text editor says UTF-8.
– Tedinoz
Dec 6 at 4:34