DEV Community

Colby Cardell
Colby Cardell

Posted on

CSV Studio — DuckDB Edition: Upload CSV/XLSX Filter CRUD Export (free, no backend)

Live demo: https://csv-studio-duckdb.streamlit.app

Code: https://github.com/xXBricksquadXx/csv-studio-duckdb

CSV Studio — 38k rows with CRUD, filters, pagination

What it does (in ~30s)

  • Upload CSV/TSV/XLSX or paste a CSV URL
  • Filter by text / category / date / metric + global search
  • KPIs + Plotly charts (time series, by category)
  • Stable CRUD (add / update / delete) with pagination for large files
  • Export page CSV, filtered CSV, or full dataset
  • No backend, no DB to manage — powered by DuckDB + pandas

Quickstart (local)

python -m venv .venv
.\.venv\Scripts\Activate.ps1     # (mac/linux: source .venv/bin/activate)
pip install -r requirements.txt
python -m streamlit run app.py
Enter fullscreen mode Exit fullscreen mode

  • Why DuckDB? “Analytics-grade SQL in memory; zero setup; great on CSVs.”
  • Privacy note: “Files stay in your browser / Streamlit session; export explicitly when done.”
  • Roadmap: “Parquet export, saved views, URL-param presets, light/auto theme.”

End CTA (copy/paste)


md
If this saves you time, ⭐ the repo and drop a comment with:
- datasets you want preloaded
- features you’d use (Parquet export? Saved filters?)

**Demo:** https://csv-studio-duckdb.streamlit.app  
**Repo:** https://github.com/xXBricksquadXx/csv-studio-duckdb

Enter fullscreen mode Exit fullscreen mode

Top comments (0)