Search results

How to import these files into Excel

1. Open a blank workbook.
2. From the menu bar, select the Data tab and choose From Text. An Import Text File window will open.
3. Select the registry file you downloaded and then Import.
4. In the Text Import Wizard under Step 1 of 3, choose Delimited and then Next.
5. In Step 2 of 3, uncheck Tab and check Comma. Select Next.
6. In Step 3 of 3, change the FDID and ZIP code fields to Text format to keep the leading zeroes. Here’s how to do it:
   • Under Data Preview, select the FDID column and then choose Text in the Column Data Format section.
   • Repeat for the ZIP code column.
7. Select Finish. The Import Data window will open. Choose OK. All of the data records now appear in the workbook with one field per column.

Important

1. The address fields that start with “HQ” are the physical location address fields for the fire departments.
2. The address fields that begin with “Mail” are the mailing address fields. Use these when mailing correspondence to fire departments.