Transform, clean, and enrich your scraped data with AI.

A built-in data transformation tool that lets you clean data, calculate, categorize, and extract insights from your data. Describe what you need in plain language and Formula AI writes the formula for you.

Extract data and transform it in one platform. No spreadsheets, no code, no extra tools.

Describe it, AI writes the formula

Type what you want in plain language. Formula AI understands your table columns and row data, generates the formula, and shows you a live preview of the results before you save. Refine with follow-up messages. No syntax to learn.

Transform every row, automatically

Create calculated columns that clean, combine, categorize, or calculate new values from your extracted data. Formulas run on every row, including all future extractions. Your data transformation logic is always up to date.

Scale with bulk operations and workflows

Run bulk tasks across your data, chain robots together with workflows, and use calculated columns as input parameters for downstream automations. Build complete data pipelines without writing code.

The most popular ways teams use Tables to transform their data

Clean and standardize pricing data

Scraped prices come with currency symbols, commas, and formatting that breaks analysis. Tables automatically strips text, converts to numbers, and standardizes formats across every extraction.

Categorize and segment rows

Label products as budget, mid-range, or premium. Flag leads as hot, warm, or cold. Create stock status indicators. Build any categorization logic by describing your rules in plain language.

Calculate margins, discounts, and percentages

Turn raw price data into business intelligence. Calculate profit margins, discount percentages, price-per-unit, and other derived metrics directly in your table.

Extract emails, domains, and contact info

Pull structured data out of messy text fields. Extract email addresses from contact blocks, domain names from URLs, or first names from full name fields.

Validate data completeness

Automatically flag rows that are missing critical fields. Identify incomplete records before they flow into your CRM, spreadsheet, or downstream tools.

Create a data transformation in under 30 seconds

Step 1: Open your robot's Tables view

Navigate to any robot and switch to the Tables view to see your extracted data in a structured table format.

Step 2: Click "add calculated column"

Click the add calculated column button in the top-right corner of your table to open the formula editor with Formula AI.

Step 3: Describe what you want in plain language

Type a description of the transformation you need. Formula AI understands your columns and data, then generates the formula automatically.

Step 4: Review the live preview with your actual data

See formula results evaluated against your real row data in real time. Refine with follow-up messages if needed.

Step 5: Save and it runs on every extraction

Click Save and your calculated column applies to all existing rows and every future extraction automatically. No maintenance required.

Everything you need to transform scraped data without leaving Browse AI

Formula AI

Describe your formula in plain language. The AI generates it, you preview it, done. Supports follow-up refinements with full conversation context.

Live Preview

See formula results evaluated against your actual row data in real time. Verify before you save.

50+ Formula Functions

Full library of text, math, logic, and regex functions. Compatible with familiar spreadsheet syntax.

Calculated Columns

Add new columns that transform data automatically on every extraction. Clean, combine, categorize, calculate.

Bulk Operations

Run operations across your entire dataset. Process hundreds or thousands of rows at once.

Workflow Integration

Use calculated columns as input parameters in workflows. Chain robots together for end-to-end automation.

Transformed data flows directly to your favorite tools

Your cleaned, categorized, and enriched data syncs automatically to Google Sheets, Airtable, and 7,000+ apps via Zapier. No extra export steps. The data that arrives in your tools is already transformed.

Integrations

Integrate with other tools to automate your workflow

Your automations can be connected two-way to Google Sheets, Airtable, and 5,000+ other apps in no time.
Integration iconIntegration iconIntegration iconIntegration iconIntegration iconIntegration icon

Need fully managed data extraction and transformation?

Browse AI Premium gives you a dedicated team to set up, maintain, and scale your data pipelines. We handle the robots, the transformations, and the delivery so your team can focus on using the data.

Talk to sales

Frequently asked questions

What is Formula AI?

Formula AI is an AI-powered assistant built into Browse AI's calculated column editor. You describe what you want in plain language, and it generates the formula for you. It understands your table columns and row data, and you can preview results before saving.

Do I need to know formula syntax to use Tables?

No. Formula AI lets you create formulas by describing what you need in plain English. You can also write formulas manually if you prefer.

What kinds of transformations can I do?

You can clean and standardize text, convert data types, calculate new values (margins, percentages, scores), categorize and segment rows, extract patterns from text (emails, domains, phone numbers), validate data completeness, and more.

Do calculated columns run on new data automatically?

Yes. Once you create a calculated column, it applies to all existing rows and every future extraction automatically.

Can I use calculated columns in workflows?

Yes. Calculated columns can be used as input parameters in workflows, so you can chain robots together and pass transformed data between them.

Does the transformed data sync to Google Sheets and Airtable?

Yes. All calculated columns are included when your data syncs to Google Sheets, Airtable, or any integration via Zapier.

What formula functions are supported?

Browse AI supports 50+ functions including text manipulation (SUBSTITUTE, CONCATENATE, TRIM, REGEXEXTRACT), math (ROUND, VALUE, ABS), logic (IF, AND, OR, NOT), and error handling (IFERROR, ISBLANK). See our full reference guide in the help center.

Is there a limit to how many calculated columns I can create?

There is no hard limit. You can create as many calculated columns as you need, and they can reference each other.