Google Sheets ImportHTML can't find table?2019 Community Moderator ElectionUse importhtml in Google SheetExtract href in table with importxml in Google spreadsheetHow Can I Use ImportHTML to Fetch My Modem's Stats Webpage?importing website to google sheetsData Scraping With ImportHTML in Apps Script & Google SheetsIMPORTHTML - Error, Imported content is emptyIMPORTHTML function on google sheetsCan't import HTML table into Google Sheetaccessing XHR within google sheetsGoogle sheets importhtml xpath
Is "inadequate referencing" a euphemism for plagiarism?
The English Debate
Do I need an EFI partition for each 18.04 ubuntu I have on my HD?
Are hand made posters acceptable in Academia?
Why is "la Gestapo" feminine?
Why doesn't the fusion process of the sun speed up?
Knife as defense against stray dogs
What is the reasoning behind standardization (dividing by standard deviation)?
Norwegian Refugee travel document
TDE Master Key Rotation
Should a narrator ever describe things based on a characters view instead of fact?
is this saw blade faulty?
Is there any common country to visit for uk and schengen visa?
Does convergence of polynomials imply that of its coefficients?
Unfrosted light bulb
Print last inputted byte
Do native speakers use "ultima" and "proxima" frequently in spoken English?
When did hardware antialiasing start being available?
Why didn’t Eve recognize the little cockroach as a living organism?
Is this Pascal's Matrix?
How do you justify more code being written by following clean code practices?
Extraneous elements in "Europe countries" list
Pre-Employment Background Check With Consent For Future Checks
Writing in a Christian voice
Google Sheets ImportHTML can't find table?
2019 Community Moderator ElectionUse importhtml in Google SheetExtract href in table with importxml in Google spreadsheetHow Can I Use ImportHTML to Fetch My Modem's Stats Webpage?importing website to google sheetsData Scraping With ImportHTML in Apps Script & Google SheetsIMPORTHTML - Error, Imported content is emptyIMPORTHTML function on google sheetsCan't import HTML table into Google Sheetaccessing XHR within google sheetsGoogle sheets importhtml xpath
I've used ImportHTML plenty of times before and never really had any issues with it, but for some reason, I can't seem to pull a particular table from Basketball-Reference, even though I've pulled other tables from there just fine. The table I want is the Miscellaneous Stats table lower down on this page. I've tried every index from 1 to 30 in the function, but none of them past 7 bring in any data. The function I'm using is below, with the 1 changing to whatever index I'm trying:
=IMPORTHTML("https://www.basketball-reference.com/leagues/NBA_2019.html", "table", 1)
I tried using the following code in Chrome's console to find the index of the page, but it didn't return anything:
var i = 1; [].forEach.call(document.getElementsByTagName("table"), function(x) console.log(i++, x); );
Does anyone know how I can get this table working with ImportHTML?
google-sheets
edited Mar 7 at 0:09
player0
5,55841232
asked Mar 6 at 23:23
Ryan GRyan G
133
add a comment |
I've used ImportHTML plenty of times before and never really had any issues with it, but for some reason, I can't seem to pull a particular table from Basketball-Reference, even though I've pulled other tables from there just fine. The table I want is the Miscellaneous Stats table lower down on this page. I've tried every index from 1 to 30 in the function, but none of them past 7 bring in any data. The function I'm using is below, with the 1 changing to whatever index I'm trying:
=IMPORTHTML("https://www.basketball-reference.com/leagues/NBA_2019.html", "table", 1)
I tried using the following code in Chrome's console to find the index of the page, but it didn't return anything:
var i = 1; [].forEach.call(document.getElementsByTagName("table"), function(x) console.log(i++, x); );
Does anyone know how I can get this table working with ImportHTML?
google-sheets
edited Mar 7 at 0:09
player0
5,55841232
asked Mar 6 at 23:23
Ryan GRyan G
133
add a comment |
I've used ImportHTML plenty of times before and never really had any issues with it, but for some reason, I can't seem to pull a particular table from Basketball-Reference, even though I've pulled other tables from there just fine. The table I want is the Miscellaneous Stats table lower down on this page. I've tried every index from 1 to 30 in the function, but none of them past 7 bring in any data. The function I'm using is below, with the 1 changing to whatever index I'm trying:
=IMPORTHTML("https://www.basketball-reference.com/leagues/NBA_2019.html", "table", 1)
I tried using the following code in Chrome's console to find the index of the page, but it didn't return anything:
var i = 1; [].forEach.call(document.getElementsByTagName("table"), function(x) console.log(i++, x); );
Does anyone know how I can get this table working with ImportHTML?
google-sheets
edited Mar 7 at 0:09
player0
5,55841232
asked Mar 6 at 23:23
Ryan GRyan G
133
I've used ImportHTML plenty of times before and never really had any issues with it, but for some reason, I can't seem to pull a particular table from Basketball-Reference, even though I've pulled other tables from there just fine. The table I want is the Miscellaneous Stats table lower down on this page. I've tried every index from 1 to 30 in the function, but none of them past 7 bring in any data. The function I'm using is below, with the 1 changing to whatever index I'm trying:
=IMPORTHTML("https://www.basketball-reference.com/leagues/NBA_2019.html", "table", 1)
I tried using the following code in Chrome's console to find the index of the page, but it didn't return anything:
var i = 1; [].forEach.call(document.getElementsByTagName("table"), function(x) console.log(i++, x); );
Does anyone know how I can get this table working with ImportHTML?
google-sheets
google-sheets
edited Mar 7 at 0:09
player0
5,55841232
asked Mar 6 at 23:23
Ryan GRyan G
133
edited Mar 7 at 0:09
player0
5,55841232
asked Mar 6 at 23:23
Ryan GRyan G
133
edited Mar 7 at 0:09
player0
5,55841232
edited Mar 7 at 0:09
player0
5,55841232
edited Mar 7 at 0:09
player0
5,55841232
5,55841232
asked Mar 6 at 23:23
Ryan GRyan G
133
asked Mar 6 at 23:23
Ryan GRyan G
133
asked Mar 6 at 23:23
Ryan GRyan G
133
133
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
not possible. the table you want to scrape is injected/dependant on JavaScript. by disabling JS you can see that only this can be scraped:
answered Mar 7 at 0:08
player0player0
5,55841232
add a comment |
Well, player0 was correct about being unable to scrape the JS table, but luckily I was able to use the URL for the embed version of that table, which works perfectly with ImportHTML.
answered Mar 7 at 16:26
Ryan GRyan G
133
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',
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%2f55033771%2fgoogle-sheets-importhtml-cant-find-table%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
not possible. the table you want to scrape is injected/dependant on JavaScript. by disabling JS you can see that only this can be scraped:
answered Mar 7 at 0:08
player0player0
5,55841232
add a comment |
not possible. the table you want to scrape is injected/dependant on JavaScript. by disabling JS you can see that only this can be scraped:
answered Mar 7 at 0:08
player0player0
5,55841232
add a comment |
not possible. the table you want to scrape is injected/dependant on JavaScript. by disabling JS you can see that only this can be scraped:
answered Mar 7 at 0:08
player0player0
5,55841232
not possible. the table you want to scrape is injected/dependant on JavaScript. by disabling JS you can see that only this can be scraped:
answered Mar 7 at 0:08
player0player0
5,55841232
answered Mar 7 at 0:08
player0player0
5,55841232
answered Mar 7 at 0:08
player0player0
5,55841232
answered Mar 7 at 0:08
player0player0
5,55841232
5,55841232
add a comment |
add a comment |
Well, player0 was correct about being unable to scrape the JS table, but luckily I was able to use the URL for the embed version of that table, which works perfectly with ImportHTML.
answered Mar 7 at 16:26
Ryan GRyan G
133
add a comment |
Well, player0 was correct about being unable to scrape the JS table, but luckily I was able to use the URL for the embed version of that table, which works perfectly with ImportHTML.
answered Mar 7 at 16:26
Ryan GRyan G
133
add a comment |
Well, player0 was correct about being unable to scrape the JS table, but luckily I was able to use the URL for the embed version of that table, which works perfectly with ImportHTML.
answered Mar 7 at 16:26
Ryan GRyan G
133
Well, player0 was correct about being unable to scrape the JS table, but luckily I was able to use the URL for the embed version of that table, which works perfectly with ImportHTML.
answered Mar 7 at 16:26
Ryan GRyan G
133
answered Mar 7 at 16:26
Ryan GRyan G
133
answered Mar 7 at 16:26
Ryan GRyan G
133
answered Mar 7 at 16:26
Ryan GRyan G
133
133
add a comment |
add a comment |
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.
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%2f55033771%2fgoogle-sheets-importhtml-cant-find-table%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
