NCCS Data Web Sample Search 4

Use the Extract tool, instead of the Table tool, to run your search in order to download the results to Excel or other analysis software.

Enter the NCCS Data Web. Click to accept the User Agreement.
Choose your subset database, for this example, the Core Data - Core 2005 PC subset.
The next screen allows you to select the variables that you want included in your results--essentially, this is the same as the Table tool feature that allows you to Show or Hide the different variables.
On the same screen at the very bottom is the familiar form that allows you to construct your search based on certain values for a given variable. You can either type your search into the text box using mSQL format or use the Add a Filter Condition... button to formulate the search string (see step 4 of Sample Search 3 for more detail). For this example, enter C27 as the NTEECC code to find organizations concerned with recycling.
In the next section of the form under the heading Formatting Options, you may select from a variety of software format options from the ubiquitous ASCII text to Excel, SPSS, SAS or others. If you are exporting to Excel, you may want to keep it in ASCII text but change the delimiter from comma to tab.
Click on the Extract button at the bottom of the screen.
The resulting screen will provide a large bold hyperlink at the top of the screen to the zipped (compressed) results file. When you click on it, you have the option to open or save a file with a .gz extension: always choose Save. The results screen will also tell you the number of records included and the variable fields you requested. I got 149 records for this search.
Open a decompression software like WinZip and decompress the file you saved. You will get a file with the same name with a .txt extension.
You can now open this file in Excel. (When you tell Excel to open it, you may need to change the file type from All Excel Files to All Files to be able to see the .txt file.)

If you need to use the Digitized Data, you will have to request permission from the NCCS before you will be able to use the Extract tool. However, NCCS processes requests to use the Digitized Data very quickly--it's worth it!

Return to the sample search page
Return to the main NCCS resource page