Quick Start

Quick Installation

Install excel-to-sql using pip, the standard Python package manager.

pip install excel-to-sql

Verify installation:

excel-to-sql version

Your First Import in 3 Steps

Step 1: Initialize Project

Create a new project with the required directory structure.

excel-to-sql init

This creates the project structure with data/, config/, imports/, and exports/ directories.

Step 2: Add Configuration

Define how your Excel file should be imported into the database.

excel-to-sql config add --type products --table products --pk id

Step 3: Import Your Excel File

Import your data using the configuration you just created.

excel-to-sql import --file products.xlsx --type products

That's it! Your data is now in SQLite.

Auto-Pilot Mode (Recommended)

Skip manual configuration and let Auto-Pilot analyze your Excel files to automatically detect patterns and generate optimal configurations.

For automatic configuration without manual setup:

excel-to-sql magic --data ./excels --interactive

Auto-Pilot automatically detects:

• Primary and foreign keys
• Value mappings (e.g., "1"/"0" → "Active"/"Inactive")
• Data quality issues
• Optimal data types

What's Next?

• What is ETS - Learn more about excel-to-sql
• Installation - Detailed installation guide
• CLI Reference - All CLI commands
• Auto-Pilot Mode - Automatic configuration guide
• Python SDK - Programmatic usage
• Examples - Real-world examples

Key Features

• Smart Import: Automatic schema detection
• Auto-Pilot Mode: Zero-configuration setup with pattern detection
• Data Transformations: Value mappings, calculated columns
• Quality Analysis: Comprehensive scoring and reporting
• Python SDK: Full programmatic access
• Validation: Ensure data integrity with rules

Get Help

excel-to-sql --help
excel-to-sql <command> --help

Or visit: https://github.com/wareflowx/excel-to-sql/issues