Copy & Edit List Data
Copy cells, columns, and complete long values from ServiceNow lists, or edit a selected set of cells.
Last updated: November 2, 2026
Copy a single value, export a grid of selected cells, or open the native editor for a selected column.
Copy Cells and Copy Column
Select one or more cells in a list, then use the /copycells command to copy the text of selected cells.
| Switch | Result |
|---|---|
/copycells | Cell text, one per line. Paste straight into Excel or a text file. |
/copycells -s | sys_ids only, comma-separated. Handy for scripts (addEncodedQuery('sys_idIN' + …)). |
ServiceNow's native list lets you select cells within a single column at a time, so /copycells always produces a one-per-line list of values from that column.
/copycolumn: copies every non-empty value in the column where a cell is selected, even if only one cell is highlighted. Use /copycolumn -s for sys_ids instead of display values.
Cell Select / Copy Mode
ServiceNow opens its inline editor on a single click in a list cell. Cell Select / Copy Mode flips that around so a click copies the cell instead: handy for grabbing values without accidentally editing the record.
Click the Cell Select / Copy Mode icon next to the personalize-list gear to toggle the mode on. While it's on, ServiceNow's single-click inline editor stays out of the way, clicking a reference link no longer navigates away, and you can still drag across a cell to select its text by hand (an active text selection won't trigger a copy).
Need just one value? Hold Ctrl (Cmd on macOS) while clicking the icon. The mode arms for a single copy: the next cell you click is copied and the mode switches itself off, so there is no second click on the icon. Press Esc to cancel. Available in every edition.
Free: click any cell to copy its value straight to the clipboard (the cell flashes to confirm), or drag to select text by hand: inside a single cell or across several: and copy just that with your normal copy shortcut. Press Esc to turn the mode off. The copy confirmation also shows what Pro adds and stays visible long enough to use the upgrade link (trial for official builds, installation guidance for the unpacked GitHub edition); when a list value reaches ServiceNow's 1000-character limit, it specifically explains that Pro can fetch the full content.
Pro / Trial / Enterprise: the mode grows into a full multi-cell picker with a floating toolbar:
- Click cells to add or remove them from a selection: picked cells stay highlighted.
- Drag across cells to rubber-band a rectangular range in one gesture (drag within a single cell still selects its text).
- Click a column header to pick (or unpick) that column across all visible rows at once. Click individual cells when you only want specific rows.
- Pick the output format: TSV (default, pastes into Excel as columns), CSV, Pipe, or Markdown: tick Header to prepend column labels, and sys_id to add a
<field> - sys_idcolumn next to each picked column. Reference fields give the referenced record's sys_id, the record-link column gives the row's own sys_id, and plain values stay blank. - When a selected value was truncated by ServiceNow at 1000 characters, Cell Select automatically fetches the complete field value. A small, subtle download icon at the right edge of the selected cell marks that its full content is ready without changing the cell text. The toolbar briefly confirms Full content ready in an animated row below the controls; if preparation takes a moment, that row first shows Preparing selected text…. After copying, the same row confirms when full content from long cells was included, or warns that some text may be incomplete.
- Tick Links to keep values that show as hyperlinks in the list (like a
task.numberreference) clickable when you paste into a rich-text destination (Excel, Word, Outlook, Google Docs). Markdown output writes them as[text](url); plain-text targets still get the values. - Copy assembles your picks into a row × column grid (aligned by column position) and writes it to the clipboard. When the mode opens, the toolbar status row shows the shortcut for your OS (Ctrl+C on Windows/Linux or ⌘C on macOS) and keeps that hint visible while you pick cells. A manually selected piece of text or focused form field keeps the browser's normal copy behavior. Clear drops the cell selection.
- Press Esc to clear the current selection; press Esc again (with nothing selected) to turn the mode off. If the ⋯ menu is open, Esc closes that menu first.
- The ⋯ menu contains Select all cells, Invert selection, Edit selected cells, and Fetch complete long values automatically. Automatic fetching is enabled by default.
- The toolbar is draggable by its title, and the × turns the mode off.
/copycolumns opens this same Pro toolbar from the slash palette: useful on records with related / embedded lists.
Edit selected cells
In Pro, select the cells you want to update, then open the ⋯ menu and choose Edit selected cells. All selected cells must belong to one column in one list. You can select non-adjacent rows, or click a column header to select its visible cells on the current page.
The action turns off Copy Mode and opens ServiceNow's native editor for exactly those selected cells. Review the affected-row count, enter the value, and use the native editor to save or cancel. ServiceNow's normal edit permissions still apply.
Edit selected cells stays clickable. If nothing is selected, or your selection spans multiple columns or lists, the toolbar explains what to change and keeps your selection intact. If list editing is disabled, it asks you to enable it in Personalize List.
Targets classic UI16 list2 views (including related and embedded lists on forms). Polaris / Workspace list views inside macroponent shadow roots are not yet wired up.