Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.databar.ai/llms.txt

Use this file to discover all available pages before exploring further.

Databar supports Excel-style formulas natively, so you never need to export your data to a spreadsheet just to run simple calculations or logic. Add a formula column to any table and get instant, row-level results.
Formulas are a transformation. They are computed locally and do not consume any credits.

​
How it works

Databar formulas use column references instead of traditional cell references. Instead of writing A2 or B2, you reference columns by name using curly braces: {column_name}. Each formula runs once per row, with the column references swapped for that row’s values. This means every formula is effectively a single-row operation. For example, if you have columns named employee_count and first_name, you would write: 
=IF({employee_count}>100, "High", "Low")

​
How to use

1

Open your table

Navigate to the table where you want to add formula logic.
2

Add a formula column

Click Enrich, then select Formulas & Tools. Choose Excel Formula from the list.
3

Write your formula

Enter any supported Excel formula, referencing columns by name using {column_name} syntax.
4

View results

Results are computed instantly for every row in your table.

​
Formula examples

Flag companies above a certain employee count:
=IF({employee_count}>100, "High", "Low")

​
Available formulas

FormulaDescriptionExample
IFReturns one value if a condition is true, another if false=IF({score}>80, "Pass", "Fail")
ORReturns TRUE if any argument is true=OR({country}="USA", {country}="UK")
ANDReturns TRUE if all arguments are true=AND({age}>18, {status}="active")
SUMAdds values together=SUM({q1_revenue}, {q2_revenue})
CONCATENATEJoins text strings into one=CONCATENATE({first_name}, " ", {last_name})
RANDBETWEENReturns a random integer between two values=RANDBETWEEN(1, 100)
STDEVCalculates the standard deviation of values=STDEV({score_a}, {score_b}, {score_c})
EOMONTHReturns the last day of the month N months from a date=EOMONTH({start_date}, 3)
ROUNDRounds a number to a specified number of digits=ROUND({revenue}, 2)
MAXReturns the largest value from a set of arguments=MAX({bid_a}, {bid_b})
MINReturns the smallest value from a set of arguments=MIN({price_1}, {price_2})
TODAYReturns today’s date=TODAY()
LENReturns the number of characters in a text string=LEN({description})
TRIMRemoves leading and trailing spaces from text=TRIM({raw_name})
LOWERConverts text to lowercase=LOWER({email})
UPPERConverts text to uppercase=UPPER({ticker})
MIDExtracts a substring from the middle of a text string=MID({phone}, 2, 3)
Looking for a different transformation? Use JQ formulas to transform JSON data, Table Lookup for VLOOKUP-style enrichments across tables, Split Text to break a column into multiple columns, or Merge Columns to combine values from several columns into one.

​
When to use formulas

  • Quick math on numeric columns (revenue, headcount, scores)
  • Concatenating text fields without a separate tool
  • Building conditional flags or labels for filtering and segmentation
  • Rounding, formatting, or normalizing values before export

Tables overview

Learn how tables work in Databar.

JQ formulas

For JSON-level querying, use JQ expressions.