How to sort suppliers by lead time in a CSV

Supplier rows can be hard to compare when the shortest lead times are buried in a large CSV. Sorting by lead time puts the records in a useful order before you move them into your CRM.

Use the CSV Editor to open, sort, and edit the file in your browser. First make a copy, then check that lead times use one consistent format so the order makes sense.

Sort suppliers by lead time

1. Make a copy of the supplier CSV so you can return to the original if anything goes wrong. Open the copy in the CSV Editor.
2. Find the column that contains lead time. Check the header and a few rows to confirm you have the right field, not a supplier ID, delivery date, or payment term.
3. Sort the records by the lead time column in ascending order to put the shortest times first. Make sure the sort applies to the whole row of supplier data, not just the lead time cells, so names and IDs stay with the correct suppliers.
4. Review the first and last few records. Check that a small number comes before a larger one, and look for blank or unusual entries that may affect the order.
5. When the result is correct, save or export the sorted copy for your CRM migration. Keep the original CSV unchanged until you have checked the import.

The CSV Editor can open files with up to 10 million rows. For a very large supplier list, allow the page time to finish loading before you sort or make another change.

What the sorted result means

The shortest lead times appear first

This is ascending order. A supplier with a lead time of 2 should appear before one with 12, assuming both values use the same unit. This order is useful when you want to see which suppliers can deliver soonest.

The longest lead times appear first

This is descending order. Use it to find suppliers with the longest waits or to spot delivery risks near the top of the list. The same rule applies: values need to use a consistent unit for the comparison to be meaningful.

Numbers appear in an unexpected order

The lead times may be stored as text, or the column may mix formats such as 5 days, 2 weeks, and 12. A text sort can order characters rather than compare the actual durations, so a value beginning with 1 might appear before one beginning with 2 even when that is not the order you expect.

Some suppliers remain grouped together or appear at the end

Blank lead times, identical estimates, or values written as ranges can make the result look uneven. A blank value cannot be compared with a number, and a range such as 3 to 5 days does not have one clear numeric position until you decide which part of the range matters for your process.

Fix common sorting problems

1. Confirm the lead time column. Check the header and compare a known supplier's row before sorting. If the CSV has similar fields such as quoted delivery time and actual delivery time, decide which one the CRM should use.
2. Use one unit for every supplier. Convert values to a shared unit, such as calendar days, before comparing them. If one supplier is listed in weeks and another in days, calculate the equivalent days and update the values in your copy.
3. Decide how to represent ranges. For an entry such as 3 to 5 days, choose a consistent rule, such as the typical estimate or the longest promised time. Keep the original range in a separate notes field if the CRM needs that detail.
4. Check for numbers saved as text. Remove extra words or spaces from the sortable field, then make sure each entry is a number in the same unit. Keep explanatory wording in a separate column rather than mixing it into the number.
5. Check the CSV columns if they look shifted. If supplier names, IDs, or lead times appear under the wrong headers, the file may use a different delimiter than expected. Fix that before sorting, then recheck the headers. See how to fix a CSV delimiter mismatch before a CRM import.
6. Protect supplier IDs and other fields. Confirm that the whole supplier row moved together and that identifiers still match the correct records. Some IDs contain leading zeros, so check them before importing. This guide explains how to preserve leading zeros in a CRM migration.

Choose a useful lead time format

A CRM may need a number to sort or filter suppliers, while a person may need the full promise or caveat. If possible, keep a simple numeric lead-time field in one unit and place notes such as 3 to 5 business days after approval in a separate text field. That way, a CRM can compare the numbers without losing the context.

Also decide whether your values count calendar days or business days. Five business days can span more than a week when a weekend or holiday falls between them. Do not compare one type with the other as though they mean the same thing.

The CSV Editor works in your browser, and files you open stay on your device.