CSV / Data Studio | Column Sorting, Column Filter, YAML/TOML - Features & Free Guide | Shamoji DRIVE
Format, Filter, Sort & Transform CSV/TSV into JSON, YAML, TOML, Markdown & note KaTeX Tables in Real Time
Filter columns, reorder fields, sort rows by column, toggle delimiters, escape per RFC 4180 standards, and seamlessly convert tabular data to JSON, YAML, TOML, SQL Insert statements, Markdown tables, and note.com KaTeX math tables.
Recommended Use Cases
- Extract & Reorder Key Columns for Export: Filter massive CSV dumps to only the columns you need (e.g. emails and user IDs) with simple checkboxes, and reorder columns for instant export.
- CSV to note.com / KaTeX Math Table Generator: Publish clean bordered tables on platforms like note.com without native table tools. Simply copy the generated KaTeX array syntax into a math block ($ ... $) for instant table rendering.
- Batch Convert CSV/TSV to JSON, YAML & TOML: Paste tables copied from Excel or Google Sheets to generate structured JSON arrays, YAML documents, or TOML files for web apps and configuration seeds.
- Generate Clean Markdown Tables for GitHub & Notion: Turn messy CSV data or spreadsheets into perfectly formatted GitHub Flavored Markdown (GFM) tables for PRs, release notes, and documentation.
- Generate SQL INSERT Statements Automatically: Convert tabular rows into executable `INSERT INTO table (col1, col2) VALUES (...)` queries for fast database seeding and testing.
Key Features
- Column-Aware Sorting (Numeric, Natural, String, Asc/Desc): Intelligently sorts rows based on chosen column data types, supporting numeric value ordering, natural sort (1, 2, 10...), and lexicographical order.
- Instant Delimiter Conversion (Comma, Tab, Semicolon, Pipe): Easily switch between standard CSV, European semicolon CSV, TSV (tab-separated), and pipe-delimited records.
- Strict RFC 4180 Escaping & Quoting Compliance: Accurately parses and generates double-quote escapes for multiline text cells, internal commas, and embedded quotes.
- 9 Supported Output Formats (JSON/YAML/TOML/XML/SQL/Markdown/note KaTeX/TSV): Cross-transpile to all major developer formats with automated header detection, smart type inference, and LaTeX/KaTeX array math table generation for note.com.
- 100% Client-Side Sandbox • Zero Server Uploads: All parsing and transformations execute in browser memory. Sensitive customer records and corporate financials never leave your machine.
How to Use
- Paste or Drop CSV/TSV File: Paste text directly or drag-and-drop a file. Delimiters are detected automatically.
- Configure Columns & Sorting: Select columns to include, choose a sort key, and toggle ascending/descending order.
- Select Format & Copy or Export: Choose JSON, YAML, Markdown, SQL, note (KaTeX), or TSV, and copy to clipboard or download as a file.
Frequently Asked Questions (FAQ)
- Q. Is it safe to process confidential company records and financial data?
- A. Yes, absolutely. The tool operates 100% client-side inside your browser sandbox. No data is sent over the network, ensuring compliance with strict privacy and security policies.
- Q. How can I insert a table into note.com articles?
- A. While note.com does not have a native table feature, it supports KaTeX math equations. Select "note (KaTeX Table)" in this tool, copy the generated LaTeX/KaTeX array code, and paste it into a math block ($ ... $) in the note.com editor to display a cleanly formatted bordered table.
- Q. Can it handle CSV cells containing line breaks or commas?
- A. Yes, it complies strictly with RFC 4180 standards, correctly preserving multiline text and double-quote escaped values.
- Q. Can I import TSV (tab-separated) or semicolon files?
- A. Yes, the parser automatically detects commas, tabs, semicolons, and pipes, or you can explicitly specify the delimiter.
- Q. Are numbers and booleans preserved as types when converting to JSON?
- A. Yes, smart type inference automatically identifies numeric values, booleans (true/false), and nulls, outputting native JSON types.
Keywords: CSV to JSON Converter / note.com Table KaTeX / CSV to LaTeX Table / KaTeX Table Generator / CSV TSV Converter / CSV Column Filter / CSV Sort Online / CSV to YAML / CSV to Markdown Table / CSV to SQL INSERT / RFC 4180 CSV Tool