# xlwings Lite Data Tools Hub

Hub page for four data integration tools in xlwings Lite: import from cloud, convert files, connect to databases, and auto-detect schemas with AI.

## Links
- App: https://app.tigzig.com/xlwings-data-tools

## Tags
python-in-excel, xlwings-lite, duckdb

## Tools

### xlwings Lite Data Importer
Import CSV, Excel, Parquet, JSON, and DuckDB files from remote URLs directly into Excel. Supports Google Drive, Dropbox, GitHub, and custom URLs with token access for private files.
- App Page: https://app.tigzig.com/xlwings-data-importer

### DuckIt App
Convert CSV/TSV files to DuckDB or Parquet format. Get shareable URLs for xlwings Lite import. Browser-based conversion with signed URL generation.
- App Page: https://app.tigzig.com/duckit-xlwings

### Database Connect
Connect to PostgreSQL/MySQL databases directly from Excel. Run SQL queries, explore tables, perform EDA, and build ML models with XGBoost.
- App Page: https://app.tigzig.com/xlwings-api-db

### LLM API Schema Detection
Automatic schema detection using Gemini or OpenAI. Identify data types, categorical vs numerical variables, and generate SQL-compatible schemas for automation workflows.
- App Page: https://app.tigzig.com/xlwings-llm-api