Precheck a Supplier CSV Before Excel Changes It
Supplier CSVs often include product lists, SKUs, IDs, prices, ZIP codes, option fields, and descriptions. Before opening directly in Excel, check common issues that may change how the file appears.
Quick checklist
- Check weird characters in product names or descriptions
- Review SKUs and product codes with leading zeros
- Look for long numeric IDs or tracking numbers
- Check whether everything opens in one column
- Review uneven rows and repeated headers
- Download review rows before editing
You do not need to know what is wrong first
The file may have an encoding issue, delimiter issue, uneven row issue, or values Excel may auto-format. Argon checks common patterns locally and explains what it flagged.
Start with the Precheck Report, then inspect review rows before editing or importing the file.
Product codes and IDs need extra care
Excel may remove leading zeros, round long numeric IDs, or display product codes like 4E75 as scientific notation. If you save over the file after Excel changes values, the changed text may remain in the CSV.
Keep the original supplier file and review flagged values before making changes.
Inspect the CSV locally before editing
Upload the supplier CSV locally, generate a Precheck Report, and inspect rows Argon flagged.
Inspect the CSV locally before editingArgon flags common file-format and structure issues for review. It does not guarantee platform import success.