How to Use AggData with Microsoft Excel 2003

Once you have downloaded or received your AggData, opening it in Excel is a straightforward process.  If you already have Excel installed, then the first step is to find the location of the AggData file on your computer. 

Usually, unless you have specified a different location, it will be in your Downloads folder (as shown above).  Find the AggData document you would like to access, and double click on the desired file.  It will automatically open in Excel.

In order to make the spreadsheet easy to read, double click the right edge of each column to open the column to its full width.  This way you are able to see all the contents of each column (you can also highlight multiple columns and double-click the edge to resize them all at once).


Adding AggData to Another Document in Microsoft Excel

Sometimes you may have an existing document to which you would like to add AggData. When this is the case, open the desired document in Excel first, then follow these steps to add the AggData document.

First click on the “Data” tab at the top of the Excel sheet.  Once the “Data” tab is open, double click your cursor on the box where you want the AggData to begin.  Then find the “From Text” button and click it.  

An “Import Text File” box will open.  Find Downloads, or the folder you keep your AggData in, and open it.  Select the document you would like to open by double clicking it.

The “Text Import Wizard” will open with Step 1 of 3.  Make sure the Step says the file is delimited.  Then simply click “Next”.

In Step 2 make sure to click on “Comma”, which will put the AggData into the Excel columns correctly.  Then click “Next”.

Step 3 - you can change the format of any columns as you import them, but usually you would just click “Finish”.

The “Import Data” box will come up marked for the existing worksheet you already have open.  Simply click “OK”.

Now you have successfully opened and placed the AggData into your existing file.