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

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.

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

fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.

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

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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
...
fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.

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

if this is the only table try checking <only tables the second item under
2 of the dialog box <new web query


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.

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

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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
...
if this is the only table try checking <only tables the second item
under
2 of the dialog box <new web query


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.

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

in that case checking <only table in new webquery window should be ok for
you


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
if this is the only table try checking <only tables the second item
under
2 of the dialog box <new web query


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.

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

Clicking <Click to select this table in new WebQuery window imports all
text, not only tables, without separating to columns.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
...
in that case checking <only table in new webquery window should be ok for
you


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
if this is the only table try checking <only tables the second item
under
2 of the dialog box <new web query


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.

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

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.


--
remove $$$ from email addresss to send email
==============================



"Dmitry Kopnichev" wrote in message
...
Clicking <Click to select this table in new WebQuery window imports all
text, not only tables, without separating to columns.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
in that case checking <only table in new webquery window should be ok
for
you


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
if this is the only table try checking <only tables the second
item
under
2 of the dialog box <new web query


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.

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

How to import tables only, not all text? Clicking <Click to select this
table in new WebQuery window imports all text, not only tables.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
...
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.


--
remove $$$ from email addresss to send email
==============================



"Dmitry Kopnichev" wrote in message
...
Clicking <Click to select this table in new WebQuery window imports all
text, not only tables, without separating to columns.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
in that case checking <only table in new webquery window should be ok
for
you


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
if this is the only table try checking <only tables the second
item
under
2 of the dialog box <new web query


"Dmitry Kopnichev" wrote in message
...
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.
"R.VENKATARAMAN" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
...
fist use < data-getexternal 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
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
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.