Prevent Excel from destroying leading zeros by applying custom data formatting. Highlight your column. Right-click and select Format Cells . Choose Custom from the Category list. Type 000000 into the Type field and click OK. Step 2: Convert the Dataset to an Excel Table
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. IMPA Code Search by ShipServ
The IMPA coding system uses a hierarchical six-digit structure to ensure clarity across language barriers in the global shipping industry:
A technical superintendent needs a "seal kit for hydraulic pump." Using a poor list, they order IMPA 472345, which arrives as the wrong metric size. Vessel downtime: 1 day ($50k loss). Rush shipping: $2k. Total waste: $52k.
Insert a column Category and use: =VALUE(LEFT([@Code],2)) Then map: 31→Welding, 32→Paints, 33→Deck Stores, etc. impa code list excel extra quality
Create a column named and use the LEFT formula to grab the first two digits: =LEFT(A2, 2)
Exporting clean, standardized Excel data directly into Request for Quote (RFQ) templates reduces communication friction. Ship chandlers receive clearly defined items, resulting in faster turnarounds and highly accurate pricing. Global Inventory Synchronization
Highlight in red any row where:
An is the backbone of efficient marine procurement. By moving beyond a paper book and utilizing a structured, searchable spreadsheet, you reduce errors, save time, and ensure your vessel is always equipped with the right gear at the right price. Prevent Excel from destroying leading zeros by applying
: Distributed in Excel/CSV format , these licenses are designed for ship owners, managers, and suppliers to import data directly into procurement software like ShipServ or ProcureShip .
Before building or optimizing your Excel database, you must understand the DNA of an IMPA code. The Marine Stores Guide utilizes a structured 6-digit numbering system divided into three distinct pairs:
Each item is assigned a unique, six-digit code structured to keep procurement organized:
The XLOOKUP function allows buyers to type a six-digit code into a search bar and instantly pull the exact item description, unit of measure, and pricing tier without manual filtering. 3. Apply Data Validation to Prevent Ordering Errors Choose Custom from the Category list
Represents the general product category (e.g., 3 for Deck Equipment).
An "extra quality" Excel database is more than just a list of numbers. It is a powerful tool for:
However, the raw PDF or printed guide, while authoritative, is notoriously difficult to work with in daily operations. This is why the industry has shifted toward using an .
To achieve "extra quality" in your supply chain, you need an . This allows for automation, bulk searching, and seamless integration into ERP systems like Amos or Danaos. What is the IMPA Code?