Field types

Field types

Every field has a type. The type decides how a value from the page is cleaned before it is saved: a price becomes a number, a short link becomes a full address, a phone number becomes digits.

TypeWhat you getExample
textThe text as you see it on the page, tidied up.Trailhead 40L Pack
urlA full web address you can open, even when the page uses a short one.https://shop.example.com/products/trailhead-40l
imageThe full address of the image, at the largest size the page offers.https://shop.example.com/img/pack-1200.jpg
numberThe first number in the text, as a real number you can sort and sum.4.7
priceThe amount as a number, without the currency sign or code.1299
emailA clean, lowercased email address.hello@example.com
phoneA phone number as digits only, ready to dial or match.+15125550142
markdownText with its formatting kept: headings, bold, lists and links, written as Markdown.Lightweight **40 L** pack - Rain cover

text Text

The text as you see it on the page, tidied up.

  • Runs of spaces, tabs and line breaks become one space.
  • Spaces at the start and end are removed.
  • An empty value leaves the cell blank.
On the pageIn your dataset
Trailhead 40L Pack Trailhead 40L Pack
Free shipping over $50Free shipping over $50

Exports: Saved as text in CSV, Excel and JSON.

Use it for: Names, titles, categories, and anything you want kept exactly as written, such as salaries or opening hours.

url Link

A full web address you can open, even when the page uses a short one.

  • Short links such as /products/42 are completed with the page’s address.
  • Links starting with // get the page’s https: or http:.
  • Script links (javascript:) and a bare # are left out.
  • mailto:, tel: and data: links are kept as they are.
On the pageIn your dataset
/products/trailhead-40lhttps://shop.example.com/products/trailhead-40l
//cdn.example.com/guide.pdfhttps://cdn.example.com/guide.pdf
javascript:void(0)(blank)

Exports: Saved as text in CSV, Excel and JSON.

Use it for: Product and detail page links, websites, PDFs, apply and ticket links. A link column can feed Detail Extract.

image Image

The full address of the image, at the largest size the page offers.

  • Reads a plain image address, a responsive list of sizes (srcset), or a CSS background image.
  • From a list of sizes, the largest one is kept.
  • Short addresses are completed with the page’s address.
  • Embedded data: images are kept as they are.
On the pageIn your dataset
/img/pack-400.jpg 400w, /img/pack-1200.jpg 1200whttps://shop.example.com/img/pack-1200.jpg
background-image: url("/img/hero.jpg")https://shop.example.com/img/hero.jpg

Exports: Saved as the image address in CSV, Excel and JSON. To save the files themselves, use Bulk download on this column.

Use it for: Product photos, logos, covers, thumbnails and any image you want to download later.

number Number

The first number in the text, as a real number you can sort and sum.

  • Understands both 1,234.5 and 1.234,5, and spaces or apostrophes between thousands.
  • Reads k, M and B: 12k becomes 12000.
  • Keeps minus signs, and accounting negatives with a currency inside brackets, such as ($5).
  • A plain number in brackets, such as (991), stays positive: it is usually a count.
On the pageIn your dataset
4.7 out of 54.7
12k reviews12000
(991)991
1.234,51234.5

Exports: A number in Excel and JSON, so it sorts and adds up; plain digits in CSV.

Use it for: Ratings, review counts, views, followers, beds and baths, years and ranks.

price Price

The amount as a number, without the currency sign or code.

  • Removes currency signs and codes, such as $, €, £, ¥, ₫, USD or VND.
  • Understands both 1,299.00 and 1.299,00. A single dot before three digits, such as 1.234 €, means one thousand two hundred thirty-four.
  • For a range such as $10 – $20, keeps the first amount.
  • Amounts in currencies without cents, such as JPY, KRW or VND, are rounded to whole numbers.
  • Reads k and M, such as $1.2M.
On the pageIn your dataset
$1,299.001299
12,50 €12.5
$10 – $2010
1.234 €1234

Exports: A number in Excel and JSON; plain digits in CSV. Keep a separate currency field if you mix currencies.

Use it for: Prices, fees, rents, ticket prices, market caps and volumes.

email Email

A clean, lowercased email address.

  • Reads mailto: links and email addresses inside text.
  • Drops anything after ? in a mailto: link, such as a subject.
  • Lowercases the address and checks that it is valid; otherwise the cell stays blank.
On the pageIn your dataset
mailto:Hello@Example.com?subject=Hihello@example.com
Contact: sales@example.comsales@example.com

Exports: Saved as text in CSV, Excel and JSON.

Use it for: Contact addresses on business, team and profile pages.

phone Phone

A phone number as digits only, ready to dial or match.

  • Reads tel: links and phone numbers inside text.
  • Removes spaces, brackets, dots and dashes.
  • Keeps a leading + for international numbers.
  • Needs 7 to 15 digits; shorter or longer numbers are left out.
On the pageIn your dataset
+1 (512) 555-0142+15125550142
tel:020%207946%20095802079460958

Exports: Saved as text in CSV, Excel and JSON, so leading zeros and the + are kept.

Use it for: Business and contact phone numbers.

markdown Markdown (rich text)

Text with its formatting kept: headings, bold, lists and links, written as Markdown.

  • Reads the element’s HTML instead of its plain text.
  • Turns headings into #, bold into **, list items into - or 1., and links into [text](address).
  • Short link and image addresses are completed with the page’s address.
On the pageIn your dataset
<p>Lightweight <b>40 L</b> pack</p><ul><li>Rain cover</li></ul>Lightweight **40 L** pack - Rain cover

Exports: Saved as Markdown text in CSV, Excel and JSON.

Use it for: Descriptions, articles and documentation where structure matters, for example to feed an AI tool or a website.

Options on every field

Read from

The visible text of the element, or one of its attributes, such as href, src, alt, title or a data- attribute. The menu lists the attributes the element actually has.

All matches (list)

Off: the first match in each item. On: every match, as a list. Lists are joined with a comma and a space in CSV and Excel, and kept as lists in JSON.

Name

The column name in the dataset and in exports. Rename it to anything.

Type

Change it at any time from the field’s type icon.

Empty values

When a page has no value for a field, the cell stays blank. Nothing is made up.

See which fields each kind of page gets in Magic: kinds of pages.

Try it on your own pages

Running extractions is free. Verify your email for 5 free days of unlimited exports.

Add to Chrome