Pipe table
Input
| table_name | rows | | users | 12 | | orders | 8 |
Output
table_name,rows users,12 orders,8
Pasted Table to CSV
Paste a table copied from SQL output, Markdown, Slack, or a terminal, then split it into CSV or TSV for spreadsheets.
Conversion tools
Loading tool
What it helps with
- Turn pipe-separated SQL or terminal output into CSV
- Clean a copied Markdown table before opening it in a spreadsheet
- Ignore log or error lines while making a small CSV
How to use
- Paste the copied table text.
- Choose the delimiter and how to handle rows with different column counts.
- Review the preview, then copy or download the CSV or TSV.
Examples
Markdown table
Input
| column | type | | --- | --- | | id | bigint | | memo | text |
Output
column,type id,bigint memo,text
Console output with noise
Input
copied from console | name | status | | alpha | ready | ERROR extra log line | beta | waiting |
Output
name,status alpha,ready beta,waiting
Good to know
- This is a delimiter splitter, not a full spreadsheet parser.
- Quoted CSV input is better handled by the JSON / CSV Converter.
- If cell text itself contains the chosen delimiter, review the preview before copying.
- Very large pastes can make the browser tab slower.
FAQ
- Can it ignore error or log lines mixed into a table?
- Yes. The default setting skips rows whose column count does not match the main table, which helps with copied console text.
- Does this parse real CSV quoting rules?
- No. It splits pasted text by the delimiter you choose. Use JSON / CSV Converter for ordinary CSV parsing.
- What should I check before copying the result?
- If a cell itself contains the delimiter, the row may split into extra columns. Check the preview and warnings before copying.
- Is pasted table text stored?
- No. KoguNavi has no feature to store pasted text. Copy or download what you need.