Start free

Pick the right column for every field

After this lesson you can add columns of the right type (Number, Currency, Date, URL, Email, Checkbox, Select, Relation) and read the cost of any enrichment before adding it.

1:19 video with captions, written steps and transcript. Checked against Duckrow on October 3, 2026.

0:00 / 1:19

Narration: preview voiceA private equity team builds a list of Midwest services companies. The companies are example data.

The short answer

Click Add column on any table. The Enrich section lists paid and free enrichments with their cost, such as 6 credits a find for work emails. The Column section lists the plain types, which are free: Text, Number, Currency, Date, URL, Email, Checkbox, Select and Relation. Typed columns filter and sort properly; a Relation links rows to another table in the same workbook.

Step by step

  1. 1Open Add columnClick + Add column at the end of the header row. Search with Search columns and enrichments, or scroll.
  2. 2Read the cost firstEnrich shows each enrichment's price: Find work email 6 credits a find, Find mobile number 50, Find customers 2, Yes / No, Score and Pick one 1 credit a row, Use AI from 1 credit a row, Persona fit 1, Phone type free or 2 credits, HTTP API 1 credit a row; Email provider and Push to campaign are free.
  3. 3Add a plain typeColumn lists Text, Number, Currency, Date, URL, Email, Checkbox, Select and Relation, all free. The new column is named New <Type>; double-click the header to rename it.
  4. 4Set up a SelectA Select opens its settings: add options (each with a colour), drag to reorder, Save.
  5. 5Link with RelationChoose Relation, then Link to which table? and pick another table in the same workbook. Add one first if the workbook has only one table.

Try it in Duckrow

About five minutes, in your own workspace.

  1. Open Add column and type email to see what it offers and what each costs.
  2. Add a Number column for company size and fill three rows.
  3. Add a Select with three options and set a value in each row.
  4. If your workbook has two tables, add a Relation between them.

You're done when your table has typed columns that filter and sort the way you expect.

Check what stuck

Three quick questions. Nothing is saved.

  1. 1. You want to filter companies with 20 to 200 employees. Which type should Employees be?

  2. 2. Where do you see what Find work email costs before adding it?

  3. 3. What does a Relation column need?

Transcript

0:00The right type for each field

Employee counts you can filter, revenue bands spelled one way, and each company linked to its platform. It starts with picking the right column.

0:11The Add column picker

Click Add column. You can search, or scroll. Enrich lists what fills itself, with its cost before you add it: six credits a work email found, one credit a Jev answer, and free ones like email provider. Column lists the plain types, which are free.

0:31Types that work for you

Use Number for employee counts, so you can filter twenty to two hundred. URL for LinkedIn profiles. Date, Email, Currency and Checkbox do what they say. And a Select keeps revenue bands to one spelling: add the options once, and pick from them.

0:51Link rows with Relation

A Relation links each row to a row in another table of the same workbook. Here, each company points to its platform in the Platforms table.

1:02Recap

To recap. Add column lists every type, with its cost. Pick the type that matches the data. Relation links rows to another table. Next, find any row with filters, sorts and search.