Page MenuHomePhabricator

Epic: Implement spreadsheet-like cell editing for tabular data
Open, Needs TriagePublic


Add an ability to edit the table using a spreadsheet-like view (e.g. google spreadsheet, etc). Editing raw JSON is complicated and error prone.

Event Timeline

Yurik created this task.May 7 2016, 12:03 AM
Restricted Application added subscribers: Zppix, Aklapper. · View Herald TranscriptMay 7 2016, 12:03 AM
Eloy moved this task from Backlog to UI on the Commons-Datasets board.May 9 2016, 9:59 PM
cscott added a subscriber: cscott.

Parsoid actually has native support for JSON now:

All that's needed is VE support for editing this table structure.

@cscott, is there an example of a custom content hadler VE implementation? Something to quickly get started?

Yurik renamed this task from Implement spreadsheet-like cell editing for tabular data to Epic: Implement spreadsheet-like cell editing for tabular data.Dec 22 2016, 7:13 PM
Yurik added a project: Epic.
Yurik updated the task description. (Show Details)Dec 23 2016, 12:11 AM
Reasno added a subscriber: Reasno.May 11 2017, 11:19 AM
TheDJ added a subscriber: TheDJ.Mar 18 2020, 9:16 AM

There are lots of potential libraries for this listed on
Also some vue variants, which might be interesting as a test with our new Vue support.

Sophivorus added a subscriber: Sophivorus.

This was discussed at today's Wikipedia Weekly episode where one can watch Fuzheado and Keilana struggle with editing coronavirus statistics:

This feature request particularly relevant in the current pandemic. (e.g.

It is great that they are stored as JSON and can be transcluded by all Wikimedia projects, but the lack of a visual interface means that they are very cumbersome to edit.

Can we deploy something like the table editor in VisualEditor to the data namespace on Commons?

TheDJ added a comment.Apr 22 2020, 7:43 AM

@Fuzheado @Keilana there is a csv/excel import/export gadget for that that I made a couple years back.

It doesn't deal with the header completely, so you'll need to preserve that one, but it can help you in certain cases.

TheDJ updated the task description. (Show Details)Apr 22 2020, 7:54 AM
TheDJ updated the task description. (Show Details)

this is not a duplicate of T250877 Visual editing interface for tabular data on Commons.
a visual editing interface could edit JSON data like cells in a spreadsheet as VE does. but that is a down select you have made.

here are some examples of JSON as spreadsheet