What is ETS

Key Features

Excel to SQLite Import

Seamlessly import Excel files into SQLite databases with automatic schema detection. Supports .xlsx and .xls formats with multiple sheets and complex data types.

Import Excel files (.xlsx, .xls) into SQLite databases
Automatic schema detection and table creation
Support for multiple sheets and complex data types

Auto-Pilot Mode

Zero-configuration import with intelligent pattern detection that analyzes your data and generates optimal configurations automatically.

Primary key detection
Foreign key relationship identification
Value mapping discovery (code columns, status fields)
Data type optimization
Quality scoring with actionable recommendations

Data Transformations

Transform your data during import with powerful mapping and calculation capabilities.

Value Mappings: Transform codes (0/1 → Inactive/Active)
Calculated Columns: Create computed fields (subtotal, tax, total)
French Code Translation: Auto-translate French codes (ENTRÉE→inbound)

Data Validation

Ensure data integrity with comprehensive validation rules that check for uniqueness, format compliance, and data consistency.

Unique constraints
Not null validation
Regex pattern matching
Range validation
Custom validation rules

Data Quality Profiling

Multi-dimensional quality scoring (0-100) with letter grades:

Completeness (30%): Null value analysis
Uniqueness (25%): Duplicate detection
Validity (25%): Type and format checking
Consistency (20%): Value distribution analysis

Export Capabilities

Export tables back to Excel files
Custom SQL queries as sheets
Multiple format support

Use Cases

E-commerce

Import product catalogs, manage inventory, track orders.

Data Migration

Migrate data from Excel-based systems to proper SQL databases.

Data Quality

Profile, analyze, and improve data quality with automated recommendations.

Reporting

Generate reports by querying SQLite and exporting to Excel.

Architecture

ETS is built with:

Python: Core data processing with pandas and openpyxl
SQLite: Embedded SQL database for queries
Click: CLI framework
Pydantic: Data validation

Installation

pip install excel-to-sql