How to copy or paste a whole column

You can quickly transfer data between Direct Commander and other apps (like spreadsheets and word processing applications) or within Direct Commander itself by copying and pasting the contents of entire columns. You can use this method of bulk editing for fields with values that can be copied as plain text.

You can copy data from the Link column to a link verification program, fix broken links, and paste them back.

Copying

Right-click on a column title in a Direct Commander tab and select Copy from the menu.

The column content is copied to the clipboard, and then you can paste it to another column, spreadsheet, text editor, or messenger.

Pasting

  1. Copy the data column to the clipboard.

  2. Right-click a column title in a Direct Commander tab and select Paste from the menu.

How data is pasted:

  • The column values are pasted into displayed objects regardless of which of them are selected. If you want to paste data into certain objects (rather than all of them), select relevant objects using quick search or query language first.

  • Objects with the specified field blank are skipped. For example, values from the Title 1 column are pasted into Text & Image ads, as if there were no image and combinatorial ads on the tab.

  • If the pasted data contains more values than there are objects on the tab, then:

    • If multiple parent objects are selected (for example, when pasting data in the Ads tab, you selected multiple ad groups in the Groups tab), the extra values are ignored.

    • If a single parent object is selected, new child objects are added. The type of new objects depends on which types have the pasted field. For example, you can create Text & Image and combinatorial ads if you paste ad text. When you paste links, you can create Text & Image ads, image ads, or combinatorial ads. The first object on the tab determines the ad type (except for video ads, which can't be created in Direct Commander).

  • Empty rows at the end of the pasted data are ignored. Blank rows in the beginning or middle of pasted data clear the corresponding fields in Direct Commander.




You can also go to