Location Validator is an offline, privacy-focused application for validating and processing large-scale location data without relying on any third-party services. It enables users to upload Excel files containing area names, pincodes, and latitude/longitude information, and rapidly verifies the accuracy of these entries against a comprehensive, locally stored global postal dataset.
- Offline Processing: All validation is performed locally, ensuring data privacy and security—no internet or external API calls required.
- Batch Validation: Upload Excel files with thousands of records and receive instant feedback on the validity of each entry.
- Flexible Search: Instantly search for location details by area name or pincode.
- Detailed Results: Download color-coded Excel reports highlighting valid and invalid entries for easy review.
- Interactive Web Interface: Simple, user-friendly interface for uploading files, mapping columns, and viewing results.
- The app normalizes and cleans input data, then cross-references it with a cached, pre-processed global postal code database.
- Validation checks include matching area names and pincodes, as well as verifying latitude/longitude proximity.
- All logic is optimized for speed and memory efficiency, enabling the processing of large datasets on standard hardware.
- Python 3.8+
- See
requirements.txtfor required Python packages
- Clone this repository:
git clone <repo-url> cd <repo-directory>
- Install dependencies:
pip install -r requirements.txt
- Ensure the
data/allCountries.parquetfile is present in thedata/directory.
python app.py- Upload Data: Use the web interface to upload your Excel file containing location data.
- Map Columns: Map your file's columns to the required fields (area, pincode, latlong).
- Validate: Start the validation process and view a summary of results directly in the browser.
- Download Results: Download a detailed Excel report with validation status for each entry.