I am looking for a way to batch geocode a dataset containing cites/states to lat/longs. The lat/long for the centroid of the city is fine. My data does not contain streets or street numbers. Only city/state combinations, e.g. Brooklyn, NY.
I have tried various geocoders, such as the Census Geocoder and the Google Sheets "Awesome Table" plugin "Geocode." Both of these geocoders require a "full address" and will not geocode city/state alone without a street/street number.