When importing data from web page using Excel, hyperlinks are lost. How to solve this?
When using the Data menu item in Excel to import data from web to spreadsheet, the hyperlinked items lose the link and appear just as text (for example try this: Test - How to overcome this?
Note:
I am trying to import the data table and use the link in the first column from my spreadsheet.
microsoft-excel-2007
asked Jul 17 '12 at 13:04
NoChance
14819
add a comment |
When using the Data menu item in Excel to import data from web to spreadsheet, the hyperlinked items lose the link and appear just as text (for example try this: Test - How to overcome this?
Note:
I am trying to import the data table and use the link in the first column from my spreadsheet.
microsoft-excel-2007
asked Jul 17 '12 at 13:04
NoChance
14819
add a comment |
When using the Data menu item in Excel to import data from web to spreadsheet, the hyperlinked items lose the link and appear just as text (for example try this: Test - How to overcome this?
Note:
I am trying to import the data table and use the link in the first column from my spreadsheet.
microsoft-excel-2007
asked Jul 17 '12 at 13:04
NoChance
14819
When using the Data menu item in Excel to import data from web to spreadsheet, the hyperlinked items lose the link and appear just as text (for example try this: Test - How to overcome this?
Note:
I am trying to import the data table and use the link in the first column from my spreadsheet.
microsoft-excel-2007
microsoft-excel-2007
asked Jul 17 '12 at 13:04
NoChance
14819
asked Jul 17 '12 at 13:04
NoChance
14819
edited Jul 17 '12 at 13:22
asked Jul 17 '12 at 13:04
NoChance
14819
asked Jul 17 '12 at 13:04
NoChance
14819
asked Jul 17 '12 at 13:04
NoChance
14819
14819
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
When you choose your table to import, select "options" in the upper right corner and deselect "Import blocks into columns". Click OK then finish your import. This will import the table with its existing formatting, including the hyperlinks.
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
Please note that in Excel 2007 the dialog box for options is slightly different, and I had to select the "Full HTML formatting" to what you have suggested to make it work. Thanks again for your help.
– NoChance
Jul 17 '12 at 15:00
In MSexcel 2013, After clicking "Data" tab and "from web". Click on the upper right corner "Options" as CharlieRB said. In Web Query Options window that will be opened, 1. select Full HTML formatting and 2. deselect Import<PRE>blocks into columns as CharlieRB said.
– sandy
Aug 24 '15 at 6:21
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f450002%2fwhen-importing-data-from-web-page-using-excel-hyperlinks-are-lost-how-to-solve%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
When you choose your table to import, select "options" in the upper right corner and deselect "Import blocks into columns". Click OK then finish your import. This will import the table with its existing formatting, including the hyperlinks.
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
Please note that in Excel 2007 the dialog box for options is slightly different, and I had to select the "Full HTML formatting" to what you have suggested to make it work. Thanks again for your help.
– NoChance
Jul 17 '12 at 15:00
In MSexcel 2013, After clicking "Data" tab and "from web". Click on the upper right corner "Options" as CharlieRB said. In Web Query Options window that will be opened, 1. select Full HTML formatting and 2. deselect Import<PRE>blocks into columns as CharlieRB said.
– sandy
Aug 24 '15 at 6:21
add a comment |
When you choose your table to import, select "options" in the upper right corner and deselect "Import blocks into columns". Click OK then finish your import. This will import the table with its existing formatting, including the hyperlinks.
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
Please note that in Excel 2007 the dialog box for options is slightly different, and I had to select the "Full HTML formatting" to what you have suggested to make it work. Thanks again for your help.
– NoChance
Jul 17 '12 at 15:00
In MSexcel 2013, After clicking "Data" tab and "from web". Click on the upper right corner "Options" as CharlieRB said. In Web Query Options window that will be opened, 1. select Full HTML formatting and 2. deselect Import<PRE>blocks into columns as CharlieRB said.
– sandy
Aug 24 '15 at 6:21
add a comment |
When you choose your table to import, select "options" in the upper right corner and deselect "Import blocks into columns". Click OK then finish your import. This will import the table with its existing formatting, including the hyperlinks.
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
When you choose your table to import, select "options" in the upper right corner and deselect "Import blocks into columns". Click OK then finish your import. This will import the table with its existing formatting, including the hyperlinks.
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
answered Jul 17 '12 at 14:02
CharlieRB
20.4k44490
20.4k44490
Please note that in Excel 2007 the dialog box for options is slightly different, and I had to select the "Full HTML formatting" to what you have suggested to make it work. Thanks again for your help.
– NoChance
Jul 17 '12 at 15:00
In MSexcel 2013, After clicking "Data" tab and "from web". Click on the upper right corner "Options" as CharlieRB said. In Web Query Options window that will be opened, 1. select Full HTML formatting and 2. deselect Import<PRE>blocks into columns as CharlieRB said.
– sandy
Aug 24 '15 at 6:21
add a comment |
Please note that in Excel 2007 the dialog box for options is slightly different, and I had to select the "Full HTML formatting" to what you have suggested to make it work. Thanks again for your help.
– NoChance
Jul 17 '12 at 15:00
In MSexcel 2013, After clicking "Data" tab and "from web". Click on the upper right corner "Options" as CharlieRB said. In Web Query Options window that will be opened, 1. select Full HTML formatting and 2. deselect Import<PRE>blocks into columns as CharlieRB said.
– sandy
Aug 24 '15 at 6:21
Please note that in Excel 2007 the dialog box for options is slightly different, and I had to select the "Full HTML formatting" to what you have suggested to make it work. Thanks again for your help.
– NoChance
Jul 17 '12 at 15:00
Please note that in Excel 2007 the dialog box for options is slightly different, and I had to select the "Full HTML formatting" to what you have suggested to make it work. Thanks again for your help.
– NoChance
Jul 17 '12 at 15:00
In MSexcel 2013, After clicking "Data" tab and "from web". Click on the upper right corner "Options" as CharlieRB said. In Web Query Options window that will be opened, 1. select Full HTML formatting and 2. deselect Import
<PRE> blocks into columns as CharlieRB said.– sandy
Aug 24 '15 at 6:21
In MSexcel 2013, After clicking "Data" tab and "from web". Click on the upper right corner "Options" as CharlieRB said. In Web Query Options window that will be opened, 1. select Full HTML formatting and 2. deselect Import
<PRE> blocks into columns as CharlieRB said.– sandy
Aug 24 '15 at 6:21
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f450002%2fwhen-importing-data-from-web-page-using-excel-hyperlinks-are-lost-how-to-solve%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
