Excel to Markdown Converter
Paste the following prompt into your AI chat to install this skill:
Please follow https://skillhub.cn/install/skillhub.md to install @user_d81eb31c/excel-to-md into my AI assistant.
About this skill
Why excel-to-md exists
When documenting data, maintaining knowledge bases, or preparing table context for models, Excel files often enter Markdown as screenshots, copy-paste fragments, or inconsistent formatting. Manual conversion can lose headers, merged cells, empty values, and numeric precision. excel-to-md targets a narrow problem: convert .xlsx and .xls worksheets into stable, renderable Markdown tables while preserving the original structure as much as possible.
How it works
The skill runs on Python 3 with openpyxl and pandas, treating workbooks as read-only inputs. Common workflows include converting an Excel file by default, writing to an explicit output path, previewing without saving, listing worksheets, converting selected sheets, and batch-processing all Excel files in a directory.
The output follows Markdown table conventions: ordinary cells are emitted as-is, merged cells place the value in the first cell and leave the rest empty, dates become YYYY-MM-DD HH:mm, overly long content is truncated to 200 characters, and header rows use --- separators with multi-row header support. The design emphasizes idempotency, no source-file mutation, and explicit output paths, making it suitable for scripts, repeated runs, and documentation pipelines.
Scope and limits
It fits office-efficiency tasks where table data needs to move into notes, wikis, READMEs, or prompt context. It does not cover complex formula evaluation, pivot analysis, chart reconstruction, style preservation, or HTML/JSON generation. Merged cells are flattened into a text table, so semantically dense sheets may need manual annotations. For batch conversion, confirm file naming and destination paths before writing to avoid overwriting existing Markdown documents.
Use Cases
- Convert multiple sheets from an acceptance workbook into README appendices for engineering review.
- Turn a monthly cost .xlsx ledger into Markdown for publishing on a Wiki page.
- Preview merged-cell output first, then decide whether to convert only selected worksheets.
- Batch-convert multiple .xls inspection logs in a directory into document attachments.
Best For
- Engineers who maintain docs: need Excel data converted into reusable Markdown.
- Product managers who maintain Wiki or README pages: need tables rendered as clean documents.
- Technical support teams who archive knowledge: need multiple .xlsx ticket records batch-converted.
- Automation engineers: need idempotent, read-only conversion with explicit output paths.
Related Skills
Organizes files by extension into subfolders like Documents, Code, and Archives, then outputs a report.
Extract tables, formulas, charts, and layout from invoices, reports, papers, and multi-column documents.
Generates a multi-sheet Excel report containing only structured data tables from byteplan-analysis results.
Automatically sort directory files into type-based folders, with dry-run preview, reports, and JSON custom rules.