Download Non-Private Customer List

On this page, you may access United Illuminating's Non-Private Customer Information lists, which are available for download by municipality. Once you download these files, you may import them into an spreadsheet application to view them. If you do import them into a spreadsheet application, it is important that you format certain columns in order to properly view the data.

Please read further below to learn how to format the columns properly.

Specifically, this information includes all non-private customers’ names, addresses, telephone numbers, rate classes, billing cycles and metering environments. In May 1999, UI gave customers the option to flag their accounts as private or non-private. This privacy status applies only to the release of customer lists, and not to the release of historical usage. As the law states, this information is available to DPUC-licensed electric suppliers only.

To begin downloading these customer lists, select a municipality from the drop-down menu and click on the Download button.

A dialog box will ask you where you want to save the file. Point to the directory where you want to save the file and click "OK". A message box will inform you when the file is finished downloading.

Several problems may occur while you are attempting to download data from this Web site that are beyond UI’s control. These problems include glitches in your Internet connection that cause you to lose your ISP connection, slow modem response time, high volumes of Internet traffic, system problems, and sudden loss of power. If you experience any problems while trying to download data from this Web site, the best solution is simply to keep trying. If the problems continue, try closing your browser, disconnecting from your ISP and rebooting your machine. Then restart your browser and ISP connection and try again. If problems still persist, you will want to try again at a later time, preferably when Internet traffic is low.

Viewing the Files

The customer information list files are comma-delimited text files, which means you can view them in just about any spreadsheet or word processing application, including Microsoft Excel and Word. If you are unfamiliar with how to open a comma-delimited text file from within your spreadsheet or word processing application, please refer to that product’s documentation.

Some spreadsheet applications, such as Excel, may display the data in the ZIP and PHONE columns incorrectly by dropping off the leading zeroes. If you are using Microsoft Excel 97, you can avoid this problem by following these steps:

1. Highlight the entire ZIP column (column H) by clicking once on the "H"
2. From the menu bar, select "Format", then "Cells"
3. In the Format Cells dialog box, click on the tab "Number"
4. In the Category box, select "Custom"
5. In the Type box, delete the word "General" and type in 9 zeroes: 000000000
6. Click "OK"
7. Repeat the process for the PHONE column (column J), but in the Custom box, type in 7 zeroes: 0000000

If you do not have a word processing or spreadsheet application, you can still view these files in a simple text editor, such as Notepad or WordPad. Launch your text editing application (such as Notepad) and open one of the files you downloaded. You will see lines of words and commas. Each comma separates the columns of data. Each line represents a row of data.

File Format

The format of the UI Customer Information files is as follows:

• LAST NAME: The last name or business name of the UI customer
• FIRST NAME: The first name of the UI customer
• MIDDLE INITIAL: The middle initial of the UI customer
• ADDRESS: The street address of the UI customer
• ADDRESS 1: Additional address information of the UI customer
• ADDRESS 2: Additional address information of the UI customer
• TOWN: The town name of the UI customer
• ZIP: The ZIP code of the UI customer
• AREA CODE: The area code of the UI customer
• PHONE: The phone number of the UI customer
• RATE CLASS: The rate class of the UI customer (i.e., residential, commercial, etc.)
• BILLING CYCLE: The billing cycle code of the UI customer.
• METER ENVIRONMENT: The meter environment of the UI customer.
• METERED/UNMETERED: Indicates whether the account is metered or unmetered.

 

If you have any questions, please contact our Supplier Relations Department