Webmaster Forum

Webmaster Forum (http://www.v7n.com/forums/index.php)
-   Forum Lobby (http://www.v7n.com/forums/forumdisplay.php?f=9)
-   -   copy to excel (http://www.v7n.com/forums/showthread.php?t=429455)

kontrol 08-30-2018 03:37 AM

copy to excel
hi, I am trying to copy text from this site (www.statarea.com/predictions) to excel but I am struggling with it.
I'm trying to get them in the sane arrangement as it is in the site.
I would appreciate any help

Bonsdag 08-30-2018 03:51 AM

Follow these steps to copy the content from Excel

1. Open Excel.
2. Click the Data tab and choose From Web in the Get & Transform Data group.
3. In the dialog box, select Basic and type or paste the URL in the box. Click OK.
4. In the Navigator box, select the tables you wish to import. Excel tries to isolate content blocks (text, tables, graphics) if it knows how to parse them. To import more than one data asset, ensure the box is checked for Select multiple items.
5. Click a table to import from the Navigator box. A preview appears on the right side of the box. If it meets expectations, press the Load button.
6. Excel loads the table into a new tab in the workbook.


1. Open the website
2. Press ctrl + U
3. Copy all the html of tables
4. Open the website https://html-online.com/editor/
5. Paste html in Source section
6. Copy table from word viewer
7. Paste in Excel

kontrol 08-31-2018 01:00 AM

Thanks Bonsdag, it does work but they are not arranged just it is displayed in the site. the second also requires a membership to do a long html like that page.
they good resources for data collection.
thank you

All times are GMT -7. The time now is 12:50 AM.