How to Open your Tier I Report in Excel

Downloading your Tier I Ad Hoc Report will generate a comma separated values (.csv) file that can easily be uploaded into Excel. The options detailed below will discuss how to go about adding your new data into Excel. 

Option 1 - Opening your file 

You can open a text file as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).

1. Go to File > Open and browse to the location that contains the text file.

2. Select Text Files in the file type dropdown list in the Open dialog box.

3. Locate and double-click the text file that you want to open. Because you have a .csv file, Excel automatically opens the text file and displays the data in a new workbook.

When Excel opens a .csv file, it uses the current default data format settings to interpret how to import each column of data. If you want more flexibility in converting columns to different data formats, you can use the Import Text Wizard. For example, the format of a data column in the .csv file may be MDY, but Excel's default data format is YMD, or you want to convert a column of numbers that contains leading zeros to text so you can preserve the leading zeros. To force Excel to run the Import Text Wizard, you can change the file name extension from .csv to .txt before you open it, or you can import a text file by connecting to it.