Data & CSV

CSV identifier padding

Pad textual IDs to a fixed minimum width without losing leading zeros.

CSV identifier padding
Esc to restore

Your inputs

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.

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

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.

Counts Unicode code points and pads on the chosen side using one supplied code point. Values already at least the requested width are retained unchanged. No numeric conversion, trimming or truncation occurs. One code point can occupy several UTF-16 units; visual grapheme width may differ.

See a worked example

Worked example

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

Your CSV
ID,Name,Team,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
Column separator
Comma
Identifier column
ID
Minimum width
6
Padding character
0
Padding side
left

Example result

Example result
IDNameTeamAmountDate
000001AdaDesign1202026-01-05
000002SamWriting802026-01-06
000003JoDesign1502026-01-07

Identifiers stay text. Width counts Unicode code points; longer values are retained without truncation.