Edit data

With EDITable, you can edit the contents of your source table. All changes you make are synced with the source in real time.

1. Overwriting data

To overwrite any existing data, simply double-click on the cell and enter the new data. The value is updated, and the 'Changes' icon in the status bar displays the number of changes you made.

Overwriting data

In the toolbar, click Save to save the changes to the source, or Discard to undo the changes and return to the original value.

Save changes to source/Discard changes

2. Find and Replace

Use this option to find a specific text or value and its occurrences in the table, then replace it with another text or value in one or more instances.

1. Click Replace in the toolbar.

Find and Replace

2. Enter the text/value to be searched in the 'Find' text box and the text/value that will replace it in the 'Replace' text box.

Enter the text to be searched

3. In the 'Column' dropdown, select 'All' to search in all columns, or select the column from which the text must be searched.

Column to be searched

4. Click Find Next to locate the first occurrence and subsequent occurrences one by one.

Find Next

5. Click Find All to locate all occurrences of the text/value at once.

Find All

6. Similarly, click "Replace" to replace the selected occurrence and "Replace All" to replace all occurrences.

Replace

Replace All

Search Options:

Match Case: Check this box to find and locate only if the case of the entered text matches the data.

Match entire cell contents: Check this box to highlight the occurrence only if the entire cell content in the table matches the entered text.

3. Bulk Edit

EDITable's bulk edit feature allows you to edit or delete multiple rows at once without having to do it one by one, which saves time and ensures accuracy.