Data & CSV

Round a CSV numeric column

Round decimal values with exact half-away-from-zero ties.

Your inputs

Your CSV data

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Or choose a CSV file

Column separator

Numeric column

Decimal places

Non-numeric non-blank cells

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Rounds decimal text using integer arithmetic, with exact halfway values rounded away from zero (1.005→1.01 and −1.005→−1.01 at two places). Supports bounded decimal exponent notation. Emits fixed decimal places, keeps blank cells and leaves other columns unchanged. This numeric operation removes leading zeros in the selected column.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data

ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09

Column separator

Comma

Numeric column

Amount

Decimal places

Non-numeric non-blank cells

Reject with a row error

Example result

Example result
ID	Name	Department	Amount	Date
001	Ada	Design	120.00	2026-01-05
002	Sam	Writing	80.00	2026-01-06
003	Jo	Design	150.00	2026-01-07
004	Lee	Writing		2026-01-08
005	Alex	Design	60.00	2026-01-09