XMLからCSVコンバータ
ガイド
XMLからCSVコンバータ
Paste any XML document and convert its repeating records into a flat CSV file. The tool auto-detects the row element and the columns from element tags and attributes, previews the first 10 rows, and lets you download the full CSV — useful for migrating data out of legacy systems, exports, or any XML feed into spreadsheets and ETL pipelines.
使用方法
- Paste your XML into the input area, or drag and drop an .xml file onto the uploader.
- Leave the row element blank to let the tool auto-detect the most common child of the root, or type a tag name (e.g.
order,record,item) to target a specific repeating element. - Pick a delimiter (comma, semicolon, tab, or pipe) and a line ending (LF or CRLF) that matches the system you are exporting to.
- Toggle whether to include a header row, whether to capture XML attributes as additional columns, and whether to trim whitespace from values.
- Review the preview (first 10 rows) and the row/column summary, then click the download icon to save the full CSV.
機能
- Auto-detect row element – Picks the most common direct child of the root so most XML documents work without configuration.
- Attribute capture – XML attributes can be promoted to their own columns with a configurable prefix (default
@) so they are easy to distinguish from element columns. - Union-of-keys columns – Headers are inferred from every row, so optional or sparsely-populated fields still appear in the output.
- RFC 4180 escaping – Values containing the delimiter, double quotes, or newlines are automatically quoted and escaped.
- Configurable delimiter and line ending – Comma, semicolon, tab, or pipe; LF or CRLF — match exactly what your downstream tool expects.
- Preview + full download – The on-screen preview is capped to the first 10 rows so the page stays responsive, while Copy and Download always operate on the complete output.
- ブラウザ内で完全に動作 – Your XML never leaves your machine, which matters when the data contains customer or business records.
ベース64画像文字列に遭遇し、それが実際に何であるかを確認する必要があるとき、このツールを使います。APIレスポンスに埋め込まれたサムネイルをデバッグする、CSSやHTMLメールに埋め込まれた画像を確認する、トラッキングピクセルを逆エンジニアリングする、画像生成APIからの出力の確認を行う、またはデータベースエクスポートから資産を回復するなどです。レンダリングがブラウザ内で行われるため、プロダクションに送信する前にベース64パラメータが正しく構成されているかを迅速に確認する手段としても使えます。
- Legacy data migration – Pull records out of older systems that only export XML and load them into spreadsheets, BI tools, or modern databases.
- Open data feeds – Many government and research datasets are still distributed as XML; CSV is much friendlier for analysis.
- API responses – Quickly flatten an XML API response into a tabular form for spot-checking or sharing with non-technical stakeholders.
- SaaS exports – Several enterprise SaaS products only emit XML on export; CSV is what spreadsheets, dashboards, and ETL tools expect on import.
よくある質問
-
What does it mean to flatten XML into CSV?
XML is hierarchical — elements can nest inside other elements to arbitrary depth. CSV is flat — every row has the same set of columns. Flattening means picking one repeating XML element as the row and turning each of its child fields and attributes into a column. Deeply nested branches are typically collapsed to their text content or joined with a separator, which is why CSV is great for tabular data but lossy for true tree structures.
-
Why does CSV need a special escaping rule for commas, quotes, and newlines?
CSV is a delimited format, so any literal delimiter, quote, or line break inside a value would be misread as a column or row boundary. RFC 4180 solves this by wrapping such values in double quotes and escaping any embedded double quotes by doubling them (""). This keeps the format simple to parse with a small state machine while still allowing arbitrary text in fields.
-
Why are XML attributes treated differently from child elements?
In XML, attributes live on the opening tag and child elements live inside it, but in CSV both end up as columns. Tools usually distinguish them by prefixing attribute columns (commonly with @) so a downstream consumer can tell that an attribute @id is metadata about a row, not a sibling field. This convention also avoids name collisions when an element and an attribute share the same name.
-
What is the difference between LF and CRLF line endings in CSV files?
LF (\n) is the Unix and macOS line ending; CRLF (\r\n) is the Windows convention and is the line ending that RFC 4180 actually specifies. Modern parsers accept both, but some legacy Windows tools — and Excel on Windows when opening a file with mixed endings — behave best with CRLF. Picking the right line ending up front avoids subtle import errors downstream.
-
Why is column auto-detection based on a union of keys across rows?
Real-world XML often has optional elements — some records carry an attribute or sub-element that others do not. If you only used the first record's fields as the column list, every later optional field would silently disappear. Taking the union of keys seen across all rows guarantees that every distinct field gets its own column, with empty cells for rows that did not include it.
