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

Show HN: Manipulate CSV files using SQL completely in the browser (No Back end)(hsps.in)

3 points by coderhs 3 years ago | 3 comments

redavni 3 years ago |

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.

coderhs 3 years 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.

MatthiasPortzel 3 years 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/