Skip to page navigation
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites. / Policy / Pay & Leave / Salaries & Wages
Skip to main content

Information about Spreadsheet Format

Information about Spreadsheet Format

The Excel spreadsheet contains General Schedule rates of pay for 2024, and

  • Column A in the spreadsheet contains the codes for the locality pay area,
  • Column B contains grades,
  • Column C contains the annual rates for step 1,
  • Column D contains the hourly rates for step 1,
  • Column E contains the hourly overtime rates for step 1, and
  • Subsequent columns contain similar information for steps 2 through 10.

Locality codes used in the file are as shown in the table below:

Locality Pay Area Locality Code
Albany-Schenectady, NY-MA AL
Albuquerque-Santa Fe-Las Vegas, NM AQ
Atlanta-Athens-Clarke County-Sandy Springs, GA-AL ATL

Austin-Round Rock-Georgetown, TX

Birmingham-Hoover-Talladega, AL BH

Boston-Worcester-Providence, MA-RI-NH-CT-ME-VT


Buffalo-Cheektowaga-Olean, NY


Burlington-South Burlington-Barre, VT

Charlotte-Concord, NC-SC CT
Chicago-Naperville, IL-IN-WI CHI
Cincinnati-Wilmington-Maysville, OH-KY-IN CIN

Cleveland-Akron-Canton, OH-PA

Colorado Springs, CO CS
Columbus-Marion-Zanesville, OH COL
Corpus Christi-Kingsville-Alice, TX CC
Dallas-Fort Worth, TX-OK DFW
Davenport-Moline, IA-IL DV

Dayton-Springfield-Kettering, OH

Denver-Aurora, CO DEN
Des Moines-Ames-West Des Moines, IA DM
Detroit-Warren-Ann Arbor, MI DET

Fresno-Madera-Hanford, CA

Harrisburg-Lebanon, PA HB

Hartford-East Hartford, CT-MA

Houston-The Woodlands, TX HOU

Huntsville-Decatur, AL-TN

Indianapolis-Carmel-Muncie, IN IND
Kansas City-Overland Park-Kansas City, MO-KS KC
Laredo, TX LR
Las Vegas-Henderson, NV-AZ LV
Los Angeles-Long Beach, CA LA

Miami-Port St. Lucie-Fort Lauderdale, FL

Milwaukee-Racine-Waukesha, WI MIL
Minneapolis-St. Paul, MN-WI MSP
New York-Newark, NY-NJ-CT-PA NY
Omaha-Council Bluffs-Fremont, NE-IA OM
Palm Bay-Melbourne-Titusville, FL PB
Philadelphia-Reading-Camden, PA-NJ-DE-MD PHL

Phoenix-Mesa, AZ

Pittsburgh-New Castle-Weirton, PA-OH-WV PIT
Portland-Vancouver-Salem, OR-WA POR

Raleigh-Durham-Cary, NC


Reno-Fernley, NV

Richmond, VA RCH

Rochester-Batavia-Seneca Falls, NY

Sacramento-Roseville, CA-NV SAC
San Antonio-New Braunfels-Pearsall, TX SO

San Diego-Chula Vista-Carlsbad, CA

San Jose-San Francisco-Oakland, CA SF
Seattle-Tacoma, WA SEA

Spokane-Spokane Valley-Coeur d'Alene, WA-ID

St. Louis-St. Charles-Farmington, MO-IL SL
Tucson-Nogales, AZ TU
Virginia Beach-Norfolk, VA-NC VB
Washington-Baltimore-Arlington, DC-MD-VA-WV-PA DCB
Rest of U.S. RUS
State of Alaska AK
State of Hawaii HI

Please email us at if you have questions about the spreadsheet.

Control Panel