ShipWorks allows you to export information into a text file or a csv (comma delimited) file. Many of the exports found in ShipWorks contain the shipment information including the shipment's tracking number(s). When you open an export file, typically a .csv file, directly into Excel, most of the time Excel formats the tracking numbers in a way that causes them to not display correctly.
This article guides you through how to import a ShipWorks export file into Excel so that the tracking numbers display properly.
Since Excel typically formats the tracking numbers into scientific notation when you open a csv file directly into Excel, let's take a look at how to import the file into Excel instead. This gives you the ability to define in what format the tracking numbers should display.
1. Launch Microsoft Excel. Then, click on the option to create a Blank Workbook.
2. In Excel, click on the From Text button located in the Get External Data ribbon.
3. Navigate to the ShipWorks export file you wish to view in Excel. Then, click Open.
4. The Excel Text Import Wizard will open. On the first screen, be sure that Delimited is selected. Then, preview your data to be sure that the the fields in your file are displaying in the correct columns. Click Next.
5. Now, be sure to select Comma as the delimiter used in your file. You will notice that Excel places lines between each column in the Data Preview window. Click Next.
6. Select the column that displays your tracking information by clicking on the column.
7. Next, select Text as the Column Data Format.
8. Click Finish. Then, click OK.
That's it! Your tracking numbers should now display correctly in Excel.