CSV To Markdown Table Generator

Comments:

Tags: Tools NodeJS JavaScript GitHub CSV

By Jesse Donat on Sep. 14, 2014 (Updated: Jul. 8, 2019)

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 Apr. 27, 2016

Super Easy Use!
Very useful!
Thanks a lot!

Comment by: Andrew Lane on Jun. 13, 2016

Love this! Helped me out a ton.

Comment by: Jean on Jun. 14, 2016

that is nice dude

Comment by: Shaul on Jun. 22, 2016

Thanks! Really helpful

Comment by: JiangNan on Jun. 30, 2016

Thanks, it helps a lot!

Comment by: Nitin Bansal on Jul. 4, 2016

It breaks if column value has commas in it, even though the entire value is wrapped in double quotes

Comment by: will on Aug. 3, 2016

That is great!
Thanks!

Comment by: Mitchell on Aug. 24, 2016

love it!

Comment by: Brady Holt on Aug. 30, 2016

I use this all the time. Thank you!

Comment by: Hemal Jivani on Sep. 12, 2016

Thanks so much for this nice tool

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

Comment by: ryan on Dec. 21, 2016

very nice !!

Comment by: szabacsik on Jan. 26, 2017

very useful very like thank you!

Comment by: ferrrari on Feb. 1, 2017

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 Feb. 23, 2017

I just love it!!!

Comment by: Brady on Mar. 21, 2017

I use this all the time - thank you!

Comment by: Dawn on Apr. 1, 2017

Thank you so much for this! Bookmarked!

Comment by: Matthew Dolman on Jul. 5, 2017

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 Sep. 22, 2017

Thanks, it is very useful tool, my friend Daniel who recommend me

Comment by: Richard on Oct. 13, 2017

Fab. Thanks. Copied table straight out of Google sheets and it converted it perfectly. Thanks.

Comment by: Deepak on Nov. 6, 2017

Very useful. Thanks

Comment by: Kris on Nov. 22, 2017

Great tool! Love that it supports pasting TSVs!

Comment by: Lewis on Dec. 6, 2017

Great tool. Any chance of a vscode integration?

Comment by: Andreas on Dec. 14, 2017

Excellent! Thank you!

Comment by: Raul Liborio on Jun. 19, 2018

Great! Thanks for this awesome tool.

Comment by: Mhg on Aug. 7, 2018

Wow!

Excelente.
Esto ahorra muchos problemas.

Muchas gracias.

Comment by: Manishdan on Oct. 9, 2018

Excellent! Thank you!

Comment by: Henk Rijks on Nov. 14, 2018

Thanks! You saved me a lot of time and hassle. Appreciate it very much.

Comment by: hoverhuang on Jan. 7, 2019

Thank you so much. You saved my working time too much.

Comment by: typebrook on Feb. 11, 2019

Saved my day, many thanks!

Comment by: Eric on May. 18, 2019

Fantastic. Thank you!

Comment by: Ted on Jun. 7, 2019

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 Jun. 24, 2019

Awesome time saver, thanks so much : ]

Comment by: Caroline on Aug. 30, 2019

Thank you!

Comment by: Qufei on Sep. 6, 2019

Amazing! This is such a time saver! Thanks so much!!

Comment by: Marie Moore on Oct. 10, 2019

You are a life saver! Thank you thank you thank you

Comment by: Ramesh Kotha on Dec. 14, 2019

Really helpful. I always use this for markdown. Thanks Jesse.

Comment by: gil on Jan. 4, 2020

Amazing!!!!!!!!!! Thanks!

Comment by: Frank on Mar. 10, 2020

Fantastic job, simple yet effective.

Comment by: bm on Jul. 30, 2020

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

Comment by: Nantuko86 on Oct. 27, 2020

Thank you a LOT!!! i love it

Comment by: Miguel on Jan. 10, 2021

Have been using it for years.
Thank you.

Comment by: Chad Baldwin on Jan. 29, 2021

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 Mar. 26, 2021

Very useful. Thanks for sharing.

Comment by: Aruvi on Nov. 15, 2021

Very Helpfull

CSV to Markdown Table Generator — Donat Studios