{"id":13316,"date":"2021-08-20T07:11:15","date_gmt":"2021-08-20T14:11:15","guid":{"rendered":"https:\/\/www.egrabber.com\/blog\/?p=13316"},"modified":"2025-05-16T02:56:29","modified_gmt":"2025-05-16T09:56:29","slug":"scrape-data-from-website-to-excel","status":"publish","type":"post","link":"https:\/\/www.egrabber.com\/blog\/scrape-data-from-website-to-excel\/","title":{"rendered":"Scrape Data from Website to Excel in a Click: Scrape Website Data into Excel"},"content":{"rendered":"\n<p>Online business directories such as yellow pages directories, Google Maps, LinkedIn, association websites, MLS listings &amp; membership directories are some of the best sources to generate sales leads for free. However, you need to spend a lot of time &amp; effort to manually copy-paste data from these websites. This blog post will help you to learn how you can scrape data from website to excel in no time.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\" style=\"border-right: 5px solid #455A64;\"><p style=\"font-style: normal; text-align: center;\"><strong>Scrape Data from Any Website to Excel in a Click!<\/p><p style=\"font-style: normal; text-align: center;\"><a href=\"https:\/\/www.egrabber.com\/listgrabber\/trial.html\" rel=\"noreferrer noopener\">Try for Free!<\/a><\/strong><\/p><\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how-to-scrape-data-from-website-to-excel-manually\"><\/span><strong>How to Scrape Data from Website to Excel Manually<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Internet is a goldmine of sales leads for your business. However, the challenge is, how you can build a list out of it. Why list? A list will help you to have your targeted prospects in one place, reach out and track them. A complete and accurate contact list can be a powerful tool for every sales &amp; marketing professional.<\/p>\n\n\n\n<p>There are many types of lists. You can build your list based on your requirements. Contact lists, prospect lists, business mailing lists, email lists, cold calling lists are some of the lists that sales and marketing professionals look to build from various sources on the Internet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"challenges-to-scrape-website-data-into-excel\"><\/span><strong>Challenges to Scrape Website Data into Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To build lists, you will have to manually visit multiple web pages and scrape data from those pages. It consumes a lot of your time &amp; resources. For example, search a keyword on yellow pages directories, say \u201cFlorists in San Francisco, CA.\u201d Hundreds of search results that span across multiple pages are displayed. You need to copy-paste every contact information such as name, phone number, business mailing address, fax, email address, and so on.<\/p>\n\n\n\n<p>You have to do this for every contact in the search results. Once you finish scraping data from one page, you need to flip to the next page. Imagine how much time it would take if you want to scrape data from hundreds of web pages. In addition, doing this manually is prone to errors. This is where a web data scraping tool comes in handy for busy salespersons and small businesses.<\/p>\n\n\n\n<p>Having an additional resource to scrape data from websites will only add up to your expenses. Because it takes the same amount of time it takes to manually scrape data from a website. But, businesses want to get things done quickly; especially small businesses. This is where web scaper tools come in handy.&nbsp;<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\" style=\"border-right: 5px solid #455A64;\"><p style=\"font-style: normal; text-align: center;\"><strong>Scrape Data from Multiple Websites in a Click!<\/p><p style=\"font-style: normal; text-align: center;\"><a href=\"https:\/\/www.egrabber.com\/listgrabber\/trial.html\" rel=\"noreferrer noopener\">Try for Free!<\/a><\/strong><\/p><\/blockquote>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/i0.wp.com\/www.egrabber.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-jopwell-24222931.jpg?ssl=1\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"454\" src=\"https:\/\/i0.wp.com\/www.egrabber.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-jopwell-24222931.jpg?resize=640%2C454&#038;ssl=1\" alt=\"scrape data from website to excel\" class=\"wp-image-13321\" title=\"\" srcset=\"https:\/\/i0.wp.com\/www.egrabber.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-jopwell-24222931.jpg?w=640&amp;ssl=1 640w, https:\/\/i0.wp.com\/www.egrabber.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-jopwell-24222931.jpg?resize=300%2C213&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.egrabber.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-jopwell-24222931.jpg?resize=381%2C270&amp;ssl=1 381w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><figcaption class=\"wp-element-caption\">Photo by <strong><a href=\"https:\/\/www.pexels.com\/@jopwell?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels\" rel=\"noopener\">Jopwell<\/a><\/strong> from <strong><a href=\"https:\/\/www.pexels.com\/photo\/woman-in-blue-suit-jacket-2422293\/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels\" rel=\"noopener\">Pexels<\/a><\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"scrape-data-from-multiple-websites\"><\/span><strong>Scrape Data from Multiple Websites<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Small businesses often have a limited budget as well as a limited workforce. They always want to do more in less time. They neither can\u2019t afford to spend countless hours on the Internet nor allocate a dedicated resource to scrape data from websites &amp; build lists. This is where web scraping software comes in handy. It helps you to scrape data from any website to Excel in a click, and you can scrape data from multiple websites.<\/p>\n\n\n\n<p>Here are some of the websites that you can use to scrape data and build lists such as email lists, cold calling lists, contact lists, prospect lists, business mailing lists, etc.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Yellow Pages Directories<\/strong> \u2013 It is one of the best places to look for sales leads. Most of the small &amp; local businesses are listed on yellow pages directories. You can search for your targeted prospects and use web scraping software to quickly scrape <a href=\"https:\/\/www.egrabber.com\/blog\/export-yellow-pages-directories-to-excel\/\">export yellow pages<\/a> directories to Excel and build targeted contact lists in no time.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Maps<\/strong> \u2013 Google Maps is another great source to get business leads for free. However, <a href=\"https:\/\/www.egrabber.com\/blog\/extract-data-from-google-maps-to-excel\/\">extracting data from Google Maps<\/a> is a daunting task for busy sales professionals. It takes a lot of time &amp; effort. This is where a google maps scraper can help you to scrape Google Maps data quickly. With a click of a button, you will be able to <a href=\"https:\/\/www.egrabber.com\/blog\/export-google-maps-list-to-excel\/\">export Google Maps list to excel<\/a>. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>LinkedIn<\/strong> \u2013 LinkedIn is one of the best places to look for targeted sales leads. LinkedIn filters help you to narrow down your search based on title, industry, location, company size, and so on. Manually copy-pasting contacts from LinkedIn search results is a time-consuming and tiresome task. This is where linkedin web scraper tools can help you to scrape data from LinkedIn.<\/li>\n<\/ul>\n\n\n\n<p>Association websites, MLS listings &amp; membership directories are other sources where you can find your prospects. You can use web scraping software to quickly scrape data from websites and build your lists.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\" style=\"border-right: 5px solid #455A64;\"><p style=\"font-style: normal; text-align: center;\"><strong>Scrape Data from Websites to Excel Automatically!<\/p><p style=\"font-style: normal; text-align: center;\"><a href=\"https:\/\/www.egrabber.com\/listgrabber\/trial.html\" rel=\"noreferrer noopener\">Try for Free!<\/a><\/strong><\/p><\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"the-best-software-to-scrape-data-from-website-to-excel-in-a-click\"><\/span><strong>The Best Software to Scrape Data from Website to Excel in a Click<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>ListGrabber is an automated list building software that enables you to scrape data from website to excel in no time. It helps you to instantly extract name, email, phone number, business mailing address, Fax number and other contact information from online business directories such as yellow pages directories, association websites, membership directories, MLS listings, LinkedIn, Google Maps, and other web sources.<\/p>\n\n\n\n<p>ListGrabber helps you to eliminate manual data entry, scrape data from any website in a click, automatically navigate to the next page in your search results, and generate leads from various sources on the Internet.<\/p>\n\n\n\n<p>ListGrabber is extremely easy to use and it helps you to build your contact lists, email lists, prospect lists, cold calling lists, business mailing lists, sales lead lists in no time. You can detect and remove duplicate records. You can instantly transfer your contacts to Excel, Outlook, <a href=\"https:\/\/www.act.com\/\" rel=\"noreferrer noopener\">Act<\/a>, GoldMine, etc.<\/p>\n\n\n\n<p>ListGrabber helps you to scrape data from website to excel automatically. You can build lists in no time and spend more time on selling.<\/p>\n\n\n\n<p>Scrape Data from any Website in a Click!<\/p>\n\n\n\n<div class=\"container content\">\n        <div class=\"row\">\n            <div class=\"col-md-4 col-md-offset-1\">\n\n<form name=\"frm\" method=\"post\" class=\"frm form-horizontal reg-page\" action=\"https:\/\/www.egrabber.com\/egforms\/upsert\/\">\n                   \n\n                    <div class=\"form-group has-feedback margin-bottom-20\">\n                    <label class=\"control-label\" for=\"name\">Name <span class=\"color-red\">*<\/span><\/label>\n                    <div class=\"controls\">\n                    <input name=\"name\" type=\"text\" id=\"name\" class=\"name form-control\">\n                    <\/div>\n                    <\/div>\n\n                     <div class=\"form-group has-feedback margin-bottom-20\">\n                    <label class=\"control-label\" for=\"company\">Company <span class=\"color-red\">*<\/span><\/label>\n                    <div class=\"controls\">\n                     <input name=\"company\" type=\"text\" id=\"company\" class=\"company form-control\">\n                    <\/div>\n                    <\/div>\n\n                    <div class=\"form-group has-feedback margin-bottom-20\">\n                  <label class=\"control-label\" for=\"email\">Email Address <span class=\"color-red\">*<\/span><\/label>\n                    <div class=\"controls\">\n                     <input name=\"email\" type=\"text\" id=\"email\" class=\"email form-control\">\n                    <\/div>\n                    <\/div>\n\n              \t\t <div class=\"form-group has-feedback margin-bottom-20\">\n                 \t<label class=\"control-label\" for=\"phone\">Phone <span class=\"color-red\">*<\/span><\/label>\n                    <div class=\"controls\">\n                       <input name=\"phone\" type=\"text\"  id=\"phone\" class=\"phone form-control\">\n                    <\/div>\n                    <\/div>\n                    <div class=\"row\">\n                     <div class=\"col-lg-12\" style=\"display:none\">\n                   <strong> Subscribe to<\/strong>\n                    <\/div>\n                        <div class=\"col-lg-12 checkbox\"> <label style=\"display:none\">\n                        <input type=\"checkbox\" value=\"no\" name=\"eg_webinar_service\" id=\"eg_webinar_service\" checked=\"\" style=\"display:none\"> eGrabber Webinar series\n                        <\/label>  \n\t\t<input type=\"hidden\" name=\"reply\" value=\"https:\/\/www.egrabber.com\/listgrabber\/thankyou\/\">\n                <input type=\"hidden\" name=\"recipient\" value=\"lg_requesttrial\" \/>\n                <input name=\"promo\" type=\"hidden\" id=\"promo\" value=\"eGrabber_Website\">\n                <input name=\"eGrabberReferrerURL\" type=\"hidden\" id=\"eGrabberReferrerURL\">\n                <input name=\"timezone\" type=\"hidden\" id=\"timezone\">\n\t\t<input name=\"webpages_duration_history\" type=\"hidden\" id=\"webpages_duration_history\">\n                <input name=\"jrox\" type=\"hidden\" id=\"jrox\" value=\"null\">\n                <input name=\"keygen\" type=\"hidden\" id=\"keygen\" value=\"0\">\n                <input name=\"searchkeyword\" type=\"hidden\" id=\"searchkeyword\">\n                <input name=\"lead_source\" type=\"hidden\" id=\"lead_source\" value=\"eGrabber_Website\">\n\t<\/div>\n                        <div class=\"col-lg-12 text-center margin-top-20\">\n                            <button class=\"downloadbtn_b btn-u\" name=\"downloadbtn_b\" type=\"button\" value=\"\">Download Trial Now<\/button>\n                            <div class=\"disabled-txt\" style=\"display:none\">&#8230;taking you to the tool-download page, please wait&#8230;<\/div>\n                        <\/div>\n                    <\/div>\n              <\/form>\n<\/div>\n<\/div>\n<\/div>\n        <script type=\"text\/javascript\">\n\/*Validation Script Starts*\/\n        (() => {\n            let vSubmit = document.querySelectorAll(\"button\");\n\n                const validateEmail = (email) => {\n                let re = \/^(([^<>()[\\]\\\\.,;:\\s@\\\"]+(\\.[^<>()[\\]\\\\.,;:\\s@\\\"]+)*)|(\\\".+\\\"))@((\\[[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\])|(([a-zA-Z\\-0-9]+\\.)+[a-zA-Z]{2,}))$\/;\n                return re.test(email);\n                }\n                \n                const validatePhone = (phone) => {\n                let re = \/^[0-9]*$\/;\n                return re.test(phone);\n                }\n\n                const showError = (eName, eCompany, eEmptyEmail, eValidEmail, ePhone, _this) => {                 \n                    let wrapperDiv = _this.closest(\".form-horizontal\").querySelectorAll(\".form-group\"), \n                            errorDiv = document.createElement(\"div\");\n\n                    if(eName) {\n                            errorDiv.innerText = \"This field is required.\";\n                            errorDiv.setAttribute(\"class\", \"error name-error\");\n                            if (!(document.contains(_this.closest(\".form-horizontal\").querySelector(\".name-error\")))) {\n                                wrapperDiv[0].appendChild(errorDiv);\n                            }   \n                            \n                    }\n                    if(eCompany) {\n                            errorDiv.innerText = \"This field is required.\";\n                            errorDiv.setAttribute(\"class\", \"error company-error\");\n                            if (!(document.contains(_this.closest(\".form-horizontal\").querySelector(\".company-error\")))) {\n                                wrapperDiv[1].appendChild(errorDiv);\n                            }\n                    }\n                    if(eEmptyEmail) {\n                            errorDiv.innerText = \"This field is required.\";\n                            errorDiv.setAttribute(\"class\", \"error empty-email-error\");\n                            if (!(document.contains(_this.closest(\".form-horizontal\").querySelector(\".empty-email-error\")))) {\n                                wrapperDiv[2].appendChild(errorDiv);\n                            }\n                    }\n                    if(eValidEmail) {\n                            errorDiv.innerText = \"Please enter a valid email address.\";\n                            errorDiv.setAttribute(\"class\", \"error valid-email-error\");\n                            if (!(document.contains(_this.closest(\".form-horizontal\").querySelector(\".valid-email-error\")))) {\n                                wrapperDiv[2].appendChild(errorDiv);\n                            }\n                    }\n                    if(ePhone) {\n                            errorDiv.innerText = \"This field is required.\";\n                            errorDiv.setAttribute(\"class\", \"error phone-error\");\n                            if (!(document.contains(_this.closest(\".form-horizontal\").querySelector(\".phone-error\")))) {\n                                wrapperDiv[3].appendChild(errorDiv);\n                            }\n                    }\n                }\n\n                function trialValidate() {\n                   let vName = this.closest(\".form-horizontal\").querySelector(\"input[name=name]\").value,\n                        vCompany = this.closest(\".form-horizontal\").querySelector(\"input[name=company]\").value,\n                        vemail = this.closest(\".form-horizontal\").querySelector(\"input[name=email]\").value,\n                        vphone = this.closest(\".form-horizontal\").querySelector(\"input[name=phone]\").value,\n\t\t\terrors = document.querySelectorAll(\".error\"),\n                        validatedOutput = '',\n                        isNameValidated = false,\n                        isCompanyValidated = false,\n                        isEmailValidated = false,\n                        isPhoneValidated = false;\n                        errors.forEach((error) => { \n                         error.remove();\n                        });\n                        if(vName !== \"\")\n                        {\n                            if (document.contains( this.closest(\".form-horizontal\").querySelector(\".name-error\"))) {\n                               this.closest(\".form-horizontal\").querySelector(\".name-error\").remove();\n                            }\n                            vName = vName;\n                            isNameValidated = true;\n                        }\n                        else {\n                            showError('eName', '', '', '', '', this);                            \n                        }\n                        \n                        if(vCompany !== \"\")\n                        {\n                            if (document.contains( this.closest(\".form-horizontal\").querySelector(\".company-error\"))) {\n                                this.closest(\".form-horizontal\").querySelector(\".company-error\").remove();\n                            }\n                            vCompany = vCompany;\n                            isCompanyValidated = true;\n                        }\n                        else {\n                            showError('', 'eCompany', '', '', '', this);                            \n                        }\n                        \n                        if(vemail == \"\")\n                        {\n                            if (document.contains( this.closest(\".form-horizontal\").querySelector(\".valid-email-error\"))) {\n                                this.closest(\".form-horizontal\").querySelector(\".valid-email-error\").remove();\n                            }\n                            showError('', '', 'eEmptyEmail', '', '', this);     \n                        }\n                        else if(validateEmail(vemail) == false) {\n                            if (document.contains( this.closest(\".form-horizontal\").querySelector(\".empty-email-error\"))) {\n                                this.closest(\".form-horizontal\").querySelector(\".empty-email-error\").remove();\n                            }\n                            showError('', '', '', 'eValidEmail', '', this); \n                        }\n                        else {\n                            if (document.contains( this.closest(\".form-horizontal\").querySelector(\".empty-email-error\"))) {\n                                this.closest(\".form-horizontal\").querySelector(\".empty-email-error\").remove();\n                            }\n                            if (document.contains( this.closest(\".form-horizontal\").querySelector(\".valid-email-error\"))) {\n                                this.closest(\".form-horizontal\").querySelector(\".valid-email-error\").remove();\n                            }\n                            vemail = vemail;\n                            isEmailValidated = true;                       \n                        }\n                        \n                        if(vphone !== \"\" && validatePhone(vphone))\n                        {\n                            if (document.contains( this.closest(\".form-horizontal\").querySelector(\".phone-error\"))) {\n                               this.closest(\".form-horizontal\").querySelector(\".phone-error\").remove();\n                            }\n                            vphone = vphone;\n                            isPhoneValidated = true;\n                        }\n                        else { \n                            showError('', '', '', '', 'ePhone', this);                            \n                        }\n\n                        if(isNameValidated == true && isCompanyValidated == true && isEmailValidated == true && isPhoneValidated == true)\n                        {\n                            validatedOutput = \"Name: \"+vName+\" Company: \"+vCompany+\" Email: \"+vemail+\" Phone: \"+vphone;\n                            \/\/console.log(validatedOutput);\nthis.closest(\".form-horizontal\").querySelector(\"#eGrabberReferrerURL\").value = document.referrer;\n                           this.closest(\".form-horizontal\").querySelector(\".disabled-txt\").style.display=\"block\";\n                            set_storage();\n                            this.closest(\".form-horizontal\").submit();                           \n                        }\n                }\n\n            \/\/Onclick Starts\n            vSubmit.forEach(submit => submit.addEventListener(\"click\", trialValidate, false));\n        })();\n\/*Validation Script Ends*\/\n        <\/script>\n","protected":false},"excerpt":{"rendered":"<p>Online business directories such as yellow pages directories, Google Maps, LinkedIn, association websites, MLS listings &amp; membership directories are some of the best sources to generate sales leads for free. However, you need to spend a lot of time &amp; effort to manually copy-paste data from these websites. This blog post will help you to&hellip;&nbsp;<a href=\"https:\/\/www.egrabber.com\/blog\/scrape-data-from-website-to-excel\/\" rel=\"bookmark\"><span class=\"screen-reader-text\">Scrape Data from Website to Excel in a Click: Scrape Website Data into Excel<\/span><\/a><\/p>\n","protected":false},"author":17,"featured_media":13349,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[416],"tags":[],"class_list":["post-13316","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-b2b-lead-generation"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.egrabber.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-scrape-data-from-website-to-excel-in-a-click.png?fit=1038%2C576&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/posts\/13316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/comments?post=13316"}],"version-history":[{"count":22,"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/posts\/13316\/revisions"}],"predecessor-version":[{"id":19124,"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/posts\/13316\/revisions\/19124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/media\/13349"}],"wp:attachment":[{"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/media?parent=13316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/categories?post=13316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.egrabber.com\/blog\/wp-json\/wp\/v2\/tags?post=13316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}