How to preserve leading zero IDs for a supplier price review

A supplier ID such as 004821 can turn into 4821 when you open a CSV in a spreadsheet. That small change can stop you matching the supplier’s price list to your own product records.

Check the IDs before comparing prices, and keep an untouched copy of the original file. The CSV Editor lets you open a CSV in your browser, find values, and edit rows without first converting the file into a spreadsheet.

Check the supplier IDs before reviewing prices

1. Make a copy of the supplier’s original CSV. Open the copy in the CSV Editor so you can inspect it without changing your source file.
2. Find several IDs that should start with zero, such as 004821. Check a short ID, a longer ID, and one near the top and bottom of the file.
3. Look across each row to confirm the product name and price still match the ID. Do not sort or compare prices until you know the identifiers are intact.
4. If you need to correct a value, edit only the ID field and keep the original number of characters. Review the edited rows against the original copy before saving the reviewed file.
5. Open the saved CSV in the editor again. Check the same sample IDs and confirm that the rows and prices are still paired correctly.

If you are comparing two lists, use the full ID as text. Do not remove leading zeros or treat IDs as numbers: 004821 and 4821 may be different identifiers even though a spreadsheet treats them as the same numeric value.

What the result means

The zeros are still there in the CSV Editor

The file currently contains the identifier as expected. You can continue reviewing it, but take care if you open it in spreadsheet software. A later import or save may convert the ID and remove the zeros.

The IDs are already missing zeros

The file may have been changed before you opened it. Compare it with the original supplier download or ask the supplier for a fresh export. Do not add zeros just because an ID looks short. Only restore them when you know the required ID length from a reliable source.

The CSV Editor shows zeros, but a spreadsheet does not

The spreadsheet likely converted the value to a number when it opened or imported the file. Return to the untouched CSV and import the ID column as text before loading it. Typing zeros back into the spreadsheet may fix what you see, but the change needs to be saved and checked in the CSV too.

Prices no longer match the right products

Stop the review and go back to the original file. A sort, paste, or conversion may have changed the relationship between rows or IDs. Recheck the complete rows, not only the price column, before continuing.

How to fix it

1. Keep the original file unchanged. Work on a separate copy and keep a second copy of the supplier’s source CSV. This gives you a reliable reference if an import or edit changes an ID.
2. Import the CSV instead of opening it directly. When using spreadsheet software, choose its text or CSV import workflow and set the ID column’s data type to Text before loading the rows. The exact menu names vary by spreadsheet version.
3. Check the ID column before changing prices. Compare the imported IDs with the original CSV. If zeros disappeared during import, discard that import and repeat it with the column set to Text.
4. Use the full identifier when matching rows. Compare supplier IDs with your own as text, including every leading zero. Avoid converting IDs to numbers, trimming characters, or removing zeros as a cleanup step.
5. Restore zeros only when the format is known. If the supplier confirms every ID has a fixed length, you can restore missing zeros to that length. If IDs have different valid lengths, get a clean export instead of guessing.
6. Verify the saved CSV. Open the file you plan to use and check several IDs, their product descriptions, and prices. Confirm the row count has not changed unexpectedly.

Why quotes do not always protect an ID

A CSV stores rows and fields as text, but it does not reliably tell every spreadsheet how to treat a value after import. Quotation marks help separate a field that contains commas or other special characters. They do not guarantee that a spreadsheet will keep a value such as "004821" as text. Set the column type during import, then inspect the saved file.

Leading zeros can also be meaningful in supplier IDs, account codes, and catalog numbers. These values identify records; they are not amounts to calculate. Keep them as text even if they contain digits only.

The CSV Editor processes the file in your browser, and files you open stay on your device. Keep your original supplier file until the price review is complete and the edited copy has been verified.