from Hacker News

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

by coderhs on 4/24/23, 8:11 PM with 3 comments

  • by redavni on 4/24/23, 10:03 PM

    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.
  • by MatthiasPortzel on 4/24/23, 8:28 PM

    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/