monday.com app

Clean data. Automatically.

Clara formats and sanitises monday.com column values the moment they change. Text, numbers, phones, emails, banking codes, postcodes, and time. 50 formats, zero manual work.

When ARR changes

Then format ARR as Format

Set up Clara like any monday automation.
Pick a column, choose a format, done.

Install on monday See features

Inconsistent data eats your time.

Column values arrive in messy formats. Clara normalises them on every change.

Text

Extra spaces and wrong casing

People paste values with leading spaces, shout in ALL CAPS, or mix casing within the same column. Reports and filters break because hello and Hello are treated as different values.

Clara trims whitespace and applies Title Case, UPPERCASE, lowercase, or Trim Spaces the moment a cell changes.

Before hello world
After Hello World
Before MAX@EMAIL.COM
After max@email.com

Numbers

Mixed decimal and thousand separators

EU teams write 1.234,56. US teams write 1,234.56. The same board ends up with both, which makes sorting and rollups unreliable.

Pick US, EU, CH, or FR number formats, with currency, percentage, and compact notation also available. Clara rewrites the cell to your locale on change.

Before 1234567,89
After 1,234,567.89
Before 1234567.89
After 1.234.567,89

Phones

Local formats without country codes

Numbers arrive as 0049…, (555)…, or bare digits. Dialling and CRM sync need a consistent international prefix.

When a number includes + or 00, Clara formats to E.164 with a spaced prefix. Numbers without a prefix are cleaned but not country-guessed. Email formatting is also available in the Contact category.

Before 0049 170 1234567
After +49 170 1234567
Before +1 (555) 123-4567
After +1 555 123 4567

Time

Timesheet notation that means different things

One person enters 0.45 meaning 27 minutes. Another enters 90 meaning 90 minutes. Fractions like ¾ add another layer of ambiguity.

Clara parses decimal hours, total minutes, and fraction notation, then writes back HH:MM, decimal hours, days, weeks, and more depending on your format choice.

Before 0.45
After 00:27
Before 90
After 01:30
Before ¾
After 00:45

How it works

Three steps. No code. Runs on every column change.

Trigger

When a column changes on your board, monday sends the cell value to Clara.

Format

Clara applies your chosen transformer: text, number, time, phone, email, banking code, or postcode pattern.

Done

The cell is updated automatically. Clean data, every time.

Format categories

50 transformers across six categories. Each handles real-world input variations.

Text

  • Title Case
  • UPPERCASE
  • lowercase
  • Trim Spaces

Numbers

  • US format (1,234.56)
  • EU format (1.234,56)
  • CH format (1'234.56)
  • FR format (1 234,56)
  • Integer US / EU
  • Currency USD / EUR
  • Percentage
  • Compact K/M/B/T
  • Compact DE

Time and duration

  • HH:MM
  • H:MM
  • Decimal hours
  • Decimal hours DE
  • Hours and minutes
  • Total minutes
  • Days
  • Weeks

Contact

  • Phone (+prefix, E.164)
  • Email and domain cleanup

Finance

  • IBAN (modulo-97 validated)
  • BIC / SWIFT
  • US ABA routing
  • UK sort code
  • Canadian transit
  • Australian BSB
  • Indian IFSC
  • Card numbers (Luhn)

Address

  • NNNNN (5-digit)
  • NNNN (4-digit)
  • NNN NN (SE-style)
  • NN-NNN (PL-style)
  • AN NAA (UK)
  • NNNN AA (NL)
  • ANA NAN (CA)
  • + 10 more patterns

Column compatibility

Clara works best with text columns. Numbers columns accept numeric output only. See the Setup guide for board and automation steps.

Supported

Text columns: all 50 formatters work. Recommended for every format type.

Limited

Numbers columns: numeric output only. Suffixes like d, min, % are stripped.

Not supported

Status, Date, People, and other types: monday does not allow write-back to these column types via automation.

Pricing

Simple usage-based plans. Billed through the monday.com marketplace.

All plans include all 50 formatters. Limits reset each billing period.

Free

$0/mo

Up to 50 transformations per month

Install free

Basic

$5/mo

$40/year billed annually

Up to 150 transformations per month

Install on monday
Popular

Pro

$10/mo

$100/year billed annually

Up to 10,000 transformations per month

Install on monday

Team

$25/mo

$250/year billed annually

Up to 25,000 transformations per month

Install on monday

Upgrade or change plans anytime in monday → Installed Apps.

What counts as a transformation? One successful Clara automation run — including when the loop guard skips a write because the formatted value is already correct.

Two separate limits

Clara usage is governed by two monthly counters:

  1. Clara app plan — transformations Clara will run (Free 50 · Basic 150 · Pro 10,000 · Team 25,000 per month).
  2. monday.com account — automation actions on your monday plan (Standard: 250/mo, Pro: 25,000/mo). Each Clara run uses ~1 automation action.

Clara limits are set below typical monday account ceilings so you are more likely to upgrade your Clara plan than exhaust your entire monday automation quota.

Full pricing details

Frequently asked questions

Common questions about Quinsy Clara, monday.com automations, and data formatting.

What is Quinsy Clara?

Quinsy Clara is a monday.com automation app that formats and sanitizes column data the moment a cell changes. It runs as a workflow action inside your monday.com board, so values are cleaned without manual editing or scripts.

How does Clara work with monday.com automations?

You create an automation where a column change triggers the Quinsy Clara action and you pick a format from the dropdown. monday.com sends the board ID, item ID, column ID, and cell value to Clara, which applies the transformer and writes the result back to the same column.

What types of data can Clara format?

Clara formats text, numbers, phone numbers, email addresses, banking codes, postcodes, and time or duration values. Each category handles real-world input variations such as mixed separators, local phone formats, and timesheet notation.

How many format types does Clara include?

Quinsy Clara includes 50 formatters across 6 categories: Text, Numbers, Time and duration, Contact, Finance, and Address. You choose one format per automation recipe.

Which monday.com column types does Clara support?

Text columns support all 50 formatters and are the recommended choice. Numbers columns accept numeric output only, with suffixes like d, min, or % stripped. Status, Date, People, and other column types are not supported because monday.com does not allow write-back via automation.

Should I use a Text or Numbers column with Clara?

Use a Text column when the formatted result includes labels, units, or symbols such as 1h 30m, $1,234.56, or +49 170 1234567. Use a Numbers column only when you need a raw decimal value without suffixes, for example 1.5 decimal hours on a hours column.

Can Clara fix mixed US and EU number formats?

Yes. Clara can rewrite numbers between US (1,234.56), EU (1.234,56), CH (1'234.56), and FR (1 234,56) formats. When both period and comma appear, the last separator is treated as the decimal mark.

How does Clara handle timesheet values like 0.45 or ¾?

Clara parses timesheet notation where the fractional part represents minutes, so 0.45 means 45 minutes and outputs formats like 00:45. It also understands fraction characters such as ¾ and plain minute values like 90.

What is the difference between 1.5 and 1.30 in Clara time parsing?

The value 1.5 is read as 1.5 decimal hours, while 1.30 is read as 1 hour and 30 minutes in timesheet notation. Pick the output format that matches how your team records time, such as HH:MM or Decimal hours.

Can Clara format phone numbers internationally?

Yes. Phone numbers that include a + prefix or 00 international prefix are validated and formatted to E.164 with a spaced country code, for example +49 170 1234567. Clara uses libphonenumber for global phone validation.

Does Clara add country codes to local phone numbers?

No. Clara does not guess a country code for local numbers without a + or 00 prefix. It only removes spaces and dashes, so 0170 1234567 becomes 01701234567 without adding +49.

Can Clara normalize email addresses?

Yes. The Contact · Email and Domain formatter lowercases addresses, trims whitespace, and cleans the domain portion. For example, Max@EXAMPLE.COM becomes max@example.com before CRM sync or exports.

Does Clara format banking codes and postcodes?

Yes. Finance formatters cover IBAN, BIC/SWIFT, US ABA routing, UK sort codes, Canadian transit, Australian BSB, Indian IFSC, and card numbers. Address formatters cover 17 postcode patterns such as NNNNN (e.g. 28355), AN NAA (UK), and NNN NN (Sweden). Pick the target pattern from the dropdown.

What happens if Clara cannot parse a value?

The original cell value is left unchanged. The automation completes successfully and returns the unmodified text, so a bad entry does not break your workflow or clear the cell.

Can Clara cause infinite automation loops?

No. Clara includes a loop guard that skips the write-back when the formatted output is identical to the current value. This prevents a column change from re-triggering the same automation endlessly.

Does Clara store my monday.com board data?

Clara processes cell values in-flight during each automation run and does not build a persistent copy of your board data. For details on retention and processing, see our Privacy Policy.

Do I need to write code to use Clara?

No. Clara is configured entirely inside the monday.com automation builder with a format dropdown. You map trigger fields to action inputs using the provided automation template and pick the formatter you need.

How do I install Clara on monday.com?

Click Install on monday on this page, or find Quinsy Clara in the monday.com marketplace. Then add Clara as an action in your board automations and pick a format from the dropdown.

Is Quinsy Clara free?

Clara includes a free plan with 50 transformations per month. Paid plans: Basic 150/mo ($5), Pro 10,000/mo ($10), Team 25,000/mo ($25). All plans include every formatter. Each run also consumes one monday.com automation action from your account quota (Standard: 250/mo, Pro: 25,000/mo). Billing is handled through the monday.com marketplace. See our pricing section or pricing page for details.

Who makes Quinsy Clara?

Quinsy Clara is made by Quinsy, a productivity suite of focused apps for modern work tools. Clara is the first Quinsy product and is built specifically for monday.com teams.

Setup guide

Choose the right column type on your board first, then add the automation. Column compatibility overview

Create the column on your board

Choose Text, Long text, or Numbers based on the formatter you plan to use. Pick the column type for the formatted result, not for how the input looks today.

Install from the marketplace

Install Quinsy Clara from the monday.com marketplace. Your admin can add it from Apps or via the install link in the Developer Center.

Add the automation template

Open a board → Automate → search for Quinsy Clara → add the template: When column changes → format column as format.

Pick column and format

Select the column to watch and choose a formatter from the dropdown (e.g. Text · Title Case, Number · EU, Time · HH:MM). No mapping needed for formatType.

Map trigger fields

On newer automation builder accounts, map the trigger output to the action input:

  • boardId → boardId
  • itemId → itemId
  • columnId → columnId
  • currentValue → columnValue

Test it

Edit a cell in the watched column. Clara reads the value, applies the format, and writes the result back automatically.

Column types on monday.com

Create the column on your board before you add the automation. Pick the column type based on what the formatted result needs to look like, not based on what the input looks like today.

Column type Recommended? Notes
Text Best choice All formatters; supports labels and units (1h 30m, 0.75 d, DE89 3704 …)
Long text Good Same as Text; useful for longer formatted values
Numbers Limited Only pure numeric output (e.g. 1234.56, 0.75). Suffixes like d, min, %, € are stripped
Name (item title) Use carefully Works technically, but formatting the item name affects board navigation
Status, Date, People, etc. Not supported Clara is for text-like and numeric values only

Default rule: use a Text column unless you need a plain decimal for rollups (e.g. Time · Decimal hours on an hours column).

Common mistakes

  • Numbers column + formatted output: Currency, Percentage, Compact, or HH:MM (error or stripped result)
  • Time · Days on a hours column: 6 hours becomes 0.75 days; use Decimal hours instead
  • Status / Date / People column: monday blocks automation write-back
  • Timesheet vs decimal: 1.30 means 1h 30m, not 1.3 decimal hours
  • Finance / Address patterns: pick the target pattern (e.g. IBAN, NNNNN); invalid input is left unchanged

Behaviour & limits

  • Clara reads and writes the same column that triggered the automation
  • Loop protection: no API write if formatted value equals current value
  • Errors: Clara returns HTTP 200 to monday; check the automation run log
  • Unrecognisable input: left unchanged (cell not cleared)

Ready for clean data?

Install Clara on monday.com and start formatting automatically.

Install on monday