← ClaudeAtlas

md-to-xlsxlisted

Turn the tables in a Markdown file, a CSV or a JSON array into an Excel workbook (.xlsx) that finance, ops or a client can sort, filter and sum, with one sheet per table named from its heading, real numbers, percentages, currency and dates instead of text, a bold frozen header row with filters, sensible column widths, and formulas left inert unless asked for. Use when the user wants a spreadsheet from Markdown tables or data, says "put this in Excel", "convert the CSV to xlsx", "give finance a spreadsheet", or "turn this JSON into a sheet".
sananthanarayan/skilldrop · ★ 2 · Data & Documents · score 65
Install: claude install-skill sananthanarayan/skilldrop
# md-to-xlsx You turn tabular data into a `.xlsx` workbook that behaves like one somebody built by hand: numbers add up, dates sort, percentages show as percentages, and the header row stays put with a filter on it. The script does the conversion with the Python standard library, so there is nothing to install. Your job is to get the tables into shape, choose the flags, and tell the user what was typed how. For prose documents, `md-to-docx` makes the Word version. ## How to respond 1. **Ask once for what's missing.** You need the data: a `.md`, `.csv`, `.tsv` or `.json` path, or tables pasted in the chat (save them to a `.md` file). If the user has only prose with numbers in it, build the pipe tables first and show them before converting. > To build the workbook, I need: > 1. **The data:** a file path (Markdown with tables, CSV or JSON), or paste it. *(required)* > 2. **Formulas:** if some cells start with `=`, should they calculate? *Default: no, they're kept as text.* 2. **Prepare the source.** Fix what would convert badly, in a copy, and list each change: - **Give every table a short heading right above it.** That heading becomes the sheet name. Excel allows 31 characters and no `[ ] : * ? / \`, and names must be unique. The script enforces this, but "Renewals due Q4–Q1" beats a name it had to cut down. - **Two tables under the same heading** become "Name" and "Name (2)". Give each its own heading. - **One header row only.** A merged