4 ms·

Sqlite3 can import and export CSV via the CLI application. Both Ruby and Python provide CSV parsers in their standard library.

• 7thaccount 6y ago
  Doesn't it convert everything to strings including numbers? Or can you specify types?
  • fnord123 6y ago
    sqlite won't fail on bad types but you can do maths (e.g. sum, etc) on numeric columns,
  • lmns 6y ago
    You have to provide a schema anyway, so you can treat specific columns as integers.
• dotancohen 6y ago
  Thank you. I've used sqlite, but being able to query the data is not the same as being able to browse that data. For instance, consider a project that I'm currently working on. Google Docs sheet exported to CSV. The file documents dozens of servers used as load balancers, websites, and database servers. The files has gone from MS Excel to Google Docs, and been maintained by four admins over 12 years. There are no columns per se, rather "sections of rows", each of which isn't even consistent in itself. One section is double columned, with the top row listing public IP address, login name, etc and the second row listing LAN IP address, login password, etc. sqlite is useless on these files and frankly I've seen these things more often than well-formatted spreadsheets at every company I've ever worked with. Nobody but software developers treat spreadsheet columns as database fields.
  • lmns 6y ago
    I know, there is no easy fix for that.
• dotancohen 6y ago
  Just a heads-up, if you're interested. I'm writing an app in Python for browsing spreadsheets: https://github.com/dotancohen/osheet https://github.com/dotancohen/osheet