Numbers
Zero-Padded Number List Generator
Used by developers, writers, and creators worldwide.
A zero-padded number list generator solves one of the most persistent formatting problems in business and data work: keeping IDs aligned, sortable, and consistent. Invoice numbers, ticket codes, SKUs, employee IDs — they all break when string sorting treats '10' as less than '2'. This tool fixes that by letting you set a pad length, prefix, suffix, start value, and count, then outputs a clean list you can paste straight into a spreadsheet, database, or code file. Sequential mode works for ordered records like INV-0001 through INV-0500. Switch to random mode when you need non-predictable codes — coupon batches or anonymized QA fixtures — that still match a fixed format. Combine a prefix like HR- with a suffix like -2025 to embed context directly into identifiers such as HR-0042-2025.
Loading usage…
Free forever — no account required
How to use
- Choose your options above
- Click Generate
- Copy your result
Detailed instructions
- Choose Sequential to count up from a start value, or Random to generate non-ordered padded numbers.
- Set the Start value and How many count to define the range of your sequential list.
- Enter the Pad to digits value — use 4 for codes up to 9999, or 5-6 for larger datasets.
- Type your desired prefix (e.g. INV-, ORD-, HR-) and an optional suffix (e.g. -2025) in the text fields.
- Click Generate, then copy the full list and paste it into your spreadsheet, database, or document.
Use Cases
- •Generating 500 sequential invoice numbers like INV-0001 to INV-0500 for an accounting system
- •Creating padded employee IDs with a department prefix like HR-0001 for import into an HRIS
- •Producing random coupon codes in a fixed-width format for a Shopify or WooCommerce promotion
- •Seeding a Postgres staging table with 200 consistent order IDs for Cypress end-to-end tests
- •Building product SKUs with a category prefix and padded serial number for a Shopify catalog
Tips
- →For invoice continuity, set Start to one more than your last issued number rather than always starting at 1.
- →Pad to at least one digit more than your expected maximum count — switching formats mid-series breaks sorting.
- →In random mode, the maximum number generated is capped by your pad length, so a 3-digit pad limits values to 999.
- →Combine a short department prefix with a 4-digit pad for IDs that are both human-readable and machine-sortable.
- →If pasting into Excel, format the destination column as Text first to prevent the app from stripping leading zeros.
- →For QA test data, use random mode with a neutral prefix like TEST- so records are obviously non-production at a glance.
FAQ
why do my numbers sort wrong without zero padding
String sorting compares characters left to right, so '10' sorts before '2' and '100' before '9'. Zero-padded numbers like 002 and 010 are all the same length, so alphabetical and numeric order match perfectly. This matters any time IDs are stored as text in spreadsheets, file systems, or databases.
how do I generate invoice numbers starting from a specific number
Set Mode to Sequential, enter your starting value in the Start field (e.g. 174 to continue from INV-0173), set Pad to digits to 4, add INV- as the prefix, and choose how many you need. The output is a ready-to-paste list with no gaps or duplicate entries.
what's the difference between sequential and random mode for padded numbers
Sequential mode outputs consecutive numbers from your start value — ideal for invoices, tickets, or any ordered record where gaps would be noticed. Random mode generates non-sequential values within the padded digit range, which suits coupon codes or anonymized test fixtures where predictable ordering is a problem.