Excel ↔ SQL Type & Formula Translator
Moving logic between spreadsheets and databases? Translate common Excel formulas into SQL expressions (and back), plus a quick type-mapping reference for migration projects.
Everything runs locally in your browser.
Tool interface
Result
Type mapping reference
| Excel | SQL (typical) | Note |
|---|---|---|
| Number (integer) | INT / BIGINT | Whole numbers only |
| Number (decimal) | DECIMAL(p,s) | Use DECIMAL for money |
| Currency | DECIMAL(19,4) | Store amounts, format later |
| Date | DATE | Excel serial → real date first |
| Time | TIME | Fraction-of-day in Excel |
| TRUE/FALSE | BOOLEAN / BIT | Engine-dependent |
| Text (short) | VARCHAR(n) | Pick a sensible length |
| Text (long) | TEXT | 32,767-char Excel limit |
Introduction
Spreadsheet logic and SQL express the same ideas differently. This translator converts the most common Excel formulas into standard SQL expressions and vice versa, and includes a type-mapping table for migrations.
How to use
- Pick a direction.
- Paste the formula or SQL expression.
- Click Translate and review the explanation.
Limitations
- Column ranges map to column names — adjust to your schema.
- Approximate-match lookups are not translated.
FAQ
Is my data uploaded anywhere?
No. Translation is pure local pattern matching.