Excel and Google Sheets
Split Text Formula Builder
Generate TEXTSPLIT or SPLIT formulas for comma, pipe, tab, space, or custom delimiters.
Spreadsheet tools that answer first
FormulaDesk
Generate everyday Excel and Google Sheets formulas, clean pasted data, and jump into focused guides when a formula needs context.
Quick formula finder
Pick a task
=TEXTSPLIT(A2,",")
Use this when a cell contains values like "north,west,enterprise".
Tools
Start with the job, then copy the formula
Each tool does real work in the browser and includes spreadsheet formulas you can adapt.
Data cleaning
Remove Duplicates from a List
Paste a list, remove duplicate rows, optionally sort it, and get formulas for Excel and Sheets.
Date formulas
Date Difference Calculator
Calculate calendar days or business days between two dates and copy spreadsheet formulas.
Finance-safe arithmetic
Percentage Change Calculator
Calculate percentage increase or decrease and copy the standard spreadsheet formula.
Whitespace and casing
Spreadsheet Text Cleaner
Trim messy text, collapse repeated spaces, change casing, and copy cleanup formulas.
Import helper
CSV Preview and TSV Converter
Preview pasted CSV, clean extra spaces, and convert it into spreadsheet-friendly TSV.
Lookup formulas
XLOOKUP Formula Builder
Build exact-match XLOOKUP formulas and see when VLOOKUP is still acceptable.
Logic formulas
IF Formula Builder
Create clear IF formulas for pass/fail, status labels, and threshold checks.
Google Sheets
REGEXEXTRACT Builder
Generate Google Sheets REGEXEXTRACT formulas for emails, domains, order IDs, and custom patterns.
Validation helper
Character, Word, and Line Counter
Count characters, words, and lines before importing copy into spreadsheet cells.
Editorial direction
Built for search intent, not filler
FormulaDesk pairs utility pages with concise guides. That gives visitors an answer on the page, while search engines can understand the use case, syntax, and related workflows.
Guides
First long-tail articles
These pages support the tools and create natural internal links for spreadsheet search queries.
How to Split Text in Excel and Google Sheets
Use TEXTSPLIT in Excel or SPLIT in Google Sheets to separate names, tags, IDs, and imported CSV fields.
Remove Duplicates with UNIQUE in Excel and Google Sheets
Learn the clean formula-based way to deduplicate a list without changing your source data.
Calculate Days Between Dates in a Spreadsheet
Compare DAYS, subtraction, and NETWORKDAYS for calendar and business-day calculations.
Percentage Change Formula for Excel and Google Sheets
Calculate increase or decrease with the standard (new minus old) divided by old formula.
Clean Imported CSV Data Before It Reaches Your Workbook
A practical checklist for trimming cells, checking headers, and previewing rows before import.
XLOOKUP vs VLOOKUP: Which Formula Should You Use?
XLOOKUP is easier to read and safer for exact-match lookups, but VLOOKUP still appears in many legacy workbooks.
Simple IF Formula Examples for Spreadsheet Status Labels
Build readable IF formulas for pass/fail checks, threshold labels, and empty-cell handling.
REGEXEXTRACT Examples for Google Sheets
Extract emails, domains, and IDs from messy text with practical REGEXEXTRACT patterns.