Geodata Online for Sheets is a Google Sheets™ add-on that enriches data right inside your spreadsheet through the GeoData.online API: it normalizes Ukrainian addresses, returns geodata by coordinates, detects a city by IP, and parses and declines full names.

You work on your own spreadsheet: pick the column with the input data, and the results are appended as new columns in the same sheet (or in a separate sheet — your choice). Nothing is overwritten.

Eight scenarios:
• Addresses: decompose into individual fields, compose the full address, envelope/contract fields and their transliteration.
• Geo services: reverse geocoding by coordinates; city and connection data by IP.
• Full names: parsing into components; declension across all grammatical cases with transliteration.

How it works:
• Processing runs in batches automatically while the panel is open; you see a progress bar, the number processed, elapsed time and an estimated time remaining (ETA).
• Each scenario has its own status column, so you can run several scenarios on the same data and resume from where you stopped.
• You can stop processing and re-run only the failed rows.

Privacy:
• The add-on works only with the active spreadsheet you have opened.
• Only the required fields of the selected columns are sent to GeoData.online.
• It does not read other spreadsheets, Google Drive™, Gmail™ or Google Calendar™.
• Your password is not stored — a secure token is used.

A GeoData.online account is required; API requests are billed against your balance. The tool runs on desktop in Google Sheets™.

Sign up and pricing: https://www.geodata.online

Google Sheets™, Google Drive™, Gmail™ and Google Calendar™ are trademarks of Google LLC.