Show HN: Run SQL on Spreadsheets
spanrr.com
Show HN: Run SQL on Spreadsheets
1–10 of 20 posts
Re: Show HN: Run SQL on Spreadsheets
#2[deleted]
Re: Show HN: Run SQL on Spreadsheets
#3Hi HN, We are Nafey and Akhil, founders of Spanrr. After spending months building apps on spreadsheets and working with existing spreadsheets api we realized while people might need customisable apps, what they really prefer any day is a better spreadsheet.
Key differentiators:
- You can write SQL queries on your spreadsheet. You can also do JOIN queries across spreadsheets, do summaries and statistics.
- Easily handle millions of rows smoothly
- API out of the box for your data so you can wire it to other systems.
- Import your CSV or Excel files and run SQL queries over
- Native connection to MySQL database
- Save SQL queries for future use
- Connection to PostgreSQL, SQL Server and MongoDb.
- Self hostable version.
- Granular permission.
- Version control and error checking.
- Command-line based access.
- Connect Spanrr directly to your Web application as a MySQL database.
We’ll be here all day answering your question.
Re: Show HN: Run SQL on Spreadsheets
#4Hi HN, We are Nafey and Akhil, founders of Spanrr. After spending months building apps on spreadsheets and working with existing spreadsheets api we realized while people might need customisable apps, what they really prefer any day is a better spreadsheet. Key differentiators: - You can write SQL queries on your spreadsheet. You can also do JOIN queries across spreadsheets, do summaries and statistics. - Easily hand…
Pretty interesting
Re: Show HN: Run SQL on Spreadsheets
#5I signed up to check out Spanrr.
I find it useful for preview of our data from database, by non-tech stuff. Seems we could use this as a CRM for our business.
Do you plan to implement auto-complete / suggestions for queries, so it is easier for our stuff to use more advanced queries?
Re: Show HN: Run SQL on Spreadsheets
#6I signed up to check out Spanrr. I find it useful for preview of our data from database, by non-tech stuff. Seems we could use this as a CRM for our business. Do you plan to implement auto-complete / suggestions for queries, so it is easier for our stuff to use more advanced queries?
Yes autocomplete for query is something we will be working on in near future.
Re: Show HN: Run SQL on Spreadsheets
#7> Write SQL queries atop of your spreadsheet data. Even, JOIN queries across spreadsheets.
Excel has supported this out-of-the-box for decades, though the process is a little convoluted.
Re: Show HN: Run SQL on Spreadsheets
#8> Write SQL queries atop of your spreadsheet data. Even, JOIN queries across spreadsheets. Excel has supported this out-of-the-box for decades, though the process is a little convoluted.
We have found it a very cumbersome process to set up SQL support on excel. We are building this spreadsheet ground up to work well with SQL and databases in general. Also we have built this spreadsheet in such a way that it can handle millions of rows which is another place where excel does not provide good user experience.
Re: Show HN: Run SQL on Spreadsheets
#9Hi HN, We are Nafey and Akhil, founders of Spanrr. After spending months building apps on spreadsheets and working with existing spreadsheets api we realized while people might need customisable apps, what they really prefer any day is a better spreadsheet. Key differentiators: - You can write SQL queries on your spreadsheet. You can also do JOIN queries across spreadsheets, do summaries and statistics. - Easily hand…
Its really useful tool to have for non technical people. Waiting to see the final product soon.
Re: Show HN: Run SQL on Spreadsheets
#10A good took for non developers. For PMs who are handy with basic SQL, spannr is a good tool to reduce dependency on data analysts. PMs can quickly run all sorts of analysis on the data. Looking forward to extension of the tool for marketers too.