Pulled the trigger after reading the row count. Lat/long landed every pin on the right storefront in Mapbox. Saved us hours of manual cleanup.
Really appreciate you taking the time to write this, reviews like this are what keep the refresh cycle on schedule. Let us know if you'd like the file regenerated with extra columns next time.