Print

Training >> Browse Articles >> Applications

+50

10 Excel Secrets Every Admin Should Know

AdminSecret and Richard Rinyai

3. Import Data from a Web Page




Your manager comes up to you and asks you to open a web page. You see that there is quite a large amount of data on this particular page, looking like a spreadsheet. The manager then asks you to add this information onto an existing Microsoft Excel spreadsheet and for you to manipulate the data so that it flows with the original file.

Oh, one more thing, the manager asks you to do this right away, as they need it for a meeting in one hour.

Ok, don’t panic. There is a very simple method of adding data directly from the web page onto a Microsoft Excel spreadsheet.

1. Click File, Open.

2. Type in the web address of where the data is located, including the http://.

3. Make sure to use Web Pages and Web Archives (*.htm; *.html; *mht; *mhtml) in the Files of Type section below where you’ve entered the web address.

4. Click Open.

As you can see, the entire web page imports directly into Microsoft Excel. You can now remove any useless information and have all of the data copied and pasted directly into your original spreadsheet.


AdminSecret School Finder

Save time in your search for a degree program. Use AdminSecret's School Finder to locate schools online and in your area.


* In the event that we cannot find a program from one of our partner schools that matches your specific area of interest, we may show schools with similar or unrelated programs.

Recent Activity

Photo_user_blank_big
romanico received the quiz result of "21-50% correct: Good effort", about 2 years ago.
Photo_user_blank_big
tmiller received the quiz result of "Satisfactory", about 2 years ago.
003_max30
new2admin gave a thumbs down to The Article "6 Ways Finding a Dream Job Is Like Finding Your Soul Mate", about 2 years ago.
Photo_user_blank_big
kinsh1987 received the quiz result of "Legal Secretary ", about 2 years ago.
Contactphoto-img_20141211_175940_max30
LoraJ commented on: "Lora Coats", about 2 years ago.