Everyone encounter the situation that when you surfing online, but there are many kinds of web pages. We need to put them in Excel one by one to sort them out. It’s very difficult. The technology guys. can analyze the website and do reptiles. Is there no good way for new hand?
Have you ever encountered the awkward moment in the following animation? Now teaching you to solve above problem in one minute.
step 1
Ctrl+C the web links
Step 2
In excel 2013 DATA tab, find “from website”
Step 3
Paste the URL into the pop-up dialog box, click “Go”, then find the table you want to import in the opened webpage, click the small yellow button (follow the operation below) to import it!
Step 4
Done!
Benefit： if the website data update, you can click the form, Click “Refresh”
