About online directory
About us
Contacts
Work schedule
Mon-Fri: 09:30 - 18:00
Sat-Sun: days off
.svg)
Geodata Online — a Tool for Tables
Batch process Ukrainian addresses, geodata, IPs, and full names directly in Google Sheets via the GeoData.online API. Work directly with your own database — no exports, no formatting changes, and no access required to other Google services.
01
Доступ до онлайн-довідників актуальних адрес України, Казахстану, Польщі, Чехії, Італії, Естонії, Румунії, Болгарії, Франції та Данії
02
Обробка баз даних: актуалізуємо, доповнюємо, структуруємо адресні бази даних
03
Додаткові сервіси:
пошук імені, зворотне геокодування, оцифровка анкет
.svg)
.svg)
.svg)
What features does the tool offer?
Eight processing scenarios across three categories. Numbers in parentheses indicate how many columns are added to your spreadsheet.
Addresses
Parse Address (43) — Breaks an address into individual components such as postal code, region, district, city, street, building number, and more.
Normalize Address (1) — Generates a single standardized full-address string.
Envelope Format (6) — Creates address fields ready for printing on envelopes and contracts.
Envelope Transliteration (12) — Produces the same address fields in Latin characters for international mail.
Geo services
Reverse Geocoding (40) — Retrieves address details and geographic information from latitude and longitude coordinates.
Location by IP (27) — Returns city, region, and connection details based on an IP address.
Personal names
Parse Full Name (7) — Splits a full name into surname, first name, patronymic, gender, and other components.
Name Inflection (23) — Generates all Ukrainian grammatical cases and transliterations.
How a user works with the tool
No predefined column template is required—the add-on works with your existing spreadsheet.
Open your Google Sheets document (column names can be anything).
Go to Extensions → GeoData Online → Open Sidebar.
Sign in to your GeoData.online account from the sidebar.
Select the processing scenario you need.
Choose the column containing your source data (address, coordinates, IP address, or full name).
Choose where to enter the result: add the columns to this sheet or to a separate sheet.
Click Process. The sidebar processes the data automatically while displaying real-time progress.
HOW DATA PROCESSING WORKS
Results stay next to your data. New information is added as additional columns without overwriting existing values. Perfect for CRM exports, mailing lists, and large datasets.
Automatic batch processing. Large datasets are processed in batches while the spreadsheet tab remains open. The progress bar shows completed records, elapsed time, and estimated time remaining.
Separate progress for each scenario. Multiple processing scenarios can be run on the same dataset independently. Each scenario resumes from where it previously stopped.
Full control. You can pause processing at any time and later rerun only the failed rows.
Optional output sheet. If you prefer to keep your original sheet untouched, results can be written to a separate worksheet.
.svg)
What data does the tool use?
The tool uses only the data necessary for the selected scenario to run:
INPUT DATA (Only the columns you explicitly select.)
- Address — for address processing.
- Latitude + Longitude — for reverse geocoding.
- IP Address — for location lookup.
- Full Name (optionally with gender) — for name parsing and inflection.
PRIVACY & SECURITY
- Works only with the spreadsheet you currently have open.
- Sends only the required fields to the GeoData.online API.
- Does not access other spreadsheets, Google Drive, Gmail, or Google Calendar.
- Your password is never stored—authentication uses a secure access token.
User Value
Work with your existing spreadsheet. No need to reformat data or import it into templates—just select the appropriate column.
Enrich your records. Add standardized addresses, correctly inflected names for correspondence, or geographic information from IP addresses—all within the same row.
Batch processing with full visibility. Monitor progress, estimated completion time, pause processing, and retry failed rows.
Reliable Ukrainian data. The same high-quality data and processing engine used across all GeoData.online services.
Instructions
Installation
Install the add-on from Google Workspace Marketplace. It will appear under Extensions → GeoData Online in every Google Sheets document.
Open the Sidebar
Go to Extensions → GeoData Online → Open Sidebar. The sidebar opens alongside your spreadsheet without interrupting your work.
Sign In
Log in with your GeoData.online credentials. Your account information and balance are displayed at the top of the sidebar.
Choose a Scenario
Select the processing scenario, specify the input columns, and choose the output mode (current sheet or separate sheet).
Start Processing
Click Process. Data is processed automatically in batches. Keep the spreadsheet tab open while large datasets are being processed.
Processing Status
A status column is created for every processing scenario:
- ok — processed successfully
- not_found — no matching result found
- any other value indicates an error.
Resume & Retry
Running the same scenario again continues with unprocessed rows. Retry Failed clears and reprocesses only unsuccessful records.
Billing
Every API request is billed according to your GeoData.online plan. Monitor your account balance before processing large datasets.
Pricing: geodata.online/#tariffs.
Platform
The add-on works in the desktop version of Google Sheets.
Documentation
How the module works
A short video demonstrating how the tool works.
.jpg)
.svg)
Try it on your own spreadsheet
Create a GeoData.online account—and start enriching your data right in Google Sheets.
.svg)
%20(1)%201.webp)
CONTACTS
Work schedule
Mon-Fri: 09:30 - 18:00
Sat-Sun: days off
WRITE TO US
About online directory
Information
About us
.svg)