Open or combine
Parquet, CSV, Excel, JSON, R, Arrow and GIS layers inside one workspace.
Data intelligence + geospatial
From file to decision. Without uploading your data.
Open huge files, join them with SQL, catch quality issues and turn coordinates into maps. A local analysis workstation for Windows, powered by DuckDB.
FreeNo accountData stays localSpanish & English UI
89 msAggregate query · 85,000 synthetic records
12integrated modules
10+data formats
100%local processing
1workspace for all your files
Full workflow
Start with a file. End with an answer.
No database to install, no server to configure. The flow is built to investigate first and formalize the analysis later.
Inspect
Schema, types, nulls, distributions, outliers and nested structure.
Analyze
Visual filters, DuckDB SQL, JOINs, pivot tables, correlation and maps.
Deliver
Export results to Parquet, Excel, CSV, JSON, GeoJSON, Arrow or SQL.
701-cell grid weighted by catch sumGeospatial analysis
When a table is also a map.
Detect coordinates, summarize millions of points into a readable grid and add reference layers without switching tools.
- Points, density grid and aggregation by sum, mean, median, min or max.
- Box, lasso, circle or polygon selection wired to your SQL results.
- Distance, radius, perimeter and area in km, meters, miles or nautical miles.
- Offline tile cache, PNG export with legend & scale bar, GeoJSON/Shapefile layers.
Automatic exploration without writing SQLVisual exploration
Understand the shape of your data in minutes.
Generate histograms, top categories and time series to orient the analysis before writing a single query.
- Automatic dashboard per variable type.
- One-click full profile: a shareable HTML report of every column.
- Excel-style pivot table executed by DuckDB.
- Pearson or Spearman matrix with ranking and scatter drill-down.
Every warning explains itself and opens the affected rowsTrust your data
Find what a pretty table can hide.
Before presenting results, review anomalies in context and jump from the warning straight to the affected records.
- Nulls, NaN, duplicates, constants and empty strings.
- IQR outliers and out-of-range coordinates.
- Saved quality rules: no-nulls, unique, range, regex, allowed values.
- Exportable HTML quality report for data deliveries.
One application
Database depth. Viewer agility.
Twelve modules sharing the same dataset, the same query and the same session.
01
Data & SQL
Paged grid, visual filters and reproducible DuckDB queries.
02Schema
Columns, types, metadata and table explorer.
03Statistics
Rows, cardinality and type-aware summaries.
04Quality
Nulls, duplicates, mixed types, outliers and saved rules.
05Profile
Percentiles, top values, histograms and HTML report.
06Dashboard
Automatic distributions, categories and time series.
07Pivot
Rows, columns, measure and aggregation.
08X-Y Chart
Scatter, density, groups and controlled samples.
09Correlation
Pearson, Spearman, matrix and pair detail.
10Compare
Differences in structure, rows, types and nulls.
11Dictionary
Description, unit, domain and notes per column.
12Map
Grids, layers, selection, measures and GeoJSON/PNG.
Recent updates
A clearer map. More reliable data.
Version 4.60 improves how the density map reads and strengthens the integrity of aggregations across the analysis.
Global or View scale
Choose whether the map colour means the same across the whole dataset —comparable between screenshots— or rescales to what is visible for maximum local contrast.
The click explains the colour
Click a cell and records are sorted by the variable you are mapping, with the aggregated value in the status bar: you instantly see why an area stands out.
Aggregations without surprises
Fixed handling of non-numeric values (NaN) in maps, pivot tables, charts and profiles: no more empty or skewed results.
Optional updates
Checking for new versions is opt-in: it only runs if you allow it, and the app works the same, even offline.
Positioning
It does not replace your ecosystem. It removes friction between its parts.
Its value is opening, understanding, joining and delivering data quickly before moving to a specialized platform.
| Need | OliMat | Spreadsheet | DB client | Dedicated GIS |
|---|---|---|---|---|
| Open local Parquet without importing | Yes | Limited | Depends | Depends |
| JOIN across Parquet, CSV and Excel | Yes | Limited | Yes | Partial |
| Guided profiling and quality | Yes | Manual | Partial | Partial |
| Weighted spatial grid | Yes | — | — | Yes |
| Read R RDS/RData without installing R | Yes | — | — | Rare |
| Shareable one-click profile report | Yes | Manual | Partial | — |
FAQ
The essentials before you start.
Do I need to know SQL?
No. You can open, sort, filter, profile, map and export visually — the visual filter even writes and shows the SQL so you learn as you go. SQL becomes useful for JOINs and repeatable analysis.
What about very large files?
DuckDB queries files without loading them fully into memory and the grid paginates results. The practical limit depends on disk, query and available RAM.
Does it work offline?
Analysis always works offline. On the map, visited areas are cached automatically and reused without a connection; you can also overlay local GeoJSON and Shapefile layers.
Can it open R files (RDS/RData)?
Yes, even lists containing many tables: the app shows a catalog, converts only the tables you pick, and you query them with SQL. No R installation needed.
CSV files with accents that other tools reject?
CSV exported as Latin-1/Windows-1252 or UTF-16 is detected and opened automatically with correct characters.
Is it really free?
Yes. The complete application is free for personal, academic, institutional and commercial use under the included license. Donations are voluntary.
Windows · Free · Local
Make visible what lives inside your data.
Download OliMat Data Explorer, open your first file and move from inspection to analysis with zero infrastructure.