Do the tracking numbers in your exported reports look like this?
This is due to how Excel formats the cells containing this data. This article provides workaround steps for both custom reports exported from the Shipments tab or Insights Reports exported from the Insights > Reports page.
Custom Shipment Report
Note: The screenshots in these steps show Excel 2013. If you have a different version, your screen and process may differ slightly. If you have trouble, you may need to contact Microsoft support for help on troubleshooting your particular version of Excel.
1. Open a new, blank worksheet in Excel.
NOTE: These steps only impact files that have not been opened. So, be sure that you DO NOT open the file containing the tracking numbers. If you have, re-download the CSV and do not open it until finished with the steps below.
2. Click the Data tab.
3. Select the From Text option in the Get External Data group.
4. Select the desired CSV file.
This will open up the Import Wizard that will walk you through the import settings.
5. Click Delimited - Characters such as commas or tabs separate each field selected, then click Next.
6. Check both the Tab and Comma boxes. Check the data preview to make sure your data has been separated correctly.
7. Click Next.
8. Locate and highlight Shipment - Tracking Number, then change the Column Data Format to Text.
9.Click Finish and your file will be imported with the tracking numbers as the correct format.
When exporting from the Insights tab, you have the option to Export to Text. The steps below provide instructions using this feature. The above process will still work for the Export to Excel option.
1. Go to the report needed in the Insights > Reports page and set date range/store/carrier as desired.
2. Click Export to Text.
3. After the download is complete, open the text file and copy everything within. The text file may look a little disorganized but don't worry!
4. Go to docs.google.com/spreadsheets and open a Blank spreadsheet. (Google docs, sheets, and slides are free and open to the public!)
5. Select cell 'A1' and Paste the copied information. Row 1 will populate with headers, and the rest of the information will display in their designated columns below.
Tracking numbers will display correctly.
6. If needed, you can then download this document to a Microsoft Excel .xlsx file (do not export to CSV), and the numbers will display correctly.
You should now be able to open the new Excel file and see the tracking numbers correctly.
If you see the following alert when opening the .xlsx file, do not convert back to numbers, or Scientific Notation will return.