Google Sheets IMPORTHTML parse error
I want to use the IMPORTHTML function of Google Spreadsheets.
There is this example by Google itself:
=IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)
Unfortunately (like all the other examples that I tried), it gives me a parsing error.
I tried some stuff (I am a coder myself) but could not fix it. When I try the exact same line of code on a friends computer it works.
What am I missing here?
My only Idea would be that Google gives me a new Version of Spreadsheets (just like we are all using different Versions of Facebook without noticing). And on this Version i am running on importHTML does not work.
Would be amazing if someone can help me with this!
google-sheets formulas syntax
edited Jan 10 at 10:47
serenesat
8,80592142
migrated from superuser.com Jan 9 at 15:41
This question came from our site for computer enthusiasts and power users.
add a comment |
I want to use the IMPORTHTML function of Google Spreadsheets.
There is this example by Google itself:
=IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)
Unfortunately (like all the other examples that I tried), it gives me a parsing error.
I tried some stuff (I am a coder myself) but could not fix it. When I try the exact same line of code on a friends computer it works.
What am I missing here?
My only Idea would be that Google gives me a new Version of Spreadsheets (just like we are all using different Versions of Facebook without noticing). And on this Version i am running on importHTML does not work.
Would be amazing if someone can help me with this!
google-sheets formulas syntax
edited Jan 10 at 10:47
serenesat
8,80592142
migrated from superuser.com Jan 9 at 15:41
This question came from our site for computer enthusiasts and power users.
add a comment |
I want to use the IMPORTHTML function of Google Spreadsheets.
There is this example by Google itself:
=IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)
Unfortunately (like all the other examples that I tried), it gives me a parsing error.
I tried some stuff (I am a coder myself) but could not fix it. When I try the exact same line of code on a friends computer it works.
What am I missing here?
My only Idea would be that Google gives me a new Version of Spreadsheets (just like we are all using different Versions of Facebook without noticing). And on this Version i am running on importHTML does not work.
Would be amazing if someone can help me with this!
google-sheets formulas syntax
edited Jan 10 at 10:47
serenesat
8,80592142
I want to use the IMPORTHTML function of Google Spreadsheets.
There is this example by Google itself:
=IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)
Unfortunately (like all the other examples that I tried), it gives me a parsing error.
I tried some stuff (I am a coder myself) but could not fix it. When I try the exact same line of code on a friends computer it works.
What am I missing here?
My only Idea would be that Google gives me a new Version of Spreadsheets (just like we are all using different Versions of Facebook without noticing). And on this Version i am running on importHTML does not work.
Would be amazing if someone can help me with this!
google-sheets formulas syntax
google-sheets formulas syntax
edited Jan 10 at 10:47
serenesat
8,80592142
edited Jan 10 at 10:47
serenesat
8,80592142
edited Jan 10 at 10:47
serenesat
8,80592142
edited Jan 10 at 10:47
serenesat
8,80592142
edited Jan 10 at 10:47
serenesat
8,80592142
8,80592142
asked Jan 9 at 14:19
sparrow303
migrated from superuser.com Jan 9 at 15:41
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Jan 9 at 15:41
This question came from our site for computer enthusiasts and power users.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Looks like your issue is not IMPORTHTML() parse error, but local language setting of your Google Spreadsheet. There are two versions:
- United States version (includes Australia)
- Europe version (pretty much the "rest of the world" version)
Each version has own syntax for formulas:
US:=IF(A1 = "x", "yes", "no")
EU:=IF(A1 = "x"; "yes"; "no")
While (in most cases - not all cases) US version is able to instantly convert to EU syntax, EU sheet is not able to do so. Language settings can be changed in File > Spreadsheet settings... > General > Locale
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "34"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
},
noCode: 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%2fwebapps.stackexchange.com%2fquestions%2f123879%2fgoogle-sheets-importhtml-parse-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Looks like your issue is not IMPORTHTML() parse error, but local language setting of your Google Spreadsheet. There are two versions:
- United States version (includes Australia)
- Europe version (pretty much the "rest of the world" version)
Each version has own syntax for formulas:
US:=IF(A1 = "x", "yes", "no")
EU:=IF(A1 = "x"; "yes"; "no")
While (in most cases - not all cases) US version is able to instantly convert to EU syntax, EU sheet is not able to do so. Language settings can be changed in File > Spreadsheet settings... > General > Locale
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
add a comment |
Looks like your issue is not IMPORTHTML() parse error, but local language setting of your Google Spreadsheet. There are two versions:
- United States version (includes Australia)
- Europe version (pretty much the "rest of the world" version)
Each version has own syntax for formulas:
US:=IF(A1 = "x", "yes", "no")
EU:=IF(A1 = "x"; "yes"; "no")
While (in most cases - not all cases) US version is able to instantly convert to EU syntax, EU sheet is not able to do so. Language settings can be changed in File > Spreadsheet settings... > General > Locale
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
add a comment |
Looks like your issue is not IMPORTHTML() parse error, but local language setting of your Google Spreadsheet. There are two versions:
- United States version (includes Australia)
- Europe version (pretty much the "rest of the world" version)
Each version has own syntax for formulas:
US:=IF(A1 = "x", "yes", "no")
EU:=IF(A1 = "x"; "yes"; "no")
While (in most cases - not all cases) US version is able to instantly convert to EU syntax, EU sheet is not able to do so. Language settings can be changed in File > Spreadsheet settings... > General > Locale
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
Looks like your issue is not IMPORTHTML() parse error, but local language setting of your Google Spreadsheet. There are two versions:
- United States version (includes Australia)
- Europe version (pretty much the "rest of the world" version)
Each version has own syntax for formulas:
US:=IF(A1 = "x", "yes", "no")
EU:=IF(A1 = "x"; "yes"; "no")
While (in most cases - not all cases) US version is able to instantly convert to EU syntax, EU sheet is not able to do so. Language settings can be changed in File > Spreadsheet settings... > General > Locale
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
answered Jan 9 at 19:49
MARK MY ANSWERMARK MY ANSWER
6,52341229
6,52341229
add a comment |
add a comment |
Thanks for contributing an answer to Web Applications Stack Exchange!
- 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%2fwebapps.stackexchange.com%2fquestions%2f123879%2fgoogle-sheets-importhtml-parse-error%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
