Skip to main content

Mapping: Excel to Markdown

Read a sheet from an Excel file and render a Markdown document from it: the row template is rendered once per row, rows are joined by the separator, and the result is optionally wrapped in a document header and footer. Rows that do not pass the optional row filter are skipped.

Input​

Excel filerequired
Source Excel file to read from.

Parameters​

Sheet namerequired

Name of the tab to read inside the source Excel file (ex: Orders).

Start row

The first row to render from the sheet. Rows are numbered from 1. Leave empty to start from the first row. Useful when the file has a header row to skip.

Row templaterequired

Text rendered once per row. Placeholders are replaced for each row:

  • {A}, {B}, … {AC}: value of the cell in that column
  • {index}: 1-based position of the row among rendered (post-filter) rows
  • {uuid}: a fresh UUID v4, stable within a single row
  • {date} / {time} / {datetime}: generation timestamp (UTC)
  • {sheet}: the sheet name
Row separatorrequired

Text inserted between consecutive rendered rows (ex: a blank line). Not written before the first row or after the last.

Document header

Written verbatim before the first row. Use it for a title, table of contents, etc. Leave empty to skip.

Document footer

Written verbatim after the last row. Leave empty to skip.

Row filter

Only rows matching the conditions are rendered. Leave empty to render every row. Each condition is made of a column letter, an operator and — depending on the operator — a value:

  • Equals / Does not equal
  • Contains / Does not contain
  • Is one of (comma-separated list of values)
  • Starts with / Ends with
  • Is empty / Is not empty (no value)

When several conditions are set, choose whether a row must match all of them (Match all) or at least one (Match any).

Output​

Markdown file

Generated Markdown document: header, then one rendered template per kept row joined by the separator, then footer.