Geo-Importer

Geo-Importer is a simple desktop app built with PySide6. You can upload your statistics in Excel, CSV, or PDF formats, extract and clean the tables, and then match your data to geographic regions (NUTS levels 0–3, LAU, LOR). Finally, you can export the matched data as CSV or GeoJSON.

Installation

Install from PyPI:

pip install geo-importer

Quick Start

Launch the application:

geo-importer

Or from Python:

import geo_importer
geo_importer.main()

Then:

1. Upload your Excel, CSV or PDF file
2. Select table region (PDF) or worksheet (Excel)
3. Clean and prepare columns in the DataPrep view
4. Filter which statistics to include
5. Load and filter geodata (choose type, version, level)
6. Automatically map statistics to regions (exact, prefix, fuzzy, regex)
7. Manually adjust any unmatched records
8. Preview on an interactive Folium map
9. Export your matched data as CSV or GeoJSON

Features

• Multi-format support: Excel (.xls/.xlsx), CSV, PDF
• Interactive table cleaning with transpose, undo/redo, cut/copy/paste
• Flexible automatic matching: exact, prefix, fuzzy (RapidFuzz), regex
• Built-in geodata: NUTS (0–3), LAU, LOR — select version and level
• Live preview on a Folium map (gradient or categorical coloring)
• One-click export to CSV or GeoJSON

Documentation

Full documentation is available at: https://frievoe97.github.io/geo-importer/latest/

License

Distributed under the MIT License. See the LICENSE file for details.