Editing Data Cell by Cell in the Socrata Data Management Experience

The Socrata Data Management Experience now supports inline, or in-row, data editing! You can now directly edit individual cells in your dataset from within the platform UI, eliminating the need to upload new source files when making small changes or modifications to your datasets.

There is some simple validation available with this new feature, such as not being able to enter text in a number field, and offering a date picker for date and time fields. Please note that, if you are making cell-level edits to a dataset, you must do so after any relevant data transforms are applied; otherwise, the data transform will overwrite the cell-level edit when it is run against the original data.

Making an Inline Edit on an Existing Dataset*

1) Begin by opening a draft on the dataset whose cell(s) you want to edit. Under "Data Actions," select Review & Configure Data.


2) Once in the data table preview, click Load Published Data to see the contents of your dataset. From here, you can simply double-click any cell to edit or modify its contents. 

3) As you update each cell, click Save to apply your changes. Once all your updates for the dataset are complete, click Save in the data table preview and publish your updated dataset.

*Note: If you are in the process of creating a new dataset from scratch and want to make an inline edit, simply follow the process in steps 2 and 3 from the data table preview.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.