Friday, October 15, 2010

Format Text as a Table

Here's a simple tool that lets you format text as a table. Simply enter in tab-delimited text (e.g. by copying from Excel), then press "Create Table".

Input:

Header style:
Style:
MySQL: outputs using Ascii characters.
Unicode Art: uses unicode chars that makes it look more like a table.
HTML: outputs a normal html table.

Output:

  • 2/16/13:
    • HTML table's HTML code output added.
  • 1/13/12:
    • Parse table added.
    • Improved code and layout.
  • 1/1/11:
    • Auto Align: number columns become right-aligned, and headers are centered.
    • Spreadsheet option added: adds letters on top and numbers on the side.

52 comments:

  1. Hi, great work, i was searching very long for such a online solution!!!

    ReplyDelete
  2. cool, thanks, used it for stackoverflow

    ReplyDelete
  3. What a cool app! A generous soul to boot. thanks!

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Started to use these tables into C# Comments :) Thanks!

    ReplyDelete
  6. Thanks for This Great Online Tool!
    How can I download the table output?

    ReplyDelete
  7. Very senseful solution indeed, but how can i copy the code for the table? Thanks!

    ReplyDelete
  8. @democluj: I just added a way to copy the HTML table's code. Hope that helps!

    ReplyDelete
  9. Thanks but I think I could have done that with "Inspect Element" feature of Google Chrome (any way much easy now with copy/paste in two clicks. Thanks!). I was wondering if I could somehow copy the Unicode Art table code to make posts with tables on StackOverFlor for example...I've tried to simply just copy it but it's not right.

    ReplyDelete
  10. Sorry about last post (made me look a liitle stupid)... I just figured it out (for StackOverFlow post). Just put the code copied from here in between pre code here /pre. Put pre and /pre between bracketts.

    ReplyDelete
  11. Wow. it's really excellent. just pasted a quite odd excel table and worked perfect. Even better if it could the exact wiki/markdown markup but i'll fix that with a text editor. Thanks!!

    ReplyDelete
  12. Thank for the work! Just what I was looking for!

    ReplyDelete
  13. This is such a great little tool! Thanks so much :) Definitely saved me some time making my own fancy table

    ReplyDelete
  14. Thanks for this very useful tool. I use it almost every week to make ascii tables for text emails at [Express Sign Products](http://www.expresssignproducts.com).

    ReplyDelete
  15. Great tool. Shame it doesn't look as good in Notepad text file. Is there a way to fix that? It does look great in NoteTab Pro but most of my users have NotePad.

    Thanks!

    ReplyDelete
    Replies
    1. A great tool indeed! The MySQL output looks fine in Notepad for me. Are you using a fixed-width font? If you are unsure, go to Format -> Font... and select "Lucida Console" or "Consolas" and see if that fixes the problem.

      Delete
  16. Thanks, this works great!

    Is there any way to specify a column width and have it wrap the text as needed (preferably keeping whole words together)?

    ReplyDelete
  17. Very cool. I forked this for my own needs, I also added Github Markdown to the list of formats: http://ozh.github.io/ascii-tables/

    ReplyDelete
  18. This is fantastic, thanks!

    btw, you might want to add a note somewhere about unicode requiring UTF-8 for webpages, added by using a META tag and then setting:
        content='text/html; charset=UTF-8' http-equiv='Content-Type'

    ... and that unicode probably won't work on windows without users changing fonts.

    ReplyDelete
  19. dude, this is amazing. exactly what i was looking for! thanks so much.

    ReplyDelete
  20. Thank you for this tool, I found it via stack overflow and I use it often to embed excel tables into source code.

    ReplyDelete
  21. Any chance of getting more than one unicode style? Instead of just double lines also single line and bold single line?
    Sorry for the greediness. :-)

    ReplyDelete
  22. this tool is awesome, thank you!!!

    (Someone please add to notepad++, gvim, etc.)

    ReplyDelete
  23. Thank you...Awesome! Now, nobody's gonna suggest any edit on my question posted on StackOverflow! ;)

    ReplyDelete
  24. Thank you...Awesome! Now, nobody's gonna suggest any edit on my question posted on StackOverflow! ;)

    ReplyDelete
  25. This is converter is Great! Thank you for sharing it!

    ReplyDelete
  26. VERY nice and helpfull tool! Thank you.

    ReplyDelete
  27. Awesome tool!! I have one suggestion. On the textareas would you consider adding wrap="off" to the element attributes? That way if the table is long it still looks right and you will get a scroll bar on the textarea.

    ReplyDelete
  28. Fantastic tool! I have one suggestion - when I have numbers that have thousands separators they are not being right-aligned. Can you check for a thousands separator in the numbers and right-align if they exist? Thanks!

    ReplyDelete
  29. It's a wonderful tool. Thanks

    ReplyDelete
  30. If I want to use it for Stackoverflow What are the steps needed? I have copied the output but its not working :(

    ReplyDelete
  31. I love it and use it on a daily basis. Certainly makes sense for me!
    Thanks a million!

    ReplyDelete
  32. This is exactly what I was looking for. Thanks!

    ReplyDelete
  33. good one ... just love this for my #stackoverflow

    ReplyDelete


  34. كل هذه الخدمات التي تحصل من خلال افضل شركة تنظيف بالرياضالتي تسعى الى تقديم افضل الخدمات المنزلية المميزة لكل من يرغب في التعامل مع شركة ركن البيت التي تقدم خدمات جيدة فلماذا شركة تنظيف فلل بالرياض
    ؟ لكي يتم التخلص الاتربة والاوساخ والبقع التي توجد بفلتك فهناك الكثير من الاعمال التى تقوم بها نظافة فعندما تتعامل معنا في شركة تنظيف خزانات بالرياضستحصل علي خدمات جيدة لانها تعتمد على اليات تساعد فى الحصول على افضل النتائج الجيدة التي لا تلاقها في الشركات الاخري وبالاضافة الي ذلك يوجد لدينا خدمات اخري يمكنكم متابعتنا عليها من خلال شركة تنظيف مسابح بالرياض - شركة تنظيف منازل بالرياض - كما سوف نساعدك علي التخلص من مشاكل الصرف الصحي بواسطة شركة تسليك مجاري بالرياضالتي تعطي لكم اليات حديثة تساعد علي التخلص من الروائح الكريهة التي تاتي اليكم وهناك حلول لمشاكل التسربات التي ياتي من خلالها الكثير من المشاكل للمباني بوااسطة شركة كشف تسربات المياه بالرياضالتي تقدم لكم اجهزة الكشف الحديث بدو تكسير وسنوفر عليكم مشاكل نقل الاثاث المتعبة التي عاني من الكثيرون بسبب المشاكل التي سبتها الشركات الاخري فتعاملك مع شركة نقل اثاث بالرياض سوف يصلك اثاثك مع تعبئة سليمة ومغلفة الي باب بيتك الجيدة واذا يوجد صيانة في منزلك الجديد وتتطر الي البحث عن شركة تخزين اثاث بالرياضلحفظ الاثاث الخاص بكم لحين الانتهاء من مشاكلكم السابقة

    ReplyDelete
  35. I can no longer get either the unicode or MySQL to generate, only the HTML values. Anyone else having this difficulty?

    ReplyDelete
  36. Keep posting the good work. Some really helpful information in there. Bookmarked. Nice to see your site.http://www.staffcontrol.com/

    ReplyDelete