> [!tldr] 1 [[Markdown]] file = 1 [[CSV]] row
A folder of Markdown files with [[Frontmatter]] can be unambiguously and losslessly translated into a CSV file with one row per markdown file.
You just need to map file name, file body, and and use existing Frontmatter keys as header.
> [!warning] [[Don't Nest Frontmatter]]
> Keep the [[YAML]] Frontmatter **flat**.
You can extend that in the context of [[Spreadsheet]]s rather than simple CSVs to say:
> [!tip] CSV-Excel Structural Equivalency
> 1 folder = 1 sheet
> 1 [[Markdown]] file = 1 sheet row
## Obsidian Importer
The [[Obsidian]] importer plugin is excellent and natively supports converting a [[CSV]] file to many markdown notes.
## [[Obsidian Bases]] Exports
Obsidian Bases also let you export to CSV natively. The only **limitation is there's no support for exporting the note body**.
So obsidian treats the body of a note as a fundamentally unique and distinct part from the metadata about it.
****
# More
## Source
- self