Best used with an AI agent

40+ live apps, open data APIs, MCP servers, and 200+ guides - more than anyone wants to click through. Point your AI here and it reads the whole map and does the work: finds the tool, pulls the data, runs the analysis, and hands you the links.

Here for the open-source code? Your agent finds the right repo for you - and can even clone and deploy it.

Prefer to explore on your own? Go right ahead.

Paste this to Claude Code, Codex, or any AI agent:
Go to tigzig.com and read tigzig.com/llms.txt. It is a practitioner toolkit - 40+ analytics apps, open no-auth data APIs, MCP servers, open-source repos (github.com/amararun), and 200+ build guides. Help me [your task]. Surface the exact links; where there is an API or MCP, call it directly; and if I want to self-host, find the repo and help me deploy it.

DuckDB Meets Excel: xlwings Lite Data Tools

Published: January 9, 2026

xlwings Lite runs Python in Excel - you get DuckDB, Pandas, ML libraries right inside Excel. The constraint: it can't access your local file system due to browser restrictions.

That's a problem for large datasets. You have a 1.2 GB DuckDB file on GitHub. Or a 1.5 GB CSV from a client. Or a SQLite database or a JSON dump....

xlwings Lite can process them - but how do you get them in?

I built two tools to solve this.

Tool 1: DuckIt - File Converter & Hosting

Drop CSV files, get back DuckDB or Parquet with shareable link. Paste that link into xlwings Lite, start querying. Tested with 1.5 GB CSVs, 10M+ records. Or upload existing DuckDB/Parquet for instant sharing.

DuckIt Diagram

Tool 2: xlwings Lite Data Importer

Pulls files from URLs directly into Excel. Paste URL, click import. Works with DuckIt, GitHub, Google Drive, Dropbox.

Handles DuckDB, SQLite, CSV, Parquet, JSON. Auto-detects file type, loads directly into DuckDB. Parquet remains as is. Tested up to 1.2 GB DuckDB download, 20M+ records.

xlwings Downloader

Example Workflow

Client sends 1 GB CSV. Upload to DuckIt get DuckDB link paste in Excel query with SQL. No email attachments, no local file management.

DuckIt xlwings

Technical Details

DuckIt does CSV-to-Parquet conversion in-browser, backend creates DuckDB with time-limited signed URLs. Importer runs in xlwings Lite with CORS bypass via Cloudflare Worker. Multi-level file type detection (URL header magic bytes).

Both tools open source. Full technical details, how-to, and live demo files at links below.

Privacy Notice

Files stored on my server with time-limited signed URLs. API calls logged. Directory access is token authenticated. Free service, no guarantees. Deploy your own for production use.

Built with xlwings Lite by Felix Zumstein

xlwings Lite official site: lite.xlwings.org