For spreadsheet users
Let the sheet
look it up.
You have a column of industry codes. You need readable names. Add a reference sheet once, then let a formula match the labels for you.
Free sample · No key needed · Complete list with a pass
Make the codes readable.
| Sector code | Matched name |
|---|---|
22 | Utilities |
23 | Construction |
31-33 | Manufacturing |
44-45 | Retail Trade |
The combined codes are text. Keep the hyphens.
A reference tab, not another typing job
Build the lookup
in three steps.
The U.S. NAICS 2022 Industry Sectors list pairs sectorCode with sectorName. It covers top-level sectors, not detailed six-digit industries.
Import the reference file.
Import the CSV into a tab named Sectors. Keep
sectorCodeas text. In the current export, column A is ID, B is sectorCode, and C is sectorName; confirm the headers after import.Match the code exactly.
In your working sheet, put a sector code in A2 as text. Use this formula in B2 and fill down:
=XLOOKUP(A2, Sectors!B:B, Sectors!C:C, "Check code", 0)Use Excel or Google Sheets with XLOOKUP support. Your spreadsheet’s regional settings may use semicolons in place of commas.
Resolve unmatched values.
Filter for “Check code.” Look for spaces, missing hyphens, number-versus-text differences, or codes absent from your reference file. The free sample is a subset, so it will not match every valid sector.
When you need the whole list
Take your project
past the sample.
The sample lets you test the formula. A pass gives you the complete sector list for codes beyond the sample.
A Data Pass includes complete files in CSV, JSON, and XML, API access, and category ZIPs across the available catalog.
Data Pass
$39one payment / 365 days
Choose your passYour key arrives by email. No account to create and no automatic renewal.
For your own projects, coursework, teaching, research, and internal work. If you incorporate data into a product or service you provide to others, choose a Commercial Pass. Check the dataset’s scope and sources before buying; passes are non-refundable under our terms.