How to Open and View a Zip2Tax ZIP+4 Table

Why can't I open the ZIP+4 Table in Excel?

Zip2Tax ZIP+4 Tables contain millions of records. Our current 9-digit ZIP+4 Table contains approximately 11 million rows.

Microsoft Excel has a worksheet limit of 1,048,576 rows. Because the ZIP+4 file is much larger than Excel's limit, Excel cannot display the entire table.

Do not open the full ZIP+4 CSV file in Excel. If you do, you will not be able to view the complete table.

Instead, we recommend using TableCruncher, an open-source application designed to work with very large CSV files.

Using TableCruncher to Open Your ZIP+4 Table

Step 1: Download TableCruncher

• Open your web browser and visit the official TableCruncher download page:
• Download TableCruncher
• Download and install the version appropriate for your computer.

For Windows, download the Windows x86_64 version.

Follow the installation instructions provided by TableCruncher.

Step 2: Download Your ZIP+4 Table

• Log in to your Zip2Tax Subscriber Web Portal and download your ZIP+4 Table.
• The table will download as a ZIP file.

Important: The ZIP file must be extracted before you can open the table in TableCruncher.

Step 3: Extract the ZIP File

• Locate the ZIP file you downloaded on your computer.
• Right-click the file and select the option to Extract or Extract All.
• After the file has been extracted, you should see the CSV file containing your ZIP+4 Table.
• The CSV file is the file you will open with TableCruncher.
  

Step 4: Open TableCruncher

Open the TableCruncher application.

Once TableCruncher is open:

1. Click File.

2. Select Open.

3. Locate the extracted ZIP+4 CSV file.

4. Select the file.

5. Click Open.

Note: Because ZIP+4 Tables contain millions of records, the file may take some time to load.