Parabola offers a rich toolkit for cleaning, manipulating, and generally making short work of messy address data. Street or St? Fl. 4, Fourth Floor, or Floor 4? Typos abound. ZIP+4, or just plain old zip codes? This template appends zip codes to street addresses using the Google Maps API.
The Google Maps API
We're going to use the Google Maps API for every record in our dataset and annotate those records with data that Google sends back.
💡 We said: 1937 Crest Line Drive. They said: 98229 (the zip code). Easy!
In this case, Parabola will add the zip codes as another column in your data, and from there you can do whatever you want with it. If you'd prefer, we can also fetch the full, properly formatted address from Google so that you eliminate any inconsistencies in your address formatting.
This step is currently restricted to 1000 rows, but if you need more than that drop us a line and we'll see what we can do.