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 Optimization Off-page Optimization Social Media Article Submission Social Bookmarking Photo Sharing Video Promotion Business Reviews Web 2.0 Submissions Social Shopping Network Document Sharing Classifieds Submissions Press release promotions Blogging Social 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 generatio n
728 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
158 comments
Read more

Free Tools for Digital Marketing

Image Credits : pixabay.com ,  Design Tool : canva.com I would like to start this article with a quote "   A lways give back what you get. It feels great! Major challenge For Marketers, especially for those who are working in a bootstrapped startup company is, working with constraints. Constraints can be anything, like time, money, resource, tools etc. Having worked in several startups, i have been exploring several tools that can help to manage all these constraints. I have listed the tools below, that helped me to manage my marketing activities. Free Tools For Digital Marketing 1. Web Analytics 1.      Google Analytics 2. SEO 1.      Google Webmaster/Search Console 2.      Smallseotools 3.      SEMRush 4.      Linkio 3. Keyword Planner   1.      Google Keyword Planner 4. Paid Ads   1.      Google Adwords   2.      Bing Ads 5. Reports Presentation   1.      Google Data Studio 6. Webpage Optimization 1.     
116 comments
Read more