Bookmark

Login

How do I get data into Microsoft Excel? PDF Print E-mail

There are two things you can do to get data into Microsoft Excel. 

Get Indiviudal Reports -

The first is to cut and paste any report's data into Mircrosoft Excel.  Here are some instructions for that.

In Internet Explorer:

  1. Open the desired report in the Report Center.
  2. Click on the printer icon to the right of the report title.
  3. Position the cursor right above the table containing the desired data.
  4. Left click and keep pressed while highlighting all of the data. See the example below.
  5. Hit Ctrl -C (copy on a pc).
  6. Open MS excel and click on the first cell.
  7. Hit Ctrl-V (paste on a pc).
  8. You should now have the data.
  9. You need to delete some rows from the top and bottom that do not contain meaningful data.
    Image
    Selection Screen Shot

In Firefox:

You will follow the same steps above.  The difference is that it may not be obvious that the data is being highlighted.  Be sure start above the table before left clicking and scroll to below the table before hitting Ctrl-C.

Download the Entire Database -

The second way to get data into Microsoft Excel is to download the entire database.  This can be done in the AP  Report Center (you must be logged in).  The file that will be downloaded is a text file that is delmited with semicolons.  The download page has directions on what to do with this file.

 

 

* AP and Advanced Placement Program are registered trademarks of the College Board, which was not involved in the production of, and does not endorse, this service.