Extract the .gz file, then use the CSV import dialog.
Trucking Lists editorialOctober 7, 20262 min read
Excel and Google Sheets
Extract the .gz file, then use the CSV import dialog. Set USDOT, MC, postal code and phone columns to text. Large nationwide files can exceed spreadsheet row limits; use a state pack, a database or a CSV tool for the full file.