Hot Links


Historical Data Series for QCEW

County and MSA data ARE also available from the BLS at: ftp://ftp.bls.gov/pub/special.requests/cew/

The files have unusual extensions and are not formatted. The data file types are "EWB", "ENB", "ENC" and "END." Conversion tools have been provided by the BLS to convert the files to Excel, Access, or SAS files. Directions for converting the files to excel have been provided below. Directions for converting the files to Access and SAS are included in the zip files makeaccess.zip and makesas.zip. (One step that they don't mention: You will need to download the data files for the time frame and geography you want to work with to your hard drive before using the tool.)

  1. Click on Documents.
  2. Click on makexls.zip. (SAS and Access formats are also available.)
  3. Unzip the makexls.xls and save it to your hard drive.
  4. Read the "readme.txt" file for directions or follow the directions below.

Instructions on how to open EWB and ENB files into Microsoft Excel

  1. Unzip the excel file (makexls.xls) and open in Microsoft Excel
  2. Select Tools from the menu bar at top.
  3. Select Macro from menu, then select Macros
  4. Select MAKEXLS and then hit the "Run" button
  5. The macro will ask you click "OK" a couple of times
  6. Then it will allow you to select the EWB or ENB file you want to open. (note: you need to download the data files for the time frame and geography you want to work with to your hard drive first.)
  7. Another "OK" will appear-click it.

This will import the EWB or ENB data into excel. Be warned, though, that Excel can only open 65,536 lines. Files longer than this should be opened using our MS Access database tool, or your favorite database.

Instructions on how to open ENC files into Microsoft Excel

  1. Unzip the excel file (makexls.xls) and open in Microsoft Excel
  2. Select Tools from the menu bar at top.
  3. Select Macro from menu, then select Macros
  4. Select MakeENCXLS and then hit the "Run" button
  5. The macro will ask you click "OK" a couple of times
  6. Then it will allow you to select the EWB or ENB file you want to open. (note: you need to download the data files for the time frame and geography you want to work with to your hard drive first.)
  7. Another "OK" will appear-click it.

This will import the ENC data into excel. Be warned, though, that Excel can only open 65,536 lines. Files longer than this should be opened using our MS Access database tool, or your favorite database.

Instructions on how to open END files into Microsoft Excel

  1. Unzip the excel file (makexls.xls) and open in Microsoft Excel
  2. Select Tools from the menu bar at top.
  3. Select Macro from menu, then select Macros
  4. Select MakeENDXLS and then hit the "Run" button
  5. The macro will ask you click "OK" a couple of times
  6. Then it will allow you to select the END file you want to open. (note: you need to download the data files for the time frame and geography you want to work with to your hard drive first.)
  7. Another "OK" will appear-click it.

This will import the END data into excel. Be warned, though, that Excel can only open 65,536 lines. Files longer than this should be opened using our MS Access database tool, or your favorite database.

Top

HOME--> Labor Market Information--> Employment Statistics