How to quickly add Excel/Word tables to Markdown while keeping table style?
When writing Markdown documents, manually entering table syntax (like | --- |) is very tedious. Especially when dealing with large amounts of data from Excel, Word, or web pages, how to quickly convert and maintain the original table structure is a pain point for many developers.
Using this tool, you just need to copy and paste directly to complete the conversion. Specifically, for copying web/html tables, formatted text, and rich text, this program provides perfect compatibility support. It automatically recognizes complex HTML structures and precisely converts them into standard Markdown syntax, allowing you to maintain efficient work without worrying about format disorder.
How to convert rich text tables to Markdown tables?
What table formats are supported?
No matter how complex the layout, as long as the table exists in the clipboard in HTML format, this tool can convert it at high speed:
- Web Tables: Including Jira entry tables, Confluence documents, various management systems, and back-end data statistics tables.
- Office Software: Microsoft Word tables, Excel spreadsheets, WPS documents, and tables.
- Instant Messaging: Supports tables copied directly from chat records such as DingTalk, Lark, WeChat Work, etc.
What is the format of the converted table?
We simplify complex HTML tags, retaining basic cell alignment (default left alignment) and data content. Here is an example of a converted output:
| Name | Position | Address | | --- | --- | --- | | John | Architect | Tokyo | | Lee | Product Manager | Paris | | Wang | UI Designer | Rome |
The converted Markdown can be pasted directly into platforms that support Markdown such as GitHub, Notion, Juejin, Zhihu, etc.
When chatting with AI, complex tables are difficult for AI to understand. Markdown tables are the easiest table format for AI to understand, so we convert complex tables to Markdown tables, and then Markdown tables to plain text format, so AI can understand more easily.
Plain text format (CSV) is suitable for scenarios where simple data exchange is needed, such as exporting to Excel tables or importing into other data processing tools.