Bulk-import Excel updates into PostgreSQL/PostGIS databases with preview and column mapping.
- Use existing QGIS connections: Leverages PostgreSQL connections already configured in QGIS Browser
- Configurable column mapping: Map any Excel column to any database column via UI
- Preview before commit: See all changes color-coded before applying them
- Transaction safety: All changes applied in a single transaction with rollback on error
- Cross-platform: Works on Windows and macOS using native QGIS libraries
- Open QGIS
- Go to Plugins > Manage and Install Plugins
- Click Settings tab
- Click Add to add a custom repository
- Enter:
- Name:
DataSync Plugin - URL:
https://raw.githubusercontent.com/lukaskucinski/datasync-plugin/main/plugins.xml
- Name:
- Click OK, then go to All tab
- Search for "DataSync" and click Install
- Download the latest release zip from Releases
- In QGIS, go to Plugins > Manage and Install Plugins
- Click Install from ZIP
- Select the downloaded zip file
- Configure a PostgreSQL connection in QGIS Browser panel
- Have an Excel file (.xlsx or .xls) with data to sync
- Click the DataSync button in the toolbar (or Database menu > DataSync)
- Step 1: Browse and select your Excel file, choose the sheet
- Step 2: Select PostgreSQL connection and click Connect, then choose target table
- Step 3: Configure column mapping:
- Select the key column in both Excel and database (used to match records)
- Add value column mappings for each column you want to sync
- Step 4: Click Generate Preview to see changes
- Green rows = new records to be added
- Orange rows = existing records to be updated
- Click Execute Sync to apply changes
| Color | Meaning |
|---|---|
| Green | New row to be inserted |
| Orange | Existing row to be updated |
| White | Unchanged (not shown in preview) |
- QGIS 3.0 or later
- PostgreSQL/PostGIS database
- psycopg2 (included with QGIS)
MIT License
Issues and pull requests welcome at https://github.com/lukaskucinski/datasync-plugin