Export Data

Reports displays the reports available for viewing, printing, and/or exporting by category. All reports and receipts provide details on instructional materials tracked by the district (campus owned materials are not included).  You can refine reports and receipts by Filtering and Sorting the data in multiple ways within TIPWeb-IM.

Most reports allow TIPWeb-IM filtering/sorting.  However, not all do.  For these reports, data can be exported to be viewed, saved, and/or printed in a spreadsheet application (such as MS Excel).

Export Data to CSV File

Some reports are available in CSV (The comma-separated values (CSV) file format is used to store tabular data in which numbers and text are stored in plain-text form that can be easily written and read in a text editor. Traditionally, lines in the text file represent rows in a table, and commas separate the columns.) file formats.  If the  Export Data icon is grayed out, the function is not available.

1. Click on Reports.

2. Select the desired report category using the Select Report Category drop down menu.

3. Click on Export Data, located on the desired report's row.  This launches the CSV (The comma-separated values (CSV) file format is used to store tabular data in which numbers and text are stored in plain-text form that can be easily written and read in a text editor. Traditionally, lines in the text file represent rows in a table, and commas separate the columns.) file.

4. Using the spreadsheet program installed on your computer, use the application's controls to view, edit, save, and/or print the report.
   

Export Data to XLS File

Only select reports are available in XLS (Microsoft Office Excel spreadsheet format. XLS files contain rows and columns of cells and each cell can hold a data point.) file formats and, if they are available, they are located within the Reports Filters page.

1. Click on Reports.

2. Select the desired report category using the Select Report Category drop down menu.

3. Click on Filter, located on the desired report's row.  This opens the Reports Filters page.

4. Filter the report if desired.

5. Click on  Export to Excel. This launches the XLS (Microsoft Office Excel spreadsheet format. XLS files contain rows and columns of cells and each cell can hold a data point.) version of the respective report (filtered or unfiltered).

6. Using the spreadsheet program installed on your computer, use the application's controls to view, edit, save, and/or print the report.

NOTE:

In order to open CSV (The comma-separated values (CSV) file format is used to store tabular data in which numbers and text are stored in plain-text form that can be easily written and read in a text editor. Traditionally, lines in the text file represent rows in a table, and commas separate the columns.) or XLS (Microsoft Office Excel spreadsheet format. XLS files contain rows and columns of cells and each cell can hold a data point.) files, the computer you are using must have a spreadsheet application already installed (such as MS Excel). 

Below are FREE online tutorials in how to work within various types of spreadsheet programs (down to the version number):

• Microsoft: Excel

• OpenOffice: Calc

• Google Drive: Google Spreadsheets