RividTechRividTech Experts Team
The RividTech Experts Team builds and maintains RividTech's data tools and writes its guides. Every guide is checked against the tools' actual behavior and updated when that behavior changes.
How we write
Our guides cover the day-to-day mechanics of data operations: why a CSV opens as one column, how Excel changes IDs and dates, when to reach for SQL instead of a spreadsheet, and how tools such as pandas, DuckDB, and jq handle the same jobs. We write for analysts, developers, and operations staff who need a working answer, not a sales pitch.
When a guide describes how a RividTech tool behaves, we check the claim against the tool itself. Where it covers third-party software, we link to the project's own documentation. When a tool or a library changes, we update the affected articles and show the updated date at the top.
Found a mistake, or have a data problem you would like covered? Email info@rividtech.online or use the contact form. More about the project is on our About page.
Articles (17)
- RividTech Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
Excel Won't Open My Large CSV (1M+ Rows) - What to Do
Excel stops at 1,048,576 rows and chokes on big CSVs. Export smaller batches and filter the file before converting it for Excel.
ExcelCSVXLSX - RividTech Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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 Experts Team
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