Problem with scraping data from the web. How to use XPath in Google Sheets correctly?
I am trying to create monitoring table where tracking number of the parcel from one cell concatenates with the tracking website URL and imports current status.
On another site I use such construction and it works:
=IMPORTXML(CONCATENATE("https://site.url/tracking/?cargo_number=",A2), "//div[@class='status']")
But it is not working on this site: https://t.17track.net/en#nums=RP033693154CN
I tried to use the whole XPath by copying it from Google developer Tools:
/html/body/main/div/article/div[2]/div[1]/div/div/div[2]/div[2]/div[1]/dl[1]/dd[1]/div/p
Also I tried to use the and of the Xpath tail like in the first example but it response #N/A anyway.
I need to get such a response in one cell:
2018-10-13 17:05
and in another:
UKRAINE, KYIV 232, Attempted/Unsuccessful (physical) delivery : other reasons
Or at least the latest status.
By the way, I was trying to use "Copy XPath" function from Developer Tools in Google Sheets and it never worked without additional modification. What is the reason?
xpath web-scraping google-sheets xml-parsing
asked Oct 22 '18 at 18:21
YuriYuri
207
add a comment |
I am trying to create monitoring table where tracking number of the parcel from one cell concatenates with the tracking website URL and imports current status.
On another site I use such construction and it works:
=IMPORTXML(CONCATENATE("https://site.url/tracking/?cargo_number=",A2), "//div[@class='status']")
But it is not working on this site: https://t.17track.net/en#nums=RP033693154CN
I tried to use the whole XPath by copying it from Google developer Tools:
/html/body/main/div/article/div[2]/div[1]/div/div/div[2]/div[2]/div[1]/dl[1]/dd[1]/div/p
Also I tried to use the and of the Xpath tail like in the first example but it response #N/A anyway.
I need to get such a response in one cell:
2018-10-13 17:05
and in another:
UKRAINE, KYIV 232, Attempted/Unsuccessful (physical) delivery : other reasons
Or at least the latest status.
By the way, I was trying to use "Copy XPath" function from Developer Tools in Google Sheets and it never worked without additional modification. What is the reason?
xpath web-scraping google-sheets xml-parsing
asked Oct 22 '18 at 18:21
YuriYuri
207
add a comment |
I am trying to create monitoring table where tracking number of the parcel from one cell concatenates with the tracking website URL and imports current status.
On another site I use such construction and it works:
=IMPORTXML(CONCATENATE("https://site.url/tracking/?cargo_number=",A2), "//div[@class='status']")
But it is not working on this site: https://t.17track.net/en#nums=RP033693154CN
I tried to use the whole XPath by copying it from Google developer Tools:
/html/body/main/div/article/div[2]/div[1]/div/div/div[2]/div[2]/div[1]/dl[1]/dd[1]/div/p
Also I tried to use the and of the Xpath tail like in the first example but it response #N/A anyway.
I need to get such a response in one cell:
2018-10-13 17:05
and in another:
UKRAINE, KYIV 232, Attempted/Unsuccessful (physical) delivery : other reasons
Or at least the latest status.
By the way, I was trying to use "Copy XPath" function from Developer Tools in Google Sheets and it never worked without additional modification. What is the reason?
xpath web-scraping google-sheets xml-parsing
asked Oct 22 '18 at 18:21
YuriYuri
207
I am trying to create monitoring table where tracking number of the parcel from one cell concatenates with the tracking website URL and imports current status.
On another site I use such construction and it works:
=IMPORTXML(CONCATENATE("https://site.url/tracking/?cargo_number=",A2), "//div[@class='status']")
But it is not working on this site: https://t.17track.net/en#nums=RP033693154CN
I tried to use the whole XPath by copying it from Google developer Tools:
/html/body/main/div/article/div[2]/div[1]/div/div/div[2]/div[2]/div[1]/dl[1]/dd[1]/div/p
Also I tried to use the and of the Xpath tail like in the first example but it response #N/A anyway.
I need to get such a response in one cell:
2018-10-13 17:05
and in another:
UKRAINE, KYIV 232, Attempted/Unsuccessful (physical) delivery : other reasons
Or at least the latest status.
By the way, I was trying to use "Copy XPath" function from Developer Tools in Google Sheets and it never worked without additional modification. What is the reason?
xpath web-scraping google-sheets xml-parsing
xpath web-scraping google-sheets xml-parsing
asked Oct 22 '18 at 18:21
YuriYuri
207
asked Oct 22 '18 at 18:21
YuriYuri
207
asked Oct 22 '18 at 18:21
YuriYuri
207
asked Oct 22 '18 at 18:21
YuriYuri
207
asked Oct 22 '18 at 18:21
YuriYuri
207
207
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You may want to look into Xpath Finder and Xpath Helper. They are extensions on Chrome which can help when writing Xpaths. Some Xpaths don't work. You have to write them yourself. It sounds like you may want to check out Vlookup on Google Sheets/Excel, too. Good luck!
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
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%2f52935500%2fproblem-with-scraping-data-from-the-web-how-to-use-xpath-in-google-sheets-corre%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
You may want to look into Xpath Finder and Xpath Helper. They are extensions on Chrome which can help when writing Xpaths. Some Xpaths don't work. You have to write them yourself. It sounds like you may want to check out Vlookup on Google Sheets/Excel, too. Good luck!
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
add a comment |
You may want to look into Xpath Finder and Xpath Helper. They are extensions on Chrome which can help when writing Xpaths. Some Xpaths don't work. You have to write them yourself. It sounds like you may want to check out Vlookup on Google Sheets/Excel, too. Good luck!
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
add a comment |
You may want to look into Xpath Finder and Xpath Helper. They are extensions on Chrome which can help when writing Xpaths. Some Xpaths don't work. You have to write them yourself. It sounds like you may want to check out Vlookup on Google Sheets/Excel, too. Good luck!
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
You may want to look into Xpath Finder and Xpath Helper. They are extensions on Chrome which can help when writing Xpaths. Some Xpaths don't work. You have to write them yourself. It sounds like you may want to check out Vlookup on Google Sheets/Excel, too. Good luck!
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
answered Nov 12 '18 at 21:11
Able ArcherAble Archer
968
968
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.
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%2f52935500%2fproblem-with-scraping-data-from-the-web-how-to-use-xpath-in-google-sheets-corre%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
