News for hackers. Stuff that matters.

A comment on Query Google Sheets as virtual tables with SQLite extension – libgsqlite. Parent comment

Re:Query Google Sheets as virtual tables with SQLite extensi... by cosmojg on Saturday March 18, 2023 @11:17AM (#35209756)
> For one, there's no CSV standard

This is false: https://www.rfc-editor.org/rfc/rfc4180

[ Parent | on HN ]
Re:Query Google Sheets as virtual tables with SQLite extensi... by fulafel on Saturday March 18, 2023 @11:31AM (#35209881)
Well yes, there are actually many many CSV standards, my mistake for imprecise language. What I meant to say that there's no single CSV format that programs agree on. Starting with Excel...

Apparently it's quite common in Gsheet land to base your CSV export around things like this copypasta javascript code and customize as needed (follow forks, in parent direction too, for more of the story) https://gist.github.com/mrkrndvs/a2c8ff518b16e9188338cb809e0...

[ Parent | on HN ]