How to import local business information from the Google Places API into Excel

David Watts
powrbot
Published in
1 min readJul 29, 2020

Say that I own a gym equipment company and want to find all of the local gyms in New York.

You might utilize the Google Places’ API to do this for you if you have the programming skills, or you could use our tool which will do it for you!

Simply select Country, City, Business Type and Number of Results:

The search box at powrbot local search

And then you’ll receive a .csv file that you can open in Excel or Google Sheets with the top 10 results for gyms in New York, including address, lat-long, phone numbers, opening hours, name, type, and more!

The .CSV results

You can find powrbot Local Search and more great time saving tools from powrbot here.

--

--