RividTechBlog
Practical notes on private, browser-based data tools — how they work, why they keep your data safe, and how to get more from CSV, TSV, JSON, and Excel.
- RividTech
DuckDB 2.0 Alpha: What's New for CSV and JSON Processing
DuckDB 2.0 alpha brings VARIANT JSON, diff/merge patch functions, and faster CSV I/O. Here is what matters for CSV/JSON work — plus the no-install browser equivalent.
DuckDBSQLCSV - RividTech
DuckDB vs SQLite: Which One Fits Your CSV and JSON Work?
Both are single-file SQL with no server — but DuckDB is analytics-first, SQLite is transactions-first. Here is how to pick for CSV/JSON work.
DuckDBSQLiteSQL - RividTech
JSONL / NDJSON Explained: From AI APIs and Logs to CSV
AI APIs, logs, and open datasets speak JSONL — one JSON object per line. Flatten nested records and convert to CSV or Excel without uploading.
JSONJSONLCSV - RividTech
Don't Paste Customer CSV Into ChatGPT — Prep Data for AI Safely
AI plus raw customer CSV is a privacy incident waiting to happen. Scrub, shrink, and validate locally first — then prompt safely.
AIprivacyCSV - RividTech
Excel Won't Open My Large CSV (1M+ Rows) — What to Do
Excel stops at 1,048,576 rows and chokes on big CSVs. Split, sample, and filter the file in your browser — then export what Excel can open.
ExcelCSVXLSX - RividTech
Run SQL on CSV in Your Browser — No Upload, No Install
SELECT * FROM orders.csv WHERE status = 'paid' — without a database or upload. How to think in SQL and run it privately in your browser.
SQLCSVJSON - RividTech
Pandas 3.0 Broke My CSV Script — Fixes for 2026
Pandas 3.0 changed string dtypes, copy-on-write, and removed old APIs. Here is how to fix broken read_csv scripts — and when a browser tool is faster.
pandasCSVPython - RividTech
10 Common CSV Formatting Mistakes (and How to Fix Them Instantly)
CSV files break imports for a handful of predictable reasons — wrong delimiters, stray BOM bytes, mixed line endings, and more. Here is a fast checklist to identify and fix each one.
CSVdata cleaningExcel - RividTech
How to Use Pandas for CSV and JSON Data Processing
Load, clean, filter, and reshape CSV and JSON with pandas — then chart results with matplotlib. Practical code for everyday data work, plus when a browser tool is enough.
pandasCSVJSON - RividTech
Tools to Process CSV Files in the Terminal
csvkit, xsv, Miller, and classic Unix tools can cut, filter, and reshape CSV from the shell. Learn the commands you will actually use — and when a browser tool is enough.
CSVterminalCLI - RividTech
jq for JSON Processing from the Terminal
jq is the standard CLI for slicing, filtering, and reshaping JSON. Learn the filters you actually use day to day — and when a browser tool is enough instead.
JSONjqterminal - RividTech
Flatten Nested JSON for Spreadsheets and CSV
APIs return nested JSON; spreadsheets want flat tables. Here is how to flatten objects and arrays into columns you can open as CSV or Excel.
JSONCSVflatten - RividTech
Excel to CSV (and Back) Without Losing Data
Excel workbooks hold sheets, types, and formatting that CSV cannot fully represent. Here is how to convert Excel ↔ CSV without the usual data-loss surprises.
ExcelCSVXLSX - RividTech
How to Clean Messy CSV Files: Delimiters, Duplicates & Validation
Most CSV pain is not “big data” — it is messy delimiters, duplicate rows, and broken headers. Here is a practical cleanup workflow that stays private in your browser.
CSVdata cleaningvalidation - RividTech
How to Convert CSV to JSON Safely in Your Browser
CSV to JSON is one of the most common data conversions — and one of the riskiest to do on a random website. Here is how to do it safely in your browser.
CSVJSONprivacy - RividTech
CSV vs TSV vs JSON: When to Use Each Format
CSV is the spreadsheet workhorse, TSV avoids comma headaches, and JSON handles nested structure. Learn when each format wins and how to convert between them in your browser.
CSVTSVJSON - RividTech
Why Browser-Only CSV Tools Are Safer for Your Data
Online converters usually upload your data to a server you don't control. Browser-only tools like RividTech run entirely on your device, so your files never leave your machine.
privacyCSVdata security