Follow

Exporting Data into Excel

There are two ways you can get data into Microsoft Excel. 

1. Get Individual Reports 

The first is to cut and paste any report's data into Microsoft Excel following these instructions:

In Internet Explorer/Chrome/Safari:

  • Open the desired report in the Report Center.
  • Click on the printer icon to the right of the report title.
  • Position the cursor right above the table containing the desired data.
  • Left click and keep pressing while highlighting all of the data. 
  • Press Ctrl -C/Command-C (copy on a pc).
  • Open Microsoft Excel and click on the first cell.
  • Press Ctrl-V/Command-V (paste on a pc).
  • You should now have the data.
  • You may need to delete some rows from the top and bottom that do not contain meaningful data.


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 to start above the table before left clicking and scroll to below the table before hitting Ctrl-C/Command-C.

 

2. 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. The file that will be downloaded is a text file that is delimited with semicolons. The download page has directions on what to do with this file.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request