How to Convert Liters to Gallons in Excel

To convert liters to gallons in Excel, enter =A1*0.264172 where A1 holds your liters — 1 liter equals 0.264172 US gallons. Drag the fill handle down to convert a whole column. For UK (imperial) gallons use 0.219969 instead. Check any result with our free liters to gallons converter.

The One-Line Formula

Type this into any cell: =A1*0.264172 (assuming your liters value sits in A1). That is the entire conversion — 1 liter = 0.264172 US gallons, so Excel multiplies and returns gallons. A worked example: put 50 in A1, enter =A1*0.264172 in B1, and you get 13.2086 gallons. Format B1 to two decimals and it reads 13.21 gal — clean enough for reports, fuel logs, and spec sheets. This single formula covers every version of Excel from 2007 onward, plus Google Sheets, LibreOffice Calc, and Apple Numbers, all of which evaluate the same expression identically.

Liters to Gallons Excel Formula, Explained Cell by Cell

Here is the production-ready setup. Put your liters values in column A (A2, A3, A4…), enter =A2*0.264172 in B2, then drag the fill handle down — Excel adjusts each row to A3, A4, and so on automatically. Pro move: put the factor 0.264172 in a dedicated cell, say $B$1, and write =A2*$B$1. The dollar signs lock the reference, so the factor never drifts as you fill down, and anyone auditing the sheet can see the conversion factor in one labeled cell instead of hunting through formulas. Label your columns (“Liters”, “US Gallons”), format results to 2 decimals, and the sheet is report-ready. Tracking smaller volumes in the same workbook? Our fluid ounces to liters converter covers the bottle-and-jug end of the scale.

The Liters to Gallons Conversion Factor: US vs UK

There are two gallons in common use, and mixing them up is the classic error. The US gallon factor is 0.264172 gal/L (1 US gallon = 3.78541 liters). The UK imperial gallon factor is 0.219969 gal/L (1 imperial gallon = 4.54609 liters) — about 20% larger. Use the US factor for American fuel economy, US recipes, and EPA figures; use the imperial factor for UK fuel consumption, British engineering specs, and older Commonwealth documents. A quick sanity check: if your answer looks about 20% too big or too small versus expectations, you grabbed the wrong gallon. The full US-vs-UK story, with history, is in our US gallon vs UK gallon in liters guide.

How to Convert Gallons to Liters in Excel

The reverse trip uses the reciprocal factor: =A1*3.78541 converts US gallons to liters. Worked example: 13.2086 in A1, =A1*3.78541 returns 50.0 liters — the round trip confirms the math. For imperial gallons the reverse factor is 4.54609: =A1*4.54609. A tidy pattern for two-way sheets: column A = liters, column B = =A2*0.264172 (gallons), column C = =B2*3.78541 (liters back) — column C should equal column A, which gives you a built-in error check on every row. If C drifts from A, a factor got typed wrong somewhere.

The Built-in Way: Excel's CONVERT Function

Excel ships a unit converter most people never discover: =CONVERT(A1,"l","gal"). The first argument is your value, l is liters, gal is the US gallon — Excel knows the exact factor internally, so there is nothing to mistype. For imperial gallons use =CONVERT(A1,"l","uk_gal"). Advantages over hand-typed factors: the formula documents itself (anyone reading it sees a unit conversion, not a magic number), the factor is exact to full precision, and it works identically in Google Sheets. One caveat: CONVERT is picky about unit codes — gal and uk_gal are correct, but gallon will throw a #N/A error. When in doubt, the online liters to gallons converter gives the same answer with zero syntax to remember.

Building a Reusable Two-Way Template

For a sheet you will use weekly — fuel logs, batch records, lab notebooks — build it once: Column A: Liters (your inputs). Column B: =A2*0.264172, labeled “US Gallons”. Column C: =A2*0.219969, labeled “UK Gallons”. Row 1: headers; freeze the top row (View → Freeze Panes) so labels stay visible. Add =ROUND(B2,2) wrappers if downstream formulas need tidy decimals, and use conditional formatting to flag any gallon value over a threshold (say, a tank capacity). Save it as a template (.xltx) and every future conversion is paste-and-done. For the container-size side of fuel and liquid tracking, our 5-gallon jug in liters breakdown pairs well with this sheet.

5 Mistakes That Break the Conversion

1. Wrong gallon: using 0.264172 on UK data (or vice versa) — a silent 20% error. 2. Text-formatted numbers: values pasted from the web sometimes arrive as text; the formula returns 0 or #VALUE!. Fix with Paste Special → Values or =VALUE(). 3. Hardcoded factors in every cell: one typo corrupts one row invisibly — use the locked $B$1 factor cell instead. 4. Locale decimals: in many European locales Excel expects semicolons and commas; a US-style formula pasted into a German Excel errors out. 5. Unrounded money math: fuel-cost sheets should wrap results in ROUND(…,2) so fractions of a cent never accumulate. Sidestep all five and the sheet stays trustworthy for years.

Same Conversion in Google Sheets

Everything above works identically in Google Sheets with two bonuses. First, Sheets auto-suggests the fill-down: enter =A2*0.264172 in B2 and Sheets offers to fill the whole column — press Ctrl+Enter (Cmd+Enter on Mac) to accept. Second, Sheets has the same CONVERT function: =CONVERT(A2,"l","gal") works cell-for-cell like Excel. Where Sheets pulls ahead is live data: =GOOGLEFINANCE-style imports do not cover fuel prices, but IMPORTDATA can pull a CSV of tank readings straight into column A, with column B converting as rows arrive. Share the sheet with view-only access and the formulas stay protected while the team sees current gallons. Apple Numbers users: the =A2*0.264172 form works there too; only the CONVERT function is missing, so stick with the hand-typed factor.

Showing Units Next to Results

A bare 13.21 in a cell invites misreading — is that gallons, liters, or dollars? The TEXT function labels results without breaking the math: =TEXT(A2*0.264172,"0.00 ")&" gal" displays “13.21 gal”. Better for downstream math: keep column B as pure numbers and apply a custom number format (Format → Cells → Custom → 0.00 “gal”). The cell shows “13.21 gal” but contains 13.2086, so SUM and AVERAGE still work. For dashboards, combine with conditional formatting: values over tank capacity turn red, values under reorder-point turn amber. The pattern — numbers in the cell, units in the format — is the professional standard for every converted column, not just gallons.

Validating Your Sheet Against the Online Converter

Before a conversion sheet goes into production use, spot-check it. Pick three values — a small one (5 L), a round one (100 L), and one from your real data — and run each through both your spreadsheet and our liters to gallons converter. All three should agree to the decimal places you display; any mismatch means a wrong factor, a text-formatted input, or the US/UK gallon mix-up. For shared workbooks, add a tiny validation block off to the side: a cell with =ABS(B2-13.2086)<0.001 next to a known 50-liter input, formatted to turn red when FALSE. It is a five-second tripwire that catches factor corruption the moment someone “fixes” the formula. Audited once, guarded forever — that is the difference between a scratch calculation and a tool the team can trust.