Data Import & Export

How to Prevent Excel from Truncating USPS Tracking Numbers in CSV Files

Algirdas Jasaitis Oct 1, 2026 868 views

Question details

The user needs a method to stop Excel from shortening or altering long USPS tracking numbers when opening downloaded CSV files.

How to Prevent Excel from Truncating USPS Tracking Numbers in CSV Files

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a downloaded CSV file (such as an EasyPost export) that contains long numeric strings in Microsoft Excel.
Observed behavior: USPS tracking numbers are truncated or converted to scientific notation, resulting in a loss of the final digits, whereas shorter or alphanumeric UPS numbers remain complete.

Before you start

Do not manually edit or save the affected file if the numbers are already truncated. Download a fresh copy of the original CSV file to ensure no data is permanently lost before attempting the import process.

Solution 1Recommended

Import CSV Data Using Power Query

Instead of double-clicking the CSV file, import it into a blank workbook to manually set the column data type to Text, preventing any automatic truncation.

By default, Excel treats any cell containing only digits as a number. Since Excel has a 15-digit precision limit, long numeric strings like 22-digit USPS tracking numbers are converted to scientific notation, and the remaining digits are replaced with zeros. Using Power Query bypasses this by allowing you to define the data type before loading it.

Open a blank workbook

Launch Excel and open a completely new, blank workbook rather than opening your downloaded CSV file directly.

Initiate data import

Navigate to the 'Data' tab on the ribbon and click on 'From Text/CSV' (or 'From Text' in older versions of Excel).

Select your CSV file

Browse your computer for the downloaded CSV file containing the tracking numbers, select it, and click 'Import'.

Transform the data

In the preview window that appears, click the 'Transform Data' button to open the Power Query Editor.

Change column data type

Locate the column containing your USPS tracking numbers. Click the data type icon (usually '123' or 'ABC') in the column header and select 'Text' from the dropdown menu. If prompted to replace the current step, choose 'Replace current'.

Load the data into Excel

Click the 'Close & Load' button in the top left corner. The data will now populate in your spreadsheet with all tracking numbers perfectly preserved as text.

Data Successfully Preserved: Your USPS tracking numbers will now display their full digits. You can save this file as an Excel Workbook (.xlsx) to maintain the text formatting permanently.

Solution 2

Disable Automatic Data Conversion in Excel Settings

Adjust Excel's global options to prevent it from automatically converting long numeric strings into scientific notation.

Manage CSV Data Easily

Easily Import and Manage CSV Files Without Data Loss in WPS Office

WPS Spreadsheet provides a straightforward Text Import Wizard that inherently prevents long numbers from being truncated or converted. Easily define column formats as Text to handle your tracking and shipping data with absolute precision.

1. Launch WPS Spreadsheet: Open a blank worksheet in WPS Spreadsheet.
2. Import the Data: Navigate to the 'Data' tab on the top menu and click on 'Import Data', then select 'Import Data' from the dropdown to locate your CSV file.
3. Configure Delimiters: In the Text Import Wizard, select 'Delimited' and click Next, then check the 'Comma' box to separate your columns correctly.
4. Set Column Format to Text: In Step 3 of the wizard, click on the column containing the tracking numbers in the Data preview section, then change the 'Column data format' radio button to 'Text'.
5. Finish the Import: Click 'Finish' and choose where to put the data. Your 22-digit USPS numbers will be completely preserved.

Intuitive Text Import Wizard makes it simple to format specific columns as Text before loading.Highly compatible with all Microsoft Excel (.xlsx, .xls, .csv) file formats.Lightweight, fast, and features a familiar interface for seamless data management without a steep learning curve.

Frequently Asked Questions

Why does Excel truncate USPS tracking numbers but not UPS numbers?

USPS tracking numbers typically consist of 22 digits. Excel has a maximum numerical precision limit of 15 digits, so it converts longer numbers to scientific notation and replaces the trailing digits with zeros. UPS tracking numbers usually contain letters (alphanumeric) or are shorter than 15 digits, forcing Excel to automatically categorize them as text, preventing any truncation.

Can I recover truncated tracking numbers if I accidentally saved the CSV file?

Unfortunately, no. Once you save a CSV file in Excel after the numbers have been truncated and converted to zeros, the original data is permanently overwritten. You must log back into your shipping platform (like EasyPost) and download a fresh copy of the CSV export.

How do I enter a long tracking number manually without it converting to scientific notation?

If you need to manually type or paste a single long tracking number into a cell, simply type an apostrophe (') before the number. The apostrophe tells the software to treat the entry strictly as text. It won't be visible in the cell, but it will preserve the exact sequence of digits.

Excel & Data Problems