Many spreadsheet programs, including Excel or google sheets, have a limit for handling large numbers, referred to as digits of precision or number precision. In Excel, this limit is 15 digits. Values beyond this certain number of digits may be rounded or even shown in scientific notation.
This can be problematic when working with numbers that are commonly longer than 15 digits such as SKUs, barcodes, or even tracking numbers.
Read more on Excel's technical specifications and limits here.
Unfortunately, the "Format Cells" function within Excel is not enough to convert these numbers properly, but you can resolve this by simply importing these values in a different format altogether.
Import data into Excel using the Text Import Wizard
Rather than opening the CSV file directly, use Excel's import options:
Open a new blank worksheet within Excel
Select "Import" from the File menu
Select "CSV" file and click Import
Select the raw CSV file downloaded from SKULabs
Excel's Text Import Wizard will open.
Select Delimited and click next.
Select Comma and click next
Select the column "Tracking Number", then select "Text" or "General" at top.
The spreadsheet will open and tracking numbers will show as full values and no longer in rounded or scientific notation.