Online tools
Markdown table to Excel (works on AI chat tables)
A free Duaer tool: paste a Markdown table, including one from an AI chat reply, and download Excel or CSV. Several tables become several sheets.
How to use it
- Copy the reply (or the raw Markdown) from your AI chat and paste it into the text box above.
- Click "Convert" and check the preview.
- Click "Download .xlsx" or "Download .csv".
Conversion rules
- A table needs a separator row like `|---|---|` under the header; text around tables is ignored.
- `**bold**` and code markers are removed, `<br>` becomes a line break inside the cell, and `\|` turns back into a pipe.
- Numbers become numeric cells; long codes stay text.
Automate it in Duaer
When an AI Agent node replies with a Markdown table, a Duaer Code node can split it into items before Convert to File › Convert to XLSX:
const separator = /^\s*\|?\s*:?-+:?\s*(\|\s*:?-+:?\s*)*\|?\s*$/;
const out = [];
for (const item of $input.all()) {
const rows = String(item.json.output ?? '')
.split('\n')
.filter((line) => line.trim().startsWith('|') && !separator.test(line))
.map((line) => line.trim().replace(/^\||\|$/g, '').split('|').map((cell) => cell.trim()));
const [header, ...body] = rows;
for (const row of body) {
out.push({ json: Object.fromEntries(header.map((name, i) => [name, row[i] ?? ''])) });
}
}
return out;`output` is the AI Agent reply field; change it to your field name.
Questions
The table I copied from a chat has no pipes.
Some chat apps copy a formatted table. Look for "Copy Markdown" or "Copy raw" first, then paste it into the Duaer converter.
The reply has several tables.
The Duaer converter puts each table on its own sheet, and you can pick which one to export as CSV.
In this section
Free file converters from Duaer
Free Duaer tools for spreadsheets and data files: convert formats, merge, split, remove duplicates, fix encodings, and format JSON. Everything runs in your browser and no file is uploaded.
File conversionCSV to Excel converter (free, no upload)
A free Duaer tool that turns CSV into .xlsx in your browser. It detects UTF-8 or GBK, keeps long IDs as text, and never uploads the file.
File conversionExcel to CSV converter (UTF-8, no upload)
A free Duaer tool that turns .xlsx or .xls into UTF-8 CSV in your browser. Pick a sheet; a BOM is added by default so Excel reopens it cleanly.
File conversionJSON to CSV converter (nested JSON flattened)
A free Duaer tool: paste or upload JSON, nested fields become columns, and you download CSV or Excel. It runs in your browser with no upload.
SnippetsSplit an array into separate items in Duaer
Duaer nodes run once per item. Split an order line list or an API array into one item per entry with Split Out so the next nodes handle each one.