GIS DATA WORKFLOW

From Excel spreadsheets to PostGIS.

Follow a transfer workflow that connects Excel as a source to PostGIS as a target, including mapping and validation — depending on your data model and supported product configuration.

Explore X-Translator

The problem

Spreadsheet data still has to reach the database.

Teams often maintain records or attributes in Excel while the operational store lives in PostGIS. Manual copy-paste does not scale and is hard to repeat when files change.

Aligning Excel columns with PostGIS tables and attributes
Handling geometry or linked spatial data where applicable
Avoiding one-off imports that are difficult to reproduce
Checking results before writing to production schemas

Why SEPM

A clearer path from source data to usable results.

X-Translator supports a defined Excel-to-PostGIS transfer path — configure the connection, map fields, run the job, and review outcomes rather than improvising each time.

01
Excel as a supported source
Work from familiar workbook structures; column preparation and data types still need to match what the transfer expects.
02
PostGIS as the target
Load into your PostgreSQL/PostGIS environment so downstream GIS and analytics can use the same database.
03
Mapping and configuration
Define how source fields map to target attributes — and adjust mappings when the schema or file layout changes.
04
Validate before commit
Review transfer results and resolve exceptions before relying on the updated tables in production.

Demonstration

See the workflow in action.

Follow the process, from the initial data to the final result.

Workflow steps

01
Prepare the Excel source
Start with the workbook and sheets that contain the data to transfer, with columns ready for mapping.
02
Connect PostGIS
Configure the PostGIS target connection according to your supported deployment.
03
Map source to target
Match Excel fields to PostGIS tables and attributes, then review the proposed mapping.
04
Run the transfer
Execute the configured workflow to load data into PostGIS.
05
Review in the database
Inspect loaded rows or features and correct issues before wider use.