Re:Show HN: Sourcetable – AI Spreadsheet and Data Platform
by mceoin on Thursday September 19, 2024 @09:19PM
(#41597925)
> For my particular use case, the charting aspect left a few things to be desired - once I grouped campaign donations by contributor, I could only see the first 10 rows in the AI response, with no option to expand the output.
Insert it as a table on the page (you should see a button), it will then print the whole table result from that query into the spreadsheet. Also, you can check the SQL first and validate it, then print to table after that.
Try a few million rows and see what happens!
Re:Show HN: Sourcetable – AI Spreadsheet and Data Platform
by dioptre on Thursday September 19, 2024 @09:22PM
(#41597941)
Also keep an eye out on the limit - we default to 10,000 to keep it snappy but if you want to make it larger its a click away. The "summarize table" button should auto limit to 1B+ rows.
Re:Show HN: Sourcetable – AI Spreadsheet and Data Platform
by jadbox on Friday September 20, 2024 @09:49AM
(#41602007)
Can Office 365 Copilot do this too?
Re:Show HN: Sourcetable – AI Spreadsheet and Data Platform
by dioptre on Friday September 20, 2024 @01:30PM
(#41604025)
We are a generally a generation ahead of sheets and excel. You might be able to do some of the things in the older software but it won't be a button press. The ability for you to run data queries (and let the AI do it for you) next to the traditional A1 notation we invented.
The most useful aspect was that I could ask "what was the total contributed amount between January and June of 2020" and get an accurate answer for that as well. Since the date column is provided as an "MM/DD/YYYY" string, I would normally have to do some boilerplate work to sanitize this.
For my particular use case, the charting aspect left a few things to be desired - once I grouped campaign donations by contributor, I could only see the first 10 rows in the AI response, with no option to expand the output. But overall I was truly blown away that something like this is even possible for a small team to build.