Skip to content

0.2.0

Latest

Choose a tag to compare

@NoteNerdOfficial NoteNerdOfficial released this 06 Aug 03:09

Excel workbooks convert in full.

Hidden sheets were being skipped on the assumption that hiding one says the
data doesn't matter. It doesn't — hiding is a presentation choice, and a
workbook's hidden sheets are as often the raw table a visible pivot summarises
as they are scratch space. Skipping them quietly dropped the data the note was
about.

  • Every sheet is converted, hidden ones included. Convert hidden sheets
    in settings turns that off.
  • Skipped sheets are named, not counted. Skipped (hidden): raw data (monthly), Region, Agebracket instead of 18 hidden sheets skipped — a
    count tells a reader nothing they can act on. Empty sheets, and sheets whose
    worksheet part is missing from the file, are named the same way; the latter
    used to vanish without a trace.
  • Coverage is in the frontmatter. sheets_converted: 23/23 at the top of
    the note, so how much of the workbook made it across is the first thing you
    see rather than a footnote after two thousand lines.
  • Load-bearing hidden sheets are kept regardless of the setting. If a
    visible sheet's formulas, a pivot cache, a chart series or a workbook-scoped
    named range reads from a hidden sheet, it is converted and reported. That
    dependency is a far stronger signal than the hidden flag.

Nothing changed in how cells are read: dates still come out as dates,
percentages as percentages, and 27.38 still isn't 27.383982300884924.

Installing

Copy main.js and manifest.json into
<vault>/.obsidian/plugins/convert-to-markdown/, then enable Convert to
Markdown
under Community plugins. Existing installs update from within
Obsidian.

Desktop only.