Skip to Content

US Department of Labor

A to Z Index  |  FAQs  |  About BLS  |  Contact Us    

U.S. Bureau of Labor Statistics

Follow Us Follow BLS on Twitter | What's New | Release Calendar | Blog
  • Home
    • Subject Areas»
    • Inflation & Prices
    • Spending & Time Use
    • Unemployment
    • Employment
    • Pay & Benefits
    • Productivity
    • Workplace Injuries
    • International
    • Demographics
    • Industries
    • Business Costs
    • Occupations
    • Geography
    • Resources For »
    • Business Leaders
    • Consumers
    • Developers
    • Economists
    • Investors
    • Jobseekers
    • Media
    • Public Policymakers
    • Students & Teachers
    • Survey Respondents
    •  
    • At a Glance Tables »
    • U.S. Economy
    • Regions, States, & Areas
    • Industries
    • MORE »
    • Videos
    • Announcements
    • BLS Speakers Available
    • Commissioner's Corner
    • Research
    • Spotlight on Statistics
    • Students' Pages
    • Errata
    • Other Statistical Sites
  • Subjects
    • Inflation & Prices »
    • Consumer Price Index
    • Producer Price Indexes
    • Import/Export Price Indexes
    • Employment Cost Index
    • Contract Escalation
    • Price Index Research
    • Inflation & Prices Overview
    •  
    • Pay & Benefits »
    • Employment Costs
    • National Compensation Data
    • Wages by Area & Occupation
    • Earnings by Demographics
    • Earnings by Industry
    • County Wages
    • Benefits
    • Compensation Research
    • Strikes & Lockouts
    • Pay & Benefits Overview
    •  
    • Spending & Time Use »
    • Consumer Expenditures
    • How Americans Spend Time
    • Unemployment »
    • National Unemployment Rate
    • State & Local Unemployment Rates
    • Unemployment Research
    • Unemployment Overview
    •  
    • Employment »
    • National Employment
    • State & Local Employment
    • State & County Employment
    • Worker Characteristics
    • Employment Projections
    • Job Openings & Labor Turnover
    • Employment by Occupation
    • Work Experience Over Time
    • Business Employment Dynamics
    • Employment Research
    • Employment Overview
    •  
    • Workplace Injuries »
    •  
    • Occupational Requirements »
    • Productivity »
    • Labor Productivity & Costs
    • Multifactor Productivity
    • Productivity Research
    • Productivity Overview
    •  
    • International »
    • International Technical Cooperation
    • Import/Export Price Indexes
    • International Overview
    •  
    • REGIONAL OFFICES »
    • New England (Boston)
    • New York-New Jersey (NY City)
    • Mid-Atlantic (Philadelphia)
    • Southeast (Atlanta)
    • Midwest (Chicago)
    • Southwest (Dallas)
    • Mountain-Plains (Kansas City)
    • West (San Francisco)
    • Regional Overview
  • Data Tools
    • Data Retrieval Tools »
    • Top Picks
    • Series Report
    • One Screen
    • Multi-Screen
    • Maps
    • Calculators
    • Public Data API
    •  
    • CUSTOMIZED TABLES »
    • Text Files
    • News Release Tables
    •  
    • More Sources of Data »
    • Restricted Data Access
    • Discontinued Databases
    • FAQs
    • Special Notices
    • More Sources of Data
  • Publications
    • Latest Publications »
    • The Economics Daily
    • Monthly Labor Review
    • Beyond the Numbers
    • Spotlight on Statistics
    • Reports & Bulletins
    • Commissioner's Corner
    •  
    • Videos
    • Career Outlook
    • Occupational Outlook Handbook
    • Handbook of Methods
    • Research Papers
    • Copyright Information
    • Contact & Help
  • Economic Releases
    • Latest Releases »
    •  
    • Major Economic Indicators »
    •  
    • Schedules for news Releases »
    • By Month
    • By News Release
    • Current Year
    • Prior Years
    •  
    • Archived News Releases »
    • Employment & Unemployment »
    • Monthly
    • Quarterly, annual, and other
    •  
    • Inflation & Prices »
    •  
    • Pay & Benefits & Workplace Injuries »
    •  
    • Productivity & Technology »
    •  
    • Employment Projections »
    •  
    • International Programs »
    •  
    • Regional News Releases »
  • Students
    • Games & Quizzes
    • Student Resources
    • Teacher´s Desk
    • History of BLS
    • FAQs
  • Beta
    • Data Finder »
    • State and County Map »
Help & Tutorials
SHARE ON: share on facebook share on twitter share on linkedin
PRINT: Print
  • Help & Tutorials Homepage
  • How to save the OOH Compilation file from XML to Excel
  • Frequently Asked Questions (FAQs)
  • Top Picks (Most Requested Series)
  • Series ID Formats
  • Formatting Options
  • Enable JavaScript
  • Disable Pop-up Blocker
  • BLS Email Subscription Service FAQs
  • Excel Output format for BLS website data retrieval tools

Help & Tutorials Homepage

How to save the OOH Compilation file from XML to Excel

RSS Subscription

Subscribe to iCAl calendar

Frequently Asked Questions about BLS website data retrieval tools

  • How to copy BLS data tables to an Excel worksheet?
  • How to print data on one page?
  • How to save output to a disk?
  • How to retrieve data for a single period/month?
  • How to retrieve data for a single period/year?
  • How to retrieve the annual average for one year?
  • How to have net change calculated?
  • How to have percent change calculated?

Top Picks (Most Requested Series)

One Screen Data Search

Series ID Formats

Formatting Options for Series Report and Multi Screen Data Search

Unsubscribe from BLS Email Subscription Service

Excel Output format for BLS website data retrieval tools

 

Last Modified Date: December 17, 2015

Recommend this page using:
share on facebookFacebook
share on twitterTwitter
share on linkedinLinkedIn
  • tools

  • Areas at a Glance
  • Industries at a Glance
  • Economic Releases
  • Databases & Tables
  • Maps
  • calculators

  • Inflation
  • Injury And Illness
  • help

  • Help & Tutorials
  • FAQs
  • Glossary
  • About BLS
  • Contact Us
  • info

  • What's New
  • Careers @ BLS
  • Find It! DOL
  • Join our Mailing Lists
  • Linking & Copyright Info
  • resources

  • Inspector General (OIG)
  • Budget and Performance
  • No Fear Act
  • USA.gov
  • Benefits.gov
  • Disability.gov

Freedom of Information Act  |  Privacy & Security Statement  |  Disclaimers  |  Customer Survey  |  Important Web Site Notices

U.S. Bureau of Labor Statistics | Postal Square Building, 2 Massachusetts Avenue, NE Washington, DC 20212-0001

www.bls.gov | Telephone: 1-202-691-5200 | TDD: 1-800-877-8339 | Contact Us