Space Cat, Prince Among Thieves

CSV To Markdown Table Generator

Update July 8, 2019: Added more graceful pipe | and backslash \ handling.

While doing code reviews on GitHub I find myself profiling a lot of SQL queries, getting EXPLAIN output into a markdown format for GitHub became very important, and was a huge pain to do by hand.

While there were tools out there, nothing I could easily copy and paste tab seperated query results into, so I created this. The markdown this outputs should work with most table supporting Markdowns flavors such as Markdown Extra and GitHub Flavored Markdown.

The default tab separated setting is very useful for pasting straight from Excel or other tabular data sources like SQL editors.

Fork my source on GitHub!

Caveat - while it does essentially parse CSV it is not quotation mark aware. If need or demand arises I may look into it.

The script is available on GitHub and is Node.js ready. More details can be found on GitHub. It is also available via npm.


Comment by: Tats on

Tats's Gravatar Super Easy Use!
Very useful!
Thanks a lot!

Comment by: Andrew Lane on

Andrew Lane's Gravatar Love this! Helped me out a ton.

Comment by: Jean on

Jean's Gravatar that is nice dude

Comment by: Shaul on

Shaul's Gravatar Thanks! Really helpful

Comment by: JiangNan on

JiangNan's Gravatar Thanks, it helps a lot!

Comment by: Nitin Bansal on

Nitin Bansal's Gravatar It breaks if column value has commas in it, even though the entire value is wrapped in double quotes

Comment by: will on

will's Gravatar That is great!
Thanks!

Comment by: Mitchell on

Mitchell's Gravatar love it!

Comment by: Brady Holt on

Brady Holt's Gravatar I use this all the time. Thank you!

Comment by: Hemal Jivani on

Hemal Jivani's Gravatar Thanks so much for this nice tool

I use it all the time and its awesome piece of work.

Comment by: ryan on

ryan's Gravatar very nice !!

Comment by: szabacsik on

szabacsik's Gravatar very useful very like thank you!

Comment by: ferrrari on

ferrrari's Gravatar Excellent! Super easy to use and extremely helpful. Saves so much time! Thank you very much & keep up the good work!

Comment by: mohammad on

mohammad's Gravatar I just love it!!!

Comment by: Brady on

Brady's Gravatar I use this all the time - thank you!

Comment by: Dawn on

Dawn's Gravatar Thank you so much for this! Bookmarked!

Comment by: Matthew Dolman on

Matthew Dolman's Gravatar Would be great if there wasn't a space character at the end of each line. Some markdown applications (Hugo) can't handle this.

Comment by: Alex on

Alex's Gravatar Thanks, it is very useful tool, my friend Daniel who recommend me

Comment by: Richard on

Richard's Gravatar Fab. Thanks. Copied table straight out of Google sheets and it converted it perfectly. Thanks.

Comment by: Deepak on

Deepak's Gravatar Very useful. Thanks

Comment by: Kris on

Kris's Gravatar Great tool! Love that it supports pasting TSVs!

Comment by: Lewis on

Lewis's Gravatar Great tool. Any chance of a vscode integration?

Comment by: Andreas on

Andreas's Gravatar Excellent! Thank you!

Comment by: Raul Liborio on

Raul Liborio's Gravatar Great! Thanks for this awesome tool.

Comment by: Mhg on

Mhg's Gravatar Wow!

Excelente.
Esto ahorra muchos problemas.


Muchas gracias.

Comment by: Manishdan on

Manishdan's Gravatar Excellent! Thank you!

Comment by: Henk Rijks on

Henk Rijks's Gravatar Thanks! You saved me a lot of time and hassle. Appreciate it very much.

Comment by: hoverhuang on

hoverhuang's Gravatar Thank you so much. You saved my working time too much.

Comment by: typebrook on

typebrook's Gravatar Saved my day, many thanks!

Comment by: Eric on

Eric's Gravatar Fantastic. Thank you!

Comment by: Ted on

Ted's Gravatar Thanks, Works well for what i needed

| cost    | coins | cost per 100 coins | coins per $1 | 
|---------|-------|--------------------|--------------| 
| $0.99   | 100   | $0.99              | 101.0        | 
| $8.99   | 550   | $1.63              | 61.2         | 
| $16.99  | 1200  | $1.42              | 70.6         | 
| $34.99  | 2500  | $1.40              | 71.4         | 
| $69.99  | 5200  | $1.35              | 74.3         | 
| $169.99 | 14500 | $1.17              | 85.3         | 

Comment by: Andy on

Andy's Gravatar Awesome time saver, thanks so much : ]

Comment by: Caroline on

Caroline's Gravatar Thank you!

Comment by: Qufei on

Qufei's Gravatar Amazing! This is such a time saver! Thanks so much!!

Comment by: Marie Moore on

Marie Moore's Gravatar You are a life saver! Thank you thank you thank you

Comment by: Ramesh Kotha on

Ramesh Kotha's Gravatar Really helpful. I always use this for markdown. Thanks Jesse.

Comment by: gil on

gil's Gravatar Amazing!!!!!!!!!! Thanks!

Comment by: Frank on

Frank's Gravatar Fantastic job, simple yet effective.

Comment by: bm on

bm's Gravatar Simply phenomenal. I use this with markdownhere app to have rich text formatting in emails.. Works perfectly.

Comment by: Nantuko86 on

Nantuko86's Gravatar Thank you a LOT!!! i love it

Comment by: Miguel on

Miguel's Gravatar Have been using it for years.
Thank you.

Comment by: Chad Baldwin on

Chad Baldwin's Gravatar Just here to say this is an awesome tool, been using it for years, and I appreciate the work that was put into this to help me do my job! ????

Comment by: Jay Kint on

Jay Kint's Gravatar Very useful. Thanks for sharing.

Comment by: Aruvi on

Aruvi's Gravatar Very Helpfull

Comment by: nkat on

nkat's Gravatar Awesome tool! I was looking for it using google queries like "csv to tabular", "csv to pseudo-graphic", "sql export to stackoverflow format table" and nothing came out.
Only after I learned that this table format has its own "table Markdown" name I managed to find this super useful page, so maybe it'd be a good idea to tag the page to more general requests
Anyway, thank you once again!

Comment by: Will K. on

Will K.'s Gravatar Nearly 10 years later, and this is still extremely helpful for showing tables in GitHub code reviews! Thanks for building.

Email address will never be publicly visible.

Basic HTML allowed.