|
This example for creating a Tab or Comma delimited file uses the JPAMS
MFP Count Report (Student Master - Count in menu bar). After generating report, click on Print. Choose Save as tab delimited file |
 |
| The pop-up window is used to determine where you wish to save the tab delimited file. Suggestion: Create a folder associated with the report, i.e., create a folder in your virtual drive (network) named Enrollment |  |
| In this example, the file will be stored in 0405 SIS and the File name is Duplicate_enroll_8-23-04. |  |
| Importing Tab or Comma Delimited File | |
|
Open Excel Click on File and Open |
 |
|
Locate folder where the Tab or Comma Delimited file is stored (saved). Click on Files type: and select All Files |
 |
| Locate file - note icon associated with file denotes text file. Note the Excel or Word file icons. |  |
|
Double Click on the file icon that you wish to import into Excel. The Text Import Wizard - Step 1 of 3 window appears. Click Next |
 |
|
Note Delimiters are, by default, set to Tab. Select Comma, if the file is comma delimited. Click Finish. What is delimited? In most instances you are importing data maintained in a database. Either tab, comma or other delimiters (seperators) are used when file is exported (generated) to separate each data field in the database table. First Name separating Last Name, separating address, etc. |
 |
| The data appears including, in most instances, the field headings (identified fields in the database table). |  |
|
Select (highlight) with mouse, the column headings and right click.
Select Format Cells in the popup menu. Use the various formatting tools (tabs) to create borders, work with font, change alignment, or distinguish number format. Number format will be required in many instances for date, time, currency, percentage, etc. NOTE: The import process will often drop leading zeros (000111 will be 111). Change the column/field to Text to retain the zeros in the Import Wizard. |
 |
| Completed Report. |  |
|
Click on Data and Sort (menu bar) to sort data. Additional guides and tutorials for Excel may be found HERE. |
 |
 |
|