Re:Show HN: CSVshare – Instantly share data with anyone and ...
by marklit on Thursday October 19, 2017 @11:27AM
(#15508710)
I just tried out the service. Some feedback:
1. It would be nice if I could upload CSVs that are gzip compressed.
2. When I download the CSVs it would be good if the filenames included gz at the end as of now they're written out as a series of random characters followed by a .csv extension.
3. Time columns have been transformed after I downloaded the file I just uploaded. The date is in US format and the time information is lost. 2010-12-01 13:51:00 became 12/1/10.
4. When trying to view a 50K row CSV on your site Chrome slows to a crawl.
5. I originally tried to upload a 1-million-row x 9 column, 33 MB, gzip compressed CSV. It would be good if the service limits could allow for something like this.
This service should do one better than just sending a CSV via email and having the other party opening it up in Excel.
Re:Show HN: CSVshare – Instantly share data with anyone and ...
by fiatjaf on Tuesday October 17, 2017 @02:46PM
(#15493640)
The idea is great. The internet needs a simple and useful tool like that.
However, it fails when I try to browse a .txt file (which is CSV, believe me) based just on its extension. Also, it is way too slow. I've opened the longest rivers example the site has offered me and couldn't even search, scrolling was difficult.
Re:Show HN: CSVshare – Instantly share data with anyone and ...
by fiatjaf on Tuesday October 17, 2017 @02:49PM
(#15493674)
You can? Oh, that's great, because I can't. Although the actual spreadsheet runs smoothly, the web interface of Google Drive is horribly slow on my computer. Also, if I want to share or just quickly browse a CSV, it will be stored on my account and make a big mess on my files.
Not to mention that I must have a Google account and that Google will automatically read my data and associate it with me.
Re:Show HN: CSVshare – Instantly share data with anyone and ...
by ludicast on Tuesday October 17, 2017 @04:06PM
(#15494407)
Very nice Jason.
I know I'm always bugging you about Fieldbook APIs (this is Nate K again), but is there an api for creation here?
I have a super-duper-cool use case in mind but it involves POSTing an in-memory CSV rather than manually clicking (but I don't want to clutter my fieldbook namespace).
Re:Show HN: CSVshare – Instantly share data with anyone and ...
by jasoncrawford on Tuesday October 17, 2017 @01:51PM
(#15493030)
Yes, we have. Those attacks don't apply to viewing data on CSVshare, which doesn't have the vulnerabilities of Excel or Google Sheets. However, be careful about opening CSVs in Excel or Google from CSVshare or any other source, unless you trust the person who uploaded them.
Re:Show HN: CSVshare – Instantly share data with anyone and ...
by zubairq on Wednesday October 18, 2017 @05:10AM
(#15497808)
Very nice. I made a system to search CSV files at http://gosharedata.com but I it is only available as a download and not online, so I like CSVShare, very cool!
Re:Show HN: CSVshare – Instantly share data with anyone and ...
by jasoncrawford on Tuesday October 17, 2017 @02:28PM
(#15493416)
This is for sharing, with no account/password required. The uploaded data is made available at a web page. If you choose “public”, it will be included in a public index; the only other option right now is “unlisted”. Unlisted pages aren't in the public index, but are available to anyone who has the link.
For very sensitive data, that you would want to password-protect, don't upload it right now. We may offer accounts and/or password-protected data in the future.
1. It would be nice if I could upload CSVs that are gzip compressed.
2. When I download the CSVs it would be good if the filenames included gz at the end as of now they're written out as a series of random characters followed by a .csv extension.
3. Time columns have been transformed after I downloaded the file I just uploaded. The date is in US format and the time information is lost. 2010-12-01 13:51:00 became 12/1/10.
4. When trying to view a 50K row CSV on your site Chrome slows to a crawl.
5. I originally tried to upload a 1-million-row x 9 column, 33 MB, gzip compressed CSV. It would be good if the service limits could allow for something like this.
This service should do one better than just sending a CSV via email and having the other party opening it up in Excel.
However, it fails when I try to browse a .txt file (which is CSV, believe me) based just on its extension. Also, it is way too slow. I've opened the longest rivers example the site has offered me and couldn't even search, scrolling was difficult.
* Anyone can search/query like a database
* Data can be downloaded in CSV or JSON format, manually or via API
Hope that helps!
For some reason you can't upload directly on a google sheets website but you can do the following workflow:
1. Open google drive and drag it to there
2. Open the file on google drive and select spreadsheets.
I like your faceted queries and the JSON format might be appealing. Also Google sheets has an API. https://developers.google.com/sheets/api/
Is my information that I upload public to anyone or private?
Re public: see my response to @jordache, it is either public or “unlisted”, but in either case it is available to anyone who has the link.
Not to mention that I must have a Google account and that Google will automatically read my data and associate it with me.
I know I'm always bugging you about Fieldbook APIs (this is Nate K again), but is there an api for creation here?
I have a super-duper-cool use case in mind but it involves POSTing an in-memory CSV rather than manually clicking (but I don't want to clutter my fieldbook namespace).
count()
And that will tell you how many rows there are.
For very sensitive data, that you would want to password-protect, don't upload it right now. We may offer accounts and/or password-protected data in the future.
Thanks!