How to Build a Working Struts Cross Reference Chart
Most people trying to build or use a Struts Cross Reference Chart Manufacturers Model start by copying someone else's spreadsheet. That works until it doesn't. The moment you deal with a partial fitment mismatch or a region-specific part number, the copied chart becomes noise. Here is how to actually get this right. A cross-reference chart in the suspension parts space maps OEM part numbers to aftermarket equivalents and vice versa. Manufacturers like Monroe, KYB, Koni, Bilstein, and Sokyma each use their own numbering systems. The chart's job is to tell you which aftermarket strut assembly replaces which factory unit for a given vehicle. The model itself is really just a structured data schema. At minimum you need: OEM make, OEM model, OEM year, OEM part number, aftermarket brand, aftermarket part number, compatibility notes, and fitment confidence level. That last field is where most charts fail. It should never be left blank.
Where the Data Comes From
You pull OEM numbers from parts catalogs, manufacturer service bulletins, or databases like TecDoc. Aftermarket mappings come from manufacturer fitment guides, which are usually published as PDF lookups or downloadable CSVs. Some suppliers like Monroe and KYB provide official cross-reference tools on their websites. Those are the most reliable single source you will find. The problem is that none of those sources agree on everything. Monroe might list a KYB part as a direct replacement while KYB's own chart shows a slightly different assembly with a reinforced spring. Both can be technically correct depending on whether you are talking about the shock body only or the complete strut assembly with spring and mount.
Building the Chart Step by Step
Start with one manufacturer's official fitment data. Pick a brand that publishes clean, structured numbers. Monroe and KYB are the easiest starting points. Download their complete part lists and strip them down to the columns you need. Do not import the entire PDF. That turns a 20-minute job into a two-hour data entry nightmare. Once you have a clean baseline, layer in additional manufacturers. Match by OEM chassis code and suspension code where available. Year and model alone will get you into trouble with mid-cycle refreshes and regional variations. A 2015 Ford Focus ST in North America does not use the same front strut as a 2015 Focus ST in Europe. I learned this the hard way when a customer ordered a Kon i replacement based purely on year and model. The strut body fit. The spring perch did not. The whole assembly sat in a bin for six months before I figured out the European spring had a different outer diameter at the upper seat. After you have mapped the parts, add a compatibility confidence rating. Use three levels: confirmed fit, likely fit with notes, and unverified. Confirmed means two independent sources agree. Likely means one source says yes and another does not contradict it. Unverified means you have a single data point and nobody has physically installed it yet. Be honest about this. Putting unverified mappings in without a label will cost you returns and warranty claims.
Get the Full Details
Common Pitfalls That Break These Charts
The biggest mistake is treating all struts as interchangeable within the same vehicle platform. Suspension codes matter. General Motors, Ford, and BMW all run multiple suspension packages on the same model year. A magnetic ride system uses a completely different strut than the standard coil spring setup. If your chart does not account for suspension code, it will give you wrong matches roughly 30 to 40 percent of the time on modern American and European vehicles. Another trap is ignoring revision dates. Aftermarket manufacturers update their part numbers constantly. KYB will release a revised item number when they change a valving spec or switch to a different seal design. If you are pulling from a catalog that was published two years ago, you will map old numbers to new ones and miss the update entirely. Always check the revision date on any source data before trusting it. Region matters too. Japan domestic market cars often have different spring rates and strut designs than the export versions. A chart built from US-only data will look correct until someone tries to fit a US-mapped part to a JDM chassis. I have seen entire forums argue about whether a particular Tein or Whiteline strut would fit a US-spec Honda Civic because nobody checked the JDM part numbers first.
Validation and Maintenance
No chart is ever finished. You need a feedback loop. When a part gets returned for fitment issues, log it. Check whether the mapping was unverified, whether a suspension code was missed, or whether the source data was outdated. Fix the entry and note what went wrong. This process usually catches 80 percent of errors within the first 90 days of rolling out a new chart. If you are building this for commercial use, consider supplementing the spreadsheet with a basic API or searchable database. Spreadsheets work fine for a few thousand lines. Once you hit five or six thousand mappings with notes and confidence levels, anything past Excel will save you actual time. Google Sheets or Airtable both handle that volume without breaking. The other reality is that cross-reference charts will never be 100 percent accurate. There will always be edge cases where a manufacturer changed a mounting point by two millimeters between the 2018 and 2019 model year and nobody updated the catalog. Your chart should reflect that uncertainty rather than pretend it does not exist. A honest chart with confidence ratings beats a perfectly formatted chart that gives you wrong answers with total confidence.
Where to Find Source Data
Monroe provides a free online cross-reference lookup at monroparts.com. KYB has a similar tool on kyb.com. For European applications, sokyma.com and koni.com both publish downloadable fitment lists. If you are building a comprehensive chart, start with those and fill gaps with aftermarket catalogs like Meyle, Lemforder, and TRW. Avoid scraping parts from eBay or Amazon listings. Those are often inconsistent and frequently wrong. The whole process usually takes about four to six hours for a basic chart covering one vehicle brand with two aftermarket suppliers. A full multi-brand, multi-region chart can take weeks. Budget accordingly.
