Frontmatter to CSV
Bulk-harvest frontmatter from a folder of markdown files into a single CSV. The header row is the union of every key seen; each row is one source file. Hugo / Astro / Jekyll content inventories in one drop.
About Frontmatter to CSV
Frontmatter to CSV harvests the YAML frontmatter from your markdown files and flattens it into a single spreadsheet. The header row is the union of every key it sees across all files, and each row represents one source file, giving you an instant content inventory for a Hugo, Astro, Jekyll, or Gatsby site. It works in your browser, so your unpublished drafts and metadata stay on your machine.
- Category
- convert
- Input
- Accepts: text/markdown or text/plain.
- Output
- Outputs: text/csv (multiple).
- Cost
- Free, runs in your browser
- Memory
- low
Common uses
- Build a content audit spreadsheet of titles, dates, tags, and slugs across a Hugo blog
- Find Astro posts missing a description or canonical field by scanning for blank CSV cells
- Inventory which Jekyll articles are still marked draft: true before a site relaunch
- Cross-check publish dates and authors across a Gatsby content folder in one view
- Export frontmatter to CSV so a non-technical editor can review metadata in a spreadsheet
- Spot inconsistent tag or category naming across hundreds of markdown files at a glance
Frequently asked questions
What input does it expect?
Markdown files (or plain text containing YAML frontmatter); it reads the frontmatter block delimited at the top of each file.
What happens when files have different keys?
The CSV header is the union of every key found, so a file that lacks a given key simply has an empty cell in that column.
Are my markdown files uploaded?
No. Parsing and CSV generation happen entirely in your browser, so file contents never leave your device.
Which static site generators does it suit?
Any generator that uses YAML frontmatter, including Hugo, Astro, Jekyll, and Gatsby.
What's in each row?
One row per source file, with its frontmatter values mapped to the matching columns of the unified header.
Keywords
- frontmatter
- csv
- markdown
- hugo
- astro
- jekyll
- gatsby
- inventory
- bulk
- metadata