Pad Column in Excel Files Online
Left-pad or right-pad a column in Excel files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.
How to pad Column in Excel files
- Drop your file onto the upload area. The first column is selected by default, and the first 200 rows are shown.
- Pick the column to pad and the pad side: Left pad (lpad, for 007) or Right pad (rpad, for 700).
- Set the total width in characters (1 to 200, default 10) and the pad character (one character, default 0). A live hint shows what "42" would become.
- Choose "Replace column in place", or "Append as new column" with a name (default: the column name plus _padded).
- Click Pad Column, check the preview, and download the file in the same format you uploaded.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A retail store list was opened and saved in a spreadsheet, which turned US ZIP codes into numbers and dropped their leading zeros. The ZIPs must be five characters again before the file is matched against a postal database.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| store_id | city | zip |
|---|---|---|
| S-014 | Boston | 2134 |
| S-022 | Jersey City | 7302 |
| S-031 | San Francisco | 94107 |
| S-047 | Holtsville | 501 |
Settings
- Column to pad: zip
- Pad side: Left pad
- Total width: 5
- Pad character: 0
- Output mode: Replace column in place
Result
| store_id | city | zip |
|---|---|---|
| S-014 | Boston | 02134 |
| S-022 | Jersey City | 07302 |
| S-031 | San Francisco | 94107 |
| S-047 | Holtsville | 00501 |
Each ZIP is converted to text and zeros are added on the left until it is five characters long. 94107 is already five characters and is unchanged. The zip column is now text, not a number, which is what keeps the zeros. A value longer than five characters, such as a ZIP+4 written as 021341234, would be cut to its first five characters.
Working with Excel files
The tool reads the text each cell displays on the first sheet. If the ZIP column already uses a custom 00000 number format, the zeros are visible and come through without padding. When they are shown as plain numbers, pad them here. Currency or thousands formatting is read as displayed, so a cell showing 1,250 is padded as the five characters "1,250", comma included. Real date cells are the exception. They load as dates, so a cell showing 3/2/26 is padded as the text 2026-03-02. Set currency and thousands columns to a plain General format before uploading if you want the raw values padded.
The padded values are written back to the .xlsx as text cells, so Excel keeps 00501 as typed. You will usually see a small green triangle warning that a number is stored as text, which you can ignore. Do not use Excel's Convert to Number on that column, or the zeros will be lost again. Formula cells are padded based on their calculated result, and the formula itself is not kept in the output.
Frequently Asked Questions
Will Excel keep the leading zeros after padding?
Yes. The values are saved as text cells, which Excel does not convert. Ignore the "number stored as text" warning.
Why does a padded Excel value include a comma?
The cell had thousands formatting, and the tool reads the displayed text. Remove the number format in Excel, or use Find & Replace to strip commas, before padding.
What happens to values longer than the target width?
They are cut to the width. With a width of 5, "123456" becomes "12345" whether you pad left or right. Check the longest value in the column before choosing the width.
Can I pad with more than one character, such as "ab"?
No. The pad character box accepts a single character. An empty box falls back to 0.
Is the padded column still a number?
No. Padding converts the value to text first, so the result is always a text column. That is what lets it keep leading zeros.
Related Tools
Combine Columns in Excel Files Online
Combine multiple columns into one in Excel files directly in your browser. Merge first name and last name, join address fields, or concatenate any columns with a custom separator — no upload required.
Validate Excel Files Online
Validate Excel file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.
Merge Excel Files Online
Merge and concatenate multiple Excel files into one, directly in your browser.
Pad Column in CSV Files Online
Left-pad or right-pad a column in CSV files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.
Pad Column in Parquet Files Online
Left-pad or right-pad a column in Parquet files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.
Pad Column in JSON Files Online
Left-pad or right-pad a column in JSON files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.