Google Maps Info

I'm working on a data list for my company's sales force. I have a list of 1800 companies out i'm trying to separate by state (for people sales territories).

As of now, I have the list in column A.

A hyperlink has been put in column B for the whole list that brings it to a general google search.

Is there a way.....using only the company name, to do a general google map search (or any map feature), pull the data and put in in excel so each company can be associated with a state.

Anyone and ideas?!

Henry Schein List.xlsx

Updated sheet