Webmaster Forum

Go Back   Webmaster Forum > The Webmaster Forums > Forum Lobby

Forum Lobby The off-topic forum.


Reply
 
Thread Tools Display Modes
Share |
  #1  
Old 08-30-2018, 03:37 AM
kontrol's Avatar
kontrol kontrol is offline
Contributing Member
 
Join Date: 02-10-10
Posts: 223
iTrader: 0 / 0%
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
 
Reply With Quote

Advertisement

Advertisement

  #2  
Old 08-30-2018, 03:51 AM
Bonsdag Bonsdag is offline
Contributing Member
 
Join Date: 10-23-17
Posts: 62
iTrader: 0 / 0%
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.

Or

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
 
Reply With Quote
  #3  
Old 08-31-2018, 01:00 AM
kontrol's Avatar
kontrol kontrol is offline
Contributing Member
 
Join Date: 02-10-10
Posts: 223
iTrader: 0 / 0%
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
 
Reply With Quote
Go Back   Webmaster Forum > The Webmaster Forums > Forum Lobby

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Writing Ad Copy HTMLBasicTutor Marketing Forum 0 12-28-2017 10:35 AM
whatsappweb issue..unable to paste an excel table to whatsapp web bijupurayil Tech Talk 0 06-28-2017 08:08 PM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 01:35 PM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC