Free Online Tools for Excel & Calculation
Simple and quick solutions to help you with your daily tasks
Tools
Excel Column Converter
Instantly convert Excel column letters to numbers (A=1, Z=26, AA=27...)
Excel Date Converter
Convert Excel serial numbers to dates and dates to Excel serial numbers.
Percentage Calculator
Calculate percentages: X% of Y, what %, percentage change, apply a variation.
VAT Calculator
Convert pre-tax to total (with VAT) or total to pre-tax. Shows all three values instantly.
Column Number to Letter
Convert any Excel column number to its letter (1=A, 26=Z, 27=AA...). Reverse of the column converter.
Column Difference Calculator
Count how many columns are between two Excel column letters, with exclusive and inclusive counts.
Range Size Calculator
Enter a range like C5:F10 and instantly get the number of columns, rows, and total cells.
Column Offset Calculator
Apply a positive or negative offset to an Excel column letter and get the resulting column.
A1 ↔ R1C1 Converter
Convert Excel cell references between A1 and R1C1 notation. Useful for VBA authors and power users.
CSV to Excel
Turn a CSV into a real .xlsx file, without the import wizard.
Excel to CSV
Turn an .xlsx workbook into a clean CSV, one sheet at a time.
JSON to CSV
Flatten a JSON array into a spreadsheet-ready CSV.
CSV to JSON
Turn a CSV into a clean JSON array of objects.
JSON to Excel
Turn a JSON array into a real .xlsx workbook.
XML to CSV
Pull the repeating records out of an XML file into a flat CSV.
XML to Excel
Turn an XML feed into a real .xlsx workbook.
TXT to CSV
Turn a delimited text file into a proper CSV.
TXT to Excel
Open a delimited text export as a real Excel workbook.
vCard to CSV
Turn an exported contacts .vcf file into a readable CSV.
CSV to vCard
Turn a spreadsheet of contacts into a .vcf file you can import.
iCal to CSV
Turn a calendar .ics export into a spreadsheet of events.
HTML table to Excel
Paste a table copied from a web page and get a clean .xlsx.
Loan Amortization Schedule
See every payment of a loan, and what each one buys.
Mortgage Calculator
Work out the monthly payment on a home loan from the price and your deposit.
Mortgage Extra Payment Calculator
See what paying a little more each month takes off a loan.
Car Loan Calculator
Work out the monthly payment on a vehicle loan.
Loan Payment Calculator
The monthly payment on any fixed-rate loan.
CAGR Calculator
The compound annual growth rate between two values.
Compound Interest Calculator
What a sum grows to, with or without regular contributions.
ROI Calculator
Return on investment, and the annualised rate behind it.
NPV and IRR Calculator
Net present value and internal rate of return for a series of cash flows.
COUNTIF Generator
Build a COUNTIF formula with the quoting right the first time.
COUNTIFS Generator
Build a COUNTIFS formula across several conditions at once.
COUNT and COUNTA Generator
Which of the two counting functions you actually want, and the formula for it.
SUMIF and SUMIFS Generator
Add up a column only where a condition holds — with the arguments in the right order.