Show HN: Tool I created to covert tabular data to a 'pretty' table
dv.dbb1.dev
dv.dbb1.dev
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!
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.
a|1
b|2
c|3
This is a pretty common data format and one which people whom use your tool may appreciate.HTH
Is this for copying some poor visually formatted excel and have a clear view of it in your solution ?
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
It's also not clear how long the link is active, or that we are even supposed to share the link.
Also, hosting (open) data anonymously is a market niche (since pastebin have a 500kb size) but you may not want to become the anonymous data host for obvious reasons.
For example, from Philips 2018 annual report [0], I copy the income statement, and I get the below when I paste. I found it impossible to get this into Excel or any other table format, without writing a Python program for it. Your tool still made it as one column. If there's a way you can automatically detect the 3 numeric columns below, you can have a large audience of finance folk analyzing PDF documents.
Sales. 17,422 17,780 18,121 Cost of sales (9,484) (9,600) (9,568) Gross margin 7,939 8,181 8,554 Selling expenses (4,142) (4,398) (4,500) General and administrative expenses (658) (577) (631) Research and development expenses (1,669) (1,764) (1,759) 6 Other business income. 17 152 88 6 Other business expenses. (23) (76) (33) 6 Income from operations. 1,464 1,517 1,719 7 Financial income. 65 126 51 7 Financial expenses. (507) (263) (264) Investments in associates, net of income taxes 11 (4) (2) Income before taxes 1,034 1,377 1,503 8 Income tax expense. (203) (349) (193) Income from continuing operations 831 1,028 1,310 3 Discontinued operations, net of income taxes. 660 843 (213) Net income 1,491 1,870 1,097 Attribution of net income Net income attributable to Koninklijke Philips N.V. shareholders 1,448 1,657 1,090 Net income attributable to non-controlling interests 43 214 7
[0] https://www.philips.com/c-dam/corporate/about-philips/sustai...
As for your specific example, you can download tables from EDGAR in other formats, like HTML and iXBRL. The HTML table will usually paste into Excel well.
HTML: https://www.sec.gov/Archives/edgar/data/313216/0000313216190...
iXBRL: https://www.sec.gov/Archives/edgar/data/313216/0000313216180...
The unfortunate part of it is it's parsing the data based on the characters it finds in the text being processed, so if when you copy the data from your PDF reader, I'm guessing the data is positioned in the document using X/Y coordinates which is why it can't be formatted correctly.
I will definitely look at the document and see if my assumptions are incorrect, and if there is a different delimiter being used then it may be something I can work with.
Input & output - https://imgur.com/a/5j8Bblo
Table# 1 csv - https://json-csv.com/c/2faG
Table# 2 csv - https://json-csv.com/c/WESI