Public sample Data files

Zip Code to County Spreadsheet

This spreadsheet contains a comprehensive list of 54,559 U.S. ZIP codes, with detailed columns for ZIP code, state, city, county, FIPS and ZIP-level stats. Whether you're enriching a customer dataset, performing geographic segmentation, or running a simple ZIP code lookup, this file provides everything you need in a structured format. This county level data includes:

  • Standard ZIPs (used for regular delivery)
  • PO Box ZIPs (only for PO boxes)
  • Unique ZIPs (assigned to a single organization, university, or business)
  • Military ZIPs (APO/FPO/DPO)
  • Non-contiguous and territory ZIPs (e.g., Guam, Puerto Rico, American Samoa)
  • Use this ZIP to state lookup table for mapping ZIP codes to states and cities and enhancing market data with location context.

    View in Gigasheet

    Unlock Market Intelligence from Big Data with Gigasheet

    Price Transparency Data: Healthcare organizations are turning massive machine-readable price transparency data into competitive advantage with Gigasheet. Our platform helps providers and payers easily analyze newly published pricing files – no coding required. With Gigasheet’s no-code big data platform for healthcare, users can transform Transparency in Coverage (MRFs) files into interactive reports and compare negotiated rates across payers and providers to spot opportunities. Learn how our healthcare price transparency tools drive smarter contracts and cost savings by exploring Gigasheet’s price transparency data solution for actionable analytics.

    More Sample Data Files

    Previous Spreadsheet

    No previous post!
    Back to all sample data

    Next Spreadsheet

    No next post!
    Back to all sample data

    100,000+ people use Gigasheet.

    Self-service analytics for huge files, databases, warehouses and more.
    No Code
    No Training
    No Install
    Request a Demo

    By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.