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)