How to Import Google Search Results into Excel with Power Query
Question details
The user wants to extract a list of local businesses, including names, addresses, and phone numbers, from Google search results directly into an Excel spreadsheet without copying manually.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Scraping and importing web-based business contact lists into a structured spreadsheet format for lead generation or directory creation.
- Observed behavior
- Google search result pages lack a standard HTML table structure, making it difficult or impossible for Power Query to reliably recognize and import the data.
Verify that your data extraction complies with the target website's terms of service and usage policies. Since Google Search pages do not present data in structured tables, you will have better success finding a local business directory website to use as your data source.
Use Power Query to Import Data from a Structured Directory Website
Bypass Google's unstructured search results by locating a directory website with stable tables, then use Excel's Get & Transform Data feature to import the list.
A standard Google search results page does not expose its underlying data in a format that works directly with Excel's Power Query. Web scraping tools require predictable, tabular data structures.
To accomplish your goal without manual copy-pasting, find an industry directory, chamber of commerce list, or registry website that organizes the contractors into standard HTML tables. Once located, Power Query can easily pull this information into your workbook.
Navigate to a business directory website containing the list of contractors you need and copy the page's URL from your browser's address bar.
Launch Microsoft Excel, open your target workbook, and click on the 'Data' tab in the top ribbon. Click 'Get Data', hover over 'From Other Sources', and select 'From Web'.
In the prompt that appears, paste the copied directory URL into the text box and click 'OK' to establish a connection to the website.
The Navigator window will open, displaying all elements Excel found on the webpage. Click through the items under the 'Display Options' panel to preview them. Check the box next to the table containing the business names, addresses, and phone numbers.
Click 'Transform Data' to open the Power Query Editor. Here, you can delete unnecessary columns or filter out blank rows. Once the list is clean, click 'Close & Load' in the Home tab to import the finalized data directly into your spreadsheet.
Try WPS Office for Seamless Spreadsheet Data Management
If you find Microsoft Excel's Power Query too complex or are looking for a highly capable, cost-effective spreadsheet tool, WPS Office is an excellent choice. It provides a lightweight, familiar interface for managing your business lists and data securely.
Frequently Asked Questions
Why doesn't Power Query recognize Google Search results as a table?
Google Search result pages are dynamically generated and use complex nested HTML elements instead of standard <table> tags. Power Query relies on conventional table structures to accurately identify and extract rows and columns of data.
Are there other tools that can extract data directly from Google?
Yes. While Power Query struggles with unstructured pages, dedicated web scraping extensions or Python scripts (using libraries like BeautifulSoup or Selenium) are better suited for scraping dynamic search engine results.
How do I clean up web data after importing it into a spreadsheet?
Once your data is loaded into the spreadsheet, you can use built-in tools like 'Text to Columns' to split addresses, 'Remove Duplicates' to clear redundant entries, and standard find-and-replace functions to format phone numbers uniformly.
Does WPS Spreadsheets support opening files generated by Power Query?
Yes. Once the data is imported and saved as a standard .xlsx or .csv file in Excel, you can open, edit, and manage that file seamlessly in WPS Spreadsheets without losing the text data.
