Hacker News Reader

Comment by dougbarrett | Hacker News Reader

Creator here. I'm always running queries in Sequel Pro and pasting screenshots, or pasting the data into an excel spreadsheet and uploading that to slack for co-workers, because Slack doesn't have the ability to render tables.

Yesterday, my screenshots weren't working at all when sharing them in slack, and I couldn't find a tool out there that could take tabular data and convert it to an easy to navigate table w/ an option to download as a CSV file, so I made my own.

Let me know if you have any questions or comments!

View on HN

If you find the time and mobile viewing is in scope, the site would benefit from an example on the homepage for us mobile users that don't have a table handy.

Example, yes please!

An example has been added!

SheetJS has an open source library xlsx-js[1] that can parse most Excel files. You could use that combined with FileReader (the browser file API) to enable users to drop a spreadsheet file on the page instead of copying and pasting. It'd be a nice addition.

[1] https://github.com/SheetJS/js-xlsx

+1. I'm using xlsx-js in the similar-ish tool I recently wrote: https://akx.github.io/d2d/

Thank you for the suggestion, I will look into the library!

You might also be interested in JExcel: https://bossanova.uk/jexcel/v3/

It can take tabular data, allows you to do some Excel-like editing on it and download as CSV. Might be a bit heavy for your purposes, but it is easy to use and extend.

Any chance of adding a placeholder text for each of the options so folks can see what the output looks like without obtaining a result-set themselves :)

An example has been added to the homepage to see what the output looks like!

Absolutely, the next build will have that.

Is it Pandas based? I'm a bioinformatician and many of my data work flows start with pandas.read_excel() and end with pandas.DataFrame().to_excel(). I had some serious issues with it but I have come to terms with it. Actually Excel is ok as a central project "database" (up to certain size of course), anyone can quickly fill in a lot or rows (the smart dragging, the macro's that take in other Excel files, drop-downs for categories that I later use in Pandas/Seaborn...) and programmatically dealing with it is not too bad (pandas for bulk stuff, openpyxl for very fine-grained control and even conditional formatting, which we use a lot, etc).

There isn't too much to the rendered document, it reads the text as TSV and breaks that out into rows and cells. I tried keeping it as simple as possible for now, the idea isn't to help analyze data, but be able to share data in a usable format easily.

It appears your tool does not support pipe-delimited data in the "data to table" choice. An example is:

  a|1
  b|2
  c|3

This is a pretty common data format and one which people whom use your tool may appreciate.

HTH

Thank you for the feedback! Pipe and CSV are next on the list :)

Doesn't appear to be working for CSV? e.g.: https://dv.dbb1.dev/sheets/1a53b5aa-2b00-4f58-ad75-84a31dcde...

Thank you for testing it out, it doesn't have support yet, but it will soon!

i do not understand the use case but im not too much in contact with big ugly excels nor SQL.

Is this for copying some poor visually formatted excel and have a clear view of it in your solution ?

I usually use Sequel Pro to run queries against a MySQL server, typically I'll take a quick screenshot and send it to co-workers, sometimes the screenshots fail, there is too much data in it to be useful, or they do need an excel spreadsheet which requires more steps than I would like. I built it as a quick tool so I can easily copy the output of the query, paste it in the textbox, and an HTML table is generated.

Doesn't seem to work for the following CSV:

date,x-numbers,y-numbers

2015-01-01,3,3

2016-01-01,2,3

2017-01-01,1,5

2018-01-01,3,8

CSV support is coming within the next day!

Reply on news.ycombinator.com