Transfer data record by record, or take values from another list

This article covers two separate tools: reviewing enrichment results one record at a time (instead of a bulk fill), and taking values into your list from another list of the workspace, matched row by row. For the standard flow — a run fills empty cells by itself, single-cell enrichments ask first — see "Fill empty cells with enrichment data"; this article goes deeper on the record-by-record dialog, plus the Value from list column.

Transfer data record by record#

Selecting rows with stored enrichment data and clicking Apply values in the Enrich menu opens Merge Enriched Information — the same dialog described in "Fill empty cells with enrichment data," here reviewed one record at a time instead of applying to every row at once.

For the current record, two tabs show what would change:

• Fill empty — values for columns that are currently empty on this row.
• Overwrite all — the best value ListPlus has for each field, including ones that would replace something already in the cell (shown struck through next to the new value).

Each line in the dialog is a field (a content type like email or job title) with a checkbox, its source (for example FullEnrich, LinkedIn, or an AI analysis), and the value it would write. Uncheck a field to leave it out. Selected records with nothing to transfer are shown as "N skipped" and left out of the review. When more than one record has values to apply, arrows next to a "current / total" counter step through them, and a checkbox labelled Ignore this skips the current record without applying anything to it. Apply this applies only the current record's checked fields; Apply to all like this applies the checked fields (from the active tab) to every record still pending, in one go. When only one of the selected records has values to apply, a single Apply button applies it directly.

This never costs credits — it only writes data ListPlus already fetched, the same as the automatic fill of empty cells during a run. Applied values are saved automatically; ⌘Z / Ctrl+Z undoes them.

Take values from another list#

To pull values from another list into matching rows — like a VLOOKUP/SVERWEIS — add a Value from list column: + Column → Compare → Value from list. The list menu's Value from another list... (the ⋯ menu in the list header, near Add Column), Take values from another list in the Enrich menu and Take a value from another list in Commands ⌘K all open that step. You pick the other list, match by Domain, Email or LinkedIn (never by name), and either one of its columns or Number of matches. The column fills when you create it and again on every Run in its header — never by itself — and costs credits per row on every Run; the Run button's tooltip shows the price (see "Price list: what every action costs"). No rows are added. With several matching rows, the first one in the other list's order that has a value wins. Details: "Look up in another list, and the List role".

The former four-step join page (Select Source · Define Link · Map Columns · Review & Apply, with fuzzy company-name matching and copying into existing columns) no longer exists. To combine two lists' rows into one, use Consolidate Lists (see "Merge two lists (Consolidate Lists)").

Related topics: fill-empty-cells · merge-lists · enrichment-overview · which-enrich-button.

FAQ#

Can I review enrichment results one record at a time instead of filling everything at once?#

Yes — select the rows and click "Apply values" in the Enrich menu to open Merge Enriched Information, which steps through each record with arrows and a "current / total" counter so you can review and apply one at a time.

What do the "Fill empty" and "Overwrite all" tabs do?#

"Fill empty" only shows values for columns currently empty on that row; "Overwrite all" shows the best value ListPlus has for each field of the row, including ones that would replace an existing cell value (shown struck through). Each field has its own checkbox so you can pick exactly what to apply.

What does "Ignore this" do when reviewing records?#

It skips the current record without writing anything to it and moves on, so it's excluded from "Apply to all like this." You can un-tick it later to bring the record back into the review.

What's the difference between "Apply this" and "Apply to all like this"?#

"Apply this" applies only the checked fields for the record you're currently viewing. "Apply to all like this" applies the checked fields from the active tab to every record still pending in the review, in one action.

Can I take values from another list, like a VLOOKUP or SVERWEIS?#

Yes — add a column with + Column → Value from list (the list menu's "Value from another list...", the Enrich menu's "Take values from another list" and Commands ⌘K open the same step). Pick the list, match by Domain, Email or LinkedIn, and choose one of its columns or Number of matches.

How are rows matched between the two lists?#

By Domain (company domain, website or work email domain; a subdomain also matches its parent), by Email, or by LinkedIn profile — exactly, never by company name. With several matching rows, the first one in the other list's order that has a value wins.

Does taking values from another list add new rows?#

No. It fills a new column in your existing rows; your row count doesn't change. To combine two lists' rows into one, use "Merge two lists" (Consolidate Lists) instead.

Does the "Value from list" column update when the other list changes?#

No. It fills when you create it and again each time you click Run in its header — never by itself. If the other list was deleted, the next Run empties the column and its header says so.

Can I take values from a list in another workspace?#

No, the other list must be in the workspace you're currently working in. Export it as a file in its workspace, import it into this one, and then look up in the imported copy.

Does transferring data record by record, or taking values from another list, cost credits?#

Transferring record by record is free: it only copies enrichment data ListPlus already fetched. A Value from list column costs credits per row of your list on every Run, charged after the run; the Run button's tooltip shows the price, and the price list has the rate.