Day: April 13, 2025
-
Structured CSV: Expressing XML Hierarchies in a Single Sheet
Views: 2 Structured CSV: Expressing XML Hierarchies in a Single Sheet Nobuyuki Sambuichi 2025-04-13 Structured CSV is a standards-based format derived from the xBRL-CSV specification, enabling complex hierarchical data to be recorded in a flat, tabular form. It is not a simple dump of relational tables. Instead, it uses structured conventions and a metadata-driven approach to express multi-level business documents — such as invoices or journal entries — in a single CSV sheet. 1. Based on xBRL-CSV Structured CSV follows the xBRL-CSV syntax model, where: A CSV file holds the fact data — one row per fact. A JSON metadata file defines the table structure, the dimensions and members for […]