top of page

Factotum

SQL-powered data viewer, editor and converter

Import data files as tables to a virtual database
Manipulate data larger than your RAM
Use the full power of SQL
Plenty of data file formats supported
Free and open source

Factotum - Data Manipulation Tool

Supported formats

Factotum Data Manipulation tool supports the following formats:

Comma Separated Values (CSV): csv
Tab Separated Values (TSV): tsv
Microsoft Excel: xls, xlsx, xlsm, xlsb
OpenOffice Formats: odf, ods, odt
Apache Parquet: parquet
Apache AVRO: avro
Apache ORC: orc
Apache Arrow IPC: feather
JavaScript Object Notation (JSON): json
Statistical Analysis System (SAS): sas7bdat, xpt
Extensible Markup Language (XML): xml
Statistical Package for the Social Sciences (SPSS): sav, zsav, por
Stata Data Format: dta
Hierarchical Data Format (HDF): .h5, .hdf5
Hypertext Mark-up Language (HTML): html

SQL engines

You can switch between these engines:

Polars

DuckDB

Download

Windows

Windows x64 Installer

MacOS

MacOS Apple Silicon DMG

Linux

Support the project

Factotum Data Manipulation Tool is a free and open source project.

Your generous support will enable author to dedicate more time to enhancing and adding features to Factotum.

bottom of page