SQLからCSV・TSV変換 開発者リファレンス
SQLのINSERT INTO文、データベースダンプ、複数行バッチデータをRFC 4180準拠のCSV、TSV、Markdown表形式へ安全に変換するための技術解説です。
区切り文字 (デリミタ):
NULL値の表記:
Samples:
SQL INSERT文 / ダンプデータ6 lines
変換データプレビュー (CSV)
Live Data Grid (5 rows × 7 columns)
| id | name | role | balance | is_active | created_at | |
|---|---|---|---|---|---|---|
| 1 | Sarah Connor | [email protected] | admin | 4500.50 | 1 | 2024-01-15 08:30:00 |
| 2 | John Doe | [email protected] | user | 120.00 | 1 | 2024-02-10 14:22:15 |
| 3 | Grace Hopper | [email protected] | moderator | 9800.75 | 1 | 2024-03-01 11:05:40 |
| 4 | Miles Dyson | [email protected] | developer | 3100.00 | 0 | 2024-03-12 16:45:00 |
| 5 | Anonymous User | NULL | guest | 0.00 | 1 | 2024-03-20 09:12:33 |
抽出レコード数5
カラム数7
出力サイズ397 B
Parsing Health100% OK
100% Client-Side Privacy
Your confidential database dumps, user emails, and internal table records never touch an external server or API.
Multi-Format Tabular Export
Seamlessly export to RFC 4180 compliant CSV, TSV for spreadsheets, Markdown tables for pull requests, or structured JSON arrays.
High Precision SQL Tokenizer
Robustly extracts multiple values batches, unescapes SQL single quotes, preserves null identifiers, and parses complex multi-statement dumps.