observablehq / feedback

Customer submitted bugs and feature requests
42 stars 3 forks source link

Add spreadsheet cells #568

Open LaoTzunami opened 1 year ago

LaoTzunami commented 1 year ago

Is your feature request related to a problem? Please describe. Working with CSV files is inconvenient and harder for new people to learn. I know you can link to a google sheet, but I'd rather not have to make a new file in my drive.

Describe the solution you'd like A spreadsheet cell that allows you to make and edit CSV files in observables and copy+paste from other spreadsheets

Additional context For my work, I've been using some data viz tools like Flourish. It has a spreadsheet tab for data, and integration for all of the charts. It makes making a quick chart way faster. I like the control of D3 for making complex visualizations once I know what I want to present, but I don't use it for exploratory data. If you combined a spreadsheet cell with your new chart cell, you would have an open source competitor to the other data visualization product out there. Plus it would go great with your new chart cell.

I'd love to get the people I work with to switch from Flourish to Observables.

declann commented 1 year ago

RE "open source"

I think the Chart cell is part of the OHQ editor which is not open source, similarly your spreadsheet cell may not necessarily.

However, it would be a neat feature. Semi-possible without being a core feature, e.g. https://observablehq.com/@mariodelgadosr/hello-jspreadsheet-ce-v4-the-javascript-spreadsheet

In my notebooks I use csv FileAttachments and users need to edit data and upload it, which isn't a perfect experience.

edit: +1 for being even nicer if the feature is free/open source - ditto for Chart cell (& please someone correct me if I am wrong above!)

visnup commented 1 year ago

I kinda wish for something even simpler: an editable table. it doesn't need any "spreadsheet" functionality like formulas, just the ability to layout data in a table, and edit values in place. more akin to notion.