Discussion on:

Import and convert Web text to columns in an Excel worksheet

I find it much easier to simply highlight the table data I want, then copy and paste into Excel using the "Paste Special - Text" function. Excel will automatically put into columns and it is immediately ready for use. Much simpler

If you're importing a table, it will go into columns. The author?s example didn't show this very well.

This tool brings everything in with a lot fewer steps. I've never had to use the step of splitting columns. (Unless the table was a badly done table, then I'd have to split the columns even with copy/paste.)

Copy/Paste can be good a lot of the time, but it brings along some odd side effects. Also, you run the risk of having to remake the selection if the table is a lot longer than the browser.

If you want to see a scenario where this really flies, try:
https://www.cia.gov/library/publications/the-world-factbook/fields/2054.html

With very little work, you have a great table of national birth rates, with out the hassle of dragging the mouse down to the exact point to select the table and only the table. (Do make sure tick the yellow/green arrow at the upper left of the table of data itself.

I can tell you that I've used this process a lot to get data in from various places on the web. I find it valuable to the extreme.

Very useful - I've done this many times. However, I need to import the current PGA Money Leaders table from pgatour.com but it doesn't work - looks as though it's blocked. Anyone know a way around this? Currently I do the copy and paste route.

Just imported so looks like you need to do the whole page using the arrow at the very top left of the page as the individual tables are not available by themselves. Probably created as one table when posted so that may be the issue

Works very well. The comment about too many steps needs more Excel experience.
Ron

A word of caution. Check the last row of imported data against the website data to ensure all data was imported. I recently imported a large amount of data using the web query only to later find about 40% had been truncated for reasons unknown.