Parse CSV in Google Spreadsheets
0
I'm trying to automatically parse a CSV document into separate cells in Google Spreadsheets. I'm using the script below, however, it just presents the , separated value, whereas, I need those values appear in individual cells. Any ideas?
function importCSVFromWeb() {
var csvUrl = "https://ctrlq.org/data.csv";
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();
var csvData = Utilities.parseCsv(csvContent);
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
google-apps-script google-sheets
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
add a comment |
0
I'm trying to automatically parse a CSV document into separate cells in Google Spreadsheets. I'm using the script below, however, it just presents the , separated value, whereas, I need those values appear in individual cells. Any ideas?
function importCSVFromWeb() {
var csvUrl = "https://ctrlq.org/data.csv";
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();
var csvData = Utilities.parseCsv(csvContent);
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
google-apps-script google-sheets
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
3
Welcome to Stack Overflow. Consider editing your question. Avoid unnecessary bolding your text and post your code here instead of a link to an image. stackoverflow.com/help/how-to-ask
– ETO
Nov 22 '18 at 22:54
1
add code as text, not as image
– barbsan
Nov 23 '18 at 10:40
@barbsan thanks for the tip. Done. Would you know how the problem I described can be solved?
– Renat Ishmukhamedov
Nov 28 '18 at 14:20
Have you tried passing delimiter? LikeUtilities.parseCsv(csvContent, ",");
– barbsan
Nov 28 '18 at 14:24
@RenatIshmukhamedov I've run your code and it works perfectly. The problem is probably in your csv file, and you need to share it, or a sample of it, so we can understand the layout and any issues. I'm assuming that you are NOT using thecsvUrlabove, because it doesn't exist.
– Tedinoz
Dec 6 '18 at 3:41
add a comment |
0
0
0
I'm trying to automatically parse a CSV document into separate cells in Google Spreadsheets. I'm using the script below, however, it just presents the , separated value, whereas, I need those values appear in individual cells. Any ideas?
function importCSVFromWeb() {
var csvUrl = "https://ctrlq.org/data.csv";
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();
var csvData = Utilities.parseCsv(csvContent);
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
google-apps-script google-sheets
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
I'm trying to automatically parse a CSV document into separate cells in Google Spreadsheets. I'm using the script below, however, it just presents the , separated value, whereas, I need those values appear in individual cells. Any ideas?
function importCSVFromWeb() {
var csvUrl = "https://ctrlq.org/data.csv";
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();
var csvData = Utilities.parseCsv(csvContent);
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
google-apps-script google-sheets
google-apps-script google-sheets
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
edited Nov 28 '18 at 14:19
Renat Ishmukhamedov
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
asked Nov 22 '18 at 21:58
Renat IshmukhamedovRenat Ishmukhamedov
11
11
3
Welcome to Stack Overflow. Consider editing your question. Avoid unnecessary bolding your text and post your code here instead of a link to an image. stackoverflow.com/help/how-to-ask
– ETO
Nov 22 '18 at 22:54
1
add code as text, not as image
– barbsan
Nov 23 '18 at 10:40
@barbsan thanks for the tip. Done. Would you know how the problem I described can be solved?
– Renat Ishmukhamedov
Nov 28 '18 at 14:20
Have you tried passing delimiter? LikeUtilities.parseCsv(csvContent, ",");
– barbsan
Nov 28 '18 at 14:24
@RenatIshmukhamedov I've run your code and it works perfectly. The problem is probably in your csv file, and you need to share it, or a sample of it, so we can understand the layout and any issues. I'm assuming that you are NOT using thecsvUrlabove, because it doesn't exist.
– Tedinoz
Dec 6 '18 at 3:41
add a comment |
3
Welcome to Stack Overflow. Consider editing your question. Avoid unnecessary bolding your text and post your code here instead of a link to an image. stackoverflow.com/help/how-to-ask
– ETO
Nov 22 '18 at 22:54
1
add code as text, not as image
– barbsan
Nov 23 '18 at 10:40
@barbsan thanks for the tip. Done. Would you know how the problem I described can be solved?
– Renat Ishmukhamedov
Nov 28 '18 at 14:20
Have you tried passing delimiter? LikeUtilities.parseCsv(csvContent, ",");
– barbsan
Nov 28 '18 at 14:24
@RenatIshmukhamedov I've run your code and it works perfectly. The problem is probably in your csv file, and you need to share it, or a sample of it, so we can understand the layout and any issues. I'm assuming that you are NOT using thecsvUrlabove, because it doesn't exist.
– Tedinoz
Dec 6 '18 at 3:41
3
3
Welcome to Stack Overflow. Consider editing your question. Avoid unnecessary bolding your text and post your code here instead of a link to an image. stackoverflow.com/help/how-to-ask
– ETO
Nov 22 '18 at 22:54
Welcome to Stack Overflow. Consider editing your question. Avoid unnecessary bolding your text and post your code here instead of a link to an image. stackoverflow.com/help/how-to-ask
– ETO
Nov 22 '18 at 22:54
1
1
add code as text, not as image
– barbsan
Nov 23 '18 at 10:40
add code as text, not as image
– barbsan
Nov 23 '18 at 10:40
@barbsan thanks for the tip. Done. Would you know how the problem I described can be solved?
– Renat Ishmukhamedov
Nov 28 '18 at 14:20
@barbsan thanks for the tip. Done. Would you know how the problem I described can be solved?
– Renat Ishmukhamedov
Nov 28 '18 at 14:20
Have you tried passing delimiter? Like
Utilities.parseCsv(csvContent, ",");– barbsan
Nov 28 '18 at 14:24
Have you tried passing delimiter? Like
Utilities.parseCsv(csvContent, ",");– barbsan
Nov 28 '18 at 14:24
@RenatIshmukhamedov I've run your code and it works perfectly. The problem is probably in your csv file, and you need to share it, or a sample of it, so we can understand the layout and any issues. I'm assuming that you are NOT using the
csvUrl above, because it doesn't exist.– Tedinoz
Dec 6 '18 at 3:41
@RenatIshmukhamedov I've run your code and it works perfectly. The problem is probably in your csv file, and you need to share it, or a sample of it, so we can understand the layout and any issues. I'm assuming that you are NOT using the
csvUrl above, because it doesn't exist.– Tedinoz
Dec 6 '18 at 3:41
add a comment |
0
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
});
}
});
draft saved
draft discarded
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%2f53438406%2fparse-csv-in-google-spreadsheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53438406%2fparse-csv-in-google-spreadsheets%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
3
Welcome to Stack Overflow. Consider editing your question. Avoid unnecessary bolding your text and post your code here instead of a link to an image. stackoverflow.com/help/how-to-ask
– ETO
Nov 22 '18 at 22:54
1
add code as text, not as image
– barbsan
Nov 23 '18 at 10:40
@barbsan thanks for the tip. Done. Would you know how the problem I described can be solved?
– Renat Ishmukhamedov
Nov 28 '18 at 14:20
Have you tried passing delimiter? Like
Utilities.parseCsv(csvContent, ",");– barbsan
Nov 28 '18 at 14:24
@RenatIshmukhamedov I've run your code and it works perfectly. The problem is probably in your csv file, and you need to share it, or a sample of it, so we can understand the layout and any issues. I'm assuming that you are NOT using the
csvUrlabove, because it doesn't exist.– Tedinoz
Dec 6 '18 at 3:41