A manual workflow:
You can create a google account, go to drive.google.com.
Upload your dataset, say as a csv or xlsx file. In your datafile, Put the street address + city in a single column, call it , say, "location".
Use the File/Import menu to import the csv (or .xlsx file) file to a new Google spreadsheet.
Then import the spreadsheet into a new empty Google Fusion Table (-> Tutorial ). This is kind of an online shapefile, looks like an Excel File with just 1 worksheet. Added benefit: It has Geocoding built-in.
When it's done converting Spreadsheet to Fusion Table, select the entire "location" column defined above, and select File/Geocode... A progressbar will appear when Google Fusion table begins to call the Geocoding API internally. After 1-2 minutes : Done! A new "map" worksheet / tab will appear in the Fusion Table.
This is possible for about < 1000 addresses per sheet/Table. Exact quota number I don't remember. These geocoded values you can export as csv, zip, or KML.