If the tracking numbers in your exported reports look like this:
This is due to how Excel autoformats cells which contain long numbers, like tracking numbers. This article provides workaround steps for both custom reports exported from the Shipments tab or Insights Reports exported from the Insights > Reports screen.
Custom Shipment Report
Note: The screenshots in these steps show Excel 2013. If you have an earlier version, your screen and process may differ slightly. For Excel 2016 users, you will need to restore the text import wizard to complete these steps. If you have trouble, you may need to contact Microsoft support for help troubleshooting your particular version of Excel.
1. Download and save the CSV file from ShipStation. Do not open the file. Opening the file directly in Excel will cause Excel to autoformat the cells. If you save the file after Excel autoformats the cells, the scientific notation will be saved to the file and you will need to download the raw CSV file again.
2. Open Excel, then start a new, blank worksheet.
3. Click the Data tab.
4. Select the From Text option in the Get External Data group.
5. Select the desired CSV file.
This will open up the Import Wizard that will walk you through the import settings. Excel 2016 users will need to restore the text import wizard before moving on if you haven't already.
6. Click Delimited - Characters such as commas or tabs separate each field selected, then click Next.
7. Check both the Tab and Comma boxes. Check the data preview to make sure your data has been separated correctly. 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.