# xlwings Lite Data Tools

Four tools for integrating data into Excel with xlwings Lite - import from cloud, convert files, connect to databases, and auto-detect schemas with AI.

## The Four 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.

 Go to App Page ->
 ](/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.

 Go to App Page ->
 ](/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.

 Go to App Page ->
 ](/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.

 Go to App Page ->
 ](/xlwings-llm-api)

---
Source: https://www.tigzig.com/xlwings-data-tools

---
Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar
Source: https://www.tigzig.com/xlwings-data-tools
Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar.
License: https://www.tigzig.com/terms