CONVERSION
You did this in Excel? Here's how to say it in Orchestria.
11 concrete correspondences between Excel formulas and Orchestria's plain English rules. No more macros, no more nested formulas: describe what you want, the AI does it.
Try for free →1. VLOOKUP / XLOOKUP → Lookup within the same file
In Excel:
=VLOOKUP(A2,$D$2:$E$10,2,FALSE)You look up a value in one column to retrieve the corresponding information from another column in the same file.
In Orchestria (prompt):
"For each row, look up the product_code in the reference column and retrieve the corresponding label and unit_price."
Concrete example: your CSV contains orders and a product catalog in the same data. Orchestria matches them automatically, just like a VLOOKUP — but described in plain English.
Also works for simple code translations:
"Replace the category code with its label:
- A → Raw materials
- B → Services
- C → Transport"
Whether it's a lookup within your data or a code mapping, just describe what you want and Orchestria does it.
2. IF / Nested IFs → Conditional rule in plain English
In Excel:
=IF(C2="",0,C2)
=IF(A2="US",C2*0.1,0)In Orchestria (prompt):
"If the amount field is empty, set it to 0."
"If the country is US, apply 10% sales tax."
Conditions are written in plain English, as you would explain them to a colleague. No need to nest IF() functions — Orchestria naturally handles multiple conditions.
3. Date reformatting → Format transformation
In Excel:
=TEXT(A2,"YYYY-MM-DD")
=RIGHT(A2,4)&"-"&MID(A2,4,2)&"-"&LEFT(A2,2)In Orchestria (prompt):
"Convert the date field from MM/DD/YYYY format to YYYY-MM-DD."
No more slicing strings with LEFT/RIGHT/MID. Just describe the source and target formats.
4. Calculations (gross→net, conversions, percentages) → Operations in rules
In Excel:
=C2/1.1
=C2*E2In Orchestria (prompt):
"Calculate the net amount from the gross amount with 10% tax."
"Multiply quantity by unit price to get the line total."
Orchestria understands arithmetic operations described in plain English and applies them to each row.
5. CONCATENATE / CONCAT → Field merging
In Excel:
=A2&" "&B2
=CONCATENATE(A2,"-",B2)In Orchestria (prompt):
"Merge the first_name and last_name fields into a full_name field, separated by a space."
Describe the desired result and Orchestria merges the fields automatically.
6. LEFT / RIGHT / MID → Substring extraction
In Excel:
=LEFT(A2,3)
=MID(A2,5,2)In Orchestria (prompt):
"Extract the first 3 characters from the reference field to create the country_code field."
No need to count character positions. Just describe what you want to extract.
7. SUBSTITUTE / REPLACE → Text replacement
In Excel:
=SUBSTITUTE(A2,",",".")
=TRIM(A2)In Orchestria (prompt):
"Replace commas with periods in the amount field."
"Remove extra spaces in the address field."
8. Remove duplicates → Deduplication
In Excel: Data tab → Remove Duplicates
In Orchestria (prompt):
"Remove duplicate rows based on the invoice_number field."
Specify which field to deduplicate on and Orchestria handles the rest.
9. Filter rows → Filtering rules
In Excel: Auto-filters or IF formulas to hide/delete rows
In Orchestria (prompt):
"Keep only rows where the amount is greater than 0."
"Exclude rows where the country is empty."
10. SUMIF / COUNTIF → Group and aggregate
In Excel:
=SUMIF(A:A,"Supplier X",C:C)
=COUNTIF(A:A,"US")In Orchestria (prompt):
"Group rows by supplier and calculate the total amount for each supplier."
Orchestria can group rows and then compute totals, counts, and averages on each group.
11. MIN / MAX / AVERAGE → Statistical aggregation
In Excel:
=AVERAGE(C2:C100)
=MAX(C2:C100)In Orchestria (prompt):
"For each supplier, calculate the average amount, the highest amount, and the lowest amount."
Aggregations work with grouping: group by a key, then compute the statistics you need on each group.
HOW IT WORKS
How it works
Provide input and output samples
Write your rules in plain English in the prompt
Execute and reuse the flow via API
Summary: Excel vs Orchestria
Traditional method
In Excel, each transformation requires a specific formula (VLOOKUP, IF, CONCATENATE, SUBSTITUTE...), often nested, hard to maintain, and that must be recreated for each new file. VBA macros add complexity and security risks.
With Orchestria
With Orchestria, all these operations are written in plain English in a single prompt. The generated flow is reusable via API for all your future files, with no formula or macro maintenance.