How to import a table on a Web page to Excel?

  • Thread starter Thread starter Dmitry Kopnichev
  • Start date Start date
D

Dmitry Kopnichev

Hello
How to import a table on a Web page to Excel? Columns in the table are
delimited by several spaces, not by a htm table tag.
 
fist use < data-get>external data (importdata) using a webquery into excel
then
data-texttocolumn using space as delimiter

you must know the no. of the table in the webpage which can be found out
from the source html page counting
<table> tag or by trial and error
 
The table in the webpage looks as a table, but it is a text with columns in
the table delimited by several spaces, not by a htm table tag. Therefore,
the no. of the table cannot be found out from the source html page counting
<table> tag, can be? The table is between other text.
 
if this is the only table try checking <only tables> the second item under
2 of the dialog box <new web query>
 
Clicking <Click to select this table> in the dialog box <new web query>
selects all text on the page, not just the table. There are other tables
(with columns delimited by spaces)separated by text on this page. I need the
other tables too.
 
in that case checking <only table> in new webquery window should be ok for
you
 
Clicking <Click to select this table> in new WebQuery window imports all
text, not only tables, without separating to columns.
 
find the delimiters they are using usually commas or some other signs.
hightlight the data in the first column only
then use data-text to columns and follow the wizard. From your earlier
message it looks the delimiter are spaces
then in the step 2 uncheck all the delimiters and check only <space>. then
you will see in the table below that the vertical lines are inserted at
proper places and then you can finish it.

hope you succeed.
 
How to import tables only, not all text? Clicking <Click to select this
table> in new WebQuery window imports all text, not only tables.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Publishing Named Ranges to Web Pages 1
How to export table from outlook into ms access table? 0
Excel 2010 Table not showing in Access 2010 Import List 0
VBA - retrieve data on last create named range from previous inserted named range 0
how to use 1st row for field names when importing? 1
Cut and paste from web pages, emails, is breaking up text into multipleExcel cells 3
Problem mysql import in powerPivot for Excel 2010 1

Back
Top