Edit Data

It is possible to edit your data from the data tab. To add more data to your sheet, type it in directly, use the Add Row and Add Column buttons in the toolbar, use Ctrl+V to paste into the data grid, or right-click and choose Paste Special to paste a larger block of data through a dedicated entry screen.

Any data edits you make will be applied to all charts in the sheet.

Editing Data

Edit mode will automatically turn on if you’ve edited the sheet. Any cells you’ve edited will be highlighted in blue.

A Cancel and Save button will appear, and outside toolbars will become disabled.

To leave edit mode, either click Cancel or Save Edits, to save any changes you have made.

The edited cells are highlighted in blue. Click Save Edits to save your changes.

Editing Individual Cells

Double click a cell to edit its data. You can also paste from your clipboard using Ctrl + V .

Find and Replace

Sometimes it’s useful to replace a value across many cells at once, for example renaming short form data often found in spreadsheets (like “M” for “Male”) with a more descriptive value for charting.

Press Ctrl+F, or right-click a cell and select Find & Replace, to open the Find and Replace dialog. Switch to the Replace tab, enter the value to find and the value to replace it with, then click Replace to update the current match or Replace All to update every match at once.

Two checkboxes control how matching works:

Match case - off by default, so searches ignore capitalization
Match entire cell contents - off by default, so a search matches partial text inside a cell. Turn this on to only replace cells whose entire value matches exactly, the same behavior the old Replace Values worked with.

Saving Data Edits

Click the Save button to save any changes you have made. The saved edits will be applied to the underlying dataset of the sheet, and therefore all charts in the sheet will receive the updated data.

Edit Columns

To edit a column, open its menu from its top right corner.

Access each column's menu to edit it, set filters or delete it

Edit Column

Edit the column’s name and type here.

Set Filters / Remove Filters

Opens the Column Filters dialog for that column, or clears any filters already set on it.

Delete Column

Will delete the column from the sheet. This cannot be undone.

Other types of editing

Need to reshape your data? Several Data Transformations are available in InstaCharts.

Starting a new sheet? See Formatting Data for Import to structure your data before you upload.