Show HN: Manipulate CSV files using SQL completely in the browser (No Back end) (opens in new tab)

(hsps.in)

3 pointscoderhs2y ago3 comments

3 comments

1. This is great. 2. You are verifying mime type text/csv which wont work on windows machines with excel installed because Windows browsers defer to the mime type set in the registry which is the Excel mime type. 3. The parsers errors with a "/" and probably other characters in the first row. Maybe others, but one of my column headers had a slash.

coderhsOP2y ago

Reply:

1. Thank you. 2. Thanks for the information I will handle that. 3. Thank you for testing. I will handle that character. I currently store the actual headers as it is, and create a psudo name for the column. Will replace the `/` with a - when generating the pusdo column name.

MatthiasPortzel2y ago

I use Google Sheets for this. Copy-and-paste to import CSV data into a sheet, and the QUERY function to execute SQL against the cells.

https://xkcd.com/2180/

j / k navigate · click thread line to collapse