How to Download Data Sets to Excel*

When you view the data sets from a web browser, not all data appear in columns below their labels. After the data are downloaded, the data appear correctly under their variable titles.

1. Open the .txt file for the profession you select
2. From the “File” menu, select “Save As”, and save the file as a txt file to your computer
3. Close or minimize the web document
4. Open a new Excel spreadsheet
5. From the “File” menu, select “Open”
6. Select “All Files” in the “Type of files” window
7. Locate the .txt file on your computer and highlight it
8. Click “Open”
9. Choose “Delimited” from the window that appears
10. Choose “Next”
11. Choose “Tab” from the window that appears
12. Choose “Next”
13. Choose “Finish”
14. The data set will appear in your new Excel spreadsheet
15. Name your document and save it as a .xls document

 *Note: The Registered Nurse data set is too large for one Excel file and must be divided before downloading.