If you’re working with Google Plus Codes and need to convert them into latitude and longitude coordinates, this Python-based solution is exactly what you need.
This script takes a CSV/XLSX file with Plus Codes and fetches their exact location using the Google Maps API. Whether you’re a developer, data analyst, or GIS expert, this tool simplifies the process and ensures accurate geocoding.
In this article, we’ll cover:
✅ What this script does
✅ How to install and run it
✅ Step-by-step usage guide
Why Use This Plus Code Geocoder?
Google Plus Codes are an easy way to represent locations, but they are not always useful unless converted into latitude and longitude. Here’s why this script is a game-changer:
✔️ Accurate Geocoding – Uses the Google Maps API for precise location mapping.
✔️ Batch Processing – Convert hundreds or thousands of Plus Codes in one go.
✔️ Multiple File Support – Works with both CSV and XLSX files.
✔️ Automated Process – No need for manual lookups.
✔️ Fast & Efficient – Includes a progress bar to track processing.
Features at a Glance
📌 Supports Google Maps API – Ensures precise geolocation data.
📌 CSV & XLSX Compatibility – Process files in different formats.
📌 Batch Processing – Convert multiple Plus Codes quickly.
📌 Progress Bar – See real-time updates while processing.
📌 Easy Export – Save results in CSV or XLSX format.
Installation & Setup Guide
Step 1: Install Dependencies
Before running the script, ensure you have Python 3.x installed (recommended: Python 3.10).
Install required libraries:
pip install pandas openpyxl requests tk tqdm
Step 2: Set Up Your Google Maps API Key
To use this script, you’ll need a Google Maps API Key. Get one from Google Cloud Console.
Once you have the API key, open the script and replace:
api_key = "YOUR_GOOGLE_MAPS_API_KEY"
with your actual API key.
Step 3: Run the Script
Run the Python script using:
python run.py
The script will guide you through the setup process.
How to Use the Script
1. Select Your Input File
You’ll be prompted to select a CSV/XLSX file containing Plus Codes.
2. Identify the Plus Code Column
The script will automatically detect a column with “Plus” or “plus” in its name. If needed, modify the script to match your dataset.
3. Geocode Plus Codes with a Progress Bar
The script fetches latitude and longitude for each Plus Code and displays a progress bar.
4. Choose Output Format
You’ll be asked to select between:
1 - CSV
2 - XLSX
Enter 1 for CSV or 2 for XLSX.
5. Save the Output File
Once processing is complete, the file is saved in your chosen format.
Example Use Case
Imagine you have a file locations.csv with Plus Codes, and you need to get latitude and longitude.
Simply run:
python run.py
Follow the prompts, select locations.csv, and choose CSV/XLSX as output. The script will generate a new file with latitude and longitude columns.
Code Overview
The script is organized into key functions:
🔹 Geocoding a Plus Code:
def get_lat_lng_from_plus_code(plus_code, api_key):
# Send request to Google Maps API and retrieve lat/lng
🔹 Adjusting Column Widths (For XLSX Output):
def adjust_column_width(output_file_path):
# Optimize Excel formatting for better readability
Contribute to the Project
🚀 Want to improve this script? Feel free to contribute!
How to Contribute
✔️ Report Issues: Submit a GitHub issue with details.
✔️ Submit a Pull Request: Fork the repo, make changes, and create a PR.
GitHub Repository
🔗 Convert Google Plus Code to Lat/Long – GitHub
Why Use This Script?
If you deal with Google Plus Codes, this script saves time and effort. Instead of manual lookups, you can process thousands of locations automatically.
✔️ Developers: Integrate into projects needing geolocation data.
✔️ Data Analysts: Convert bulk Plus Codes into usable coordinates.
✔️ Businesses: Optimize logistics, deliveries, or mapping applications.
Final Thoughts
This Python script is the perfect tool to convert Google Plus Codes into latitude and longitude effortlessly. With Google Maps API integration, batch processing, and CSV/XLSX support, it simplifies the geocoding process.
🔗 Get the script on GitHub and start converting Plus Codes today! 🚀
