Skip to main content

How To Extract Data from Web Pages using Excel ?

Most of the time you have to copy paste some information from website for several purposes. Purpose can be anything ranging from List of Contacts in a particular page, List of Items, Description etc. Copy pasting is always a painful and most importantly time-consuming task. In this situation, excel makes your life easier and saves time. You can use excel to extract those fields from the website.
Excel has a great option to extract data from the website. Please find out the steps below
1. Open Excel
2. Choose From Web Option Under Data Tab
Excel - How to extract Data from Website using Excel 1
3. When you Click From Web option,A pop up window will appear
4. Give the url of the website in the address field and click Go
excel-extracting-data-from-website-5
5. Select Yes if any prompt message appears
excel-extracting-data-from-website-21.
6. Then Choose the Arrow mark that appears in the webpage
excel-extracting-data-from-website-6
7. Then Click Import button
excel-extracting-data-from-website-7
8. Then Give the address of the cell where you would like to extract those data
excel-extracting-data-from-website-3
9. This will extract and give you the data available in the web page
excel-extracting-data-from-website-4
I have used the above url just for demo purpose. You can use the right url for right information
Labels:

Comments

Post a Comment

Popular posts from this blog

SEO - Sources for Backlinks Generation (Off-Page Optimization)

Digital Marketing has become traditional marketing in current e-World. Digital Marketing involves, Search Engine Optimization (SEO), Search Engine Marketing (SEM), Social Media Marketing (SMM), Email Marketing etc..
On-Page OptimizationOff-page OptimizationSocial MediaArticle SubmissionSocial BookmarkingPhoto SharingVideo PromotionBusiness ReviewsWeb 2.0 SubmissionsSocial Shopping NetworkDocument SharingClassifieds SubmissionsPress release promotionsBloggingSocial Account Creation'
I would like to touch upon SEO here. In SEO there are 2 types of techniques. Best practice is to optimize your page first. So On-page optimization should be your first priority. Once On-page optimization is completed, you can move on to Off page optimization.
Authentic back links are the main source of Off-page Optimization. Listed below are the sources of back-link generation


457 comments
Read more

Why Should i have a website?

There are so many reasons for having a website. I have given the reason in the point of view of digital marketing

Earlier people used to ask their friends and families to know about any services/products. They always go for references to know about a product/services. They also go to shops and learn about it.



Nowadays, they google it first. Google has become their first point of contact for any types of references, knowledge, comparison etc



So it is very important to make your product/services visible to them. To make it visible, first, you should make yourself available on the web.

So having a web presence is mandatory.
Create your website first
8 comments
Read more

How to Calculate Engagement Rate for Company Facebook Page?

Post Engaged Users – Insights Tab You can get the engagement rate of posts from Insights tab in company Facebook page for every post


Page Engaged Users – Data Export To calculate the Engagement Rate for the entire page, you can use the data by export option. This Exported data has all the Facebook key metrics


What is an Engaged user of a page? The number of people who engaged with your Page. Engagement includes any click or story created. (Unique Users) Engaged Users = Clicks + Stories (Likes, Shares, Comment) Calculation for Page Engagement Rate % Engagement Rate % = (Engaged Users*100) / Total Reach

53 comments
Read more