TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

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

3 pointsby coderhsabout 2 years ago

2 comments

redavniabout 2 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.
评论 #35694136 未加载
MatthiasPortzelabout 2 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.<p><a href="https:&#x2F;&#x2F;xkcd.com&#x2F;2180&#x2F;" rel="nofollow">https:&#x2F;&#x2F;xkcd.com&#x2F;2180&#x2F;</a>