3 ms·
Show HN: Manipulate CSV files using SQL completely in the browser (No Back end)
- MatthiasPortzel 3y agoI 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/ https://xkcd.com/2180/
- redavni 3y ago1. 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 3y agoReply: 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.