Rocket Source

CSV File Formatting

Unfortunately, Excel makes it quite challenging to deal with UPC codes. It will automatically try to truncate the UPC code into scientific notation (something that looks like 8.0483E+11 instead of 804831000181).
This truncation can cause irreversible data loss when converting to a CSV file.
Thankfully, preventing this is a painless process!
  1. Open the XLSX file in Microsoft Excel.
  2. Right-click on the column that contains the UPC codes.
  3. From the menu, select 'Format Cells'.
  4. In the Format Cells dialog box, go to the 'Category' section.
  5. Choose 'Custom'.
  6. In the 'Type' field, enter '000000000000' (12 zeros).
  7. Click the 'OK' button.
  8. Go to File > Save As.
  9. In the Save As dialog box, select 'CSV (Comma delimited)' from the dropdown list of file formats.
  10. Give the file a name and choose a location to save it.
  11. Click the 'Save' button.
© 2024 Rocket Source LLC
Pages
PricingAPI DocumentationUPC to ASIN ConversionASIN to EAN ConversionKnowledge BaseFBA Prep Service DatabasePharmapacks Case StudyBlog
Features
Data PointsData ExportInline EditListing MatchMultipack CorrectionsBrand BlocklistFlagsColumn JumpCalculation ExplanationsDark ModeDetail ViewFBA Fee CalculatorProduct Lists