How to Use Excel for the NSC File

Purpose: Use this document to use Excel for the NSC file.

Audience: Student Services staff.

Open a CSV file in Excel

Editing the NSC enrollment report should be avoided if at all possible, please feel free to open the file for review in Notepad.

It is not recommended to open CSV (or any other plain text file) using Excel default settings. This is because there are many reasons beyond just the delimiter that can cause data corruption in your source file. It is imperative to ensure data integrity. An in-depth article on this can be found at The One Man IT Department.

  1. Start with a blank Excel file.
  2. With the needed spreadsheet open, select the cell to import the data from a .csv or .txt file.
  3. On the Data tab, in the Get External Data group, select From Text.
Excel page - From Text button highlighted
  1. Browse for the .csv file you want to import, select it and select the Import button (or simply double-click the .csv file).
Import Text File
  1. The Text Import Wizard will appear, and you follow the steps.
  2. In Step 1, choose the file type and the row number to import the data. Typically, you choose Delimited and row 1, respectively. The preview window in the lower part of the wizard shows the first few entries of your .csv file.
Text Import Wizard - Step 1 of 3
  1. In Step 2, you select a delimiter(s) and text qualifier. Delimiter is the character that separates values in your .csv file. We don’t want the text delimited, so ensure none of the checkboxes are selected.
Text Import Wizard - Step 2 of 3
  1. In Step 3, select text so you don’t lose any leading zeros in the data, and select the Finish button.
Text Import Wizard - Step 3 of 3
  1. Choose the destination for the imported data, either an existing or a new worksheet, and select the OK button to finish importing your .csv file to Excel.
Import Data page
  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.