ShipWorks allows you to export information into a text file or Comma Separated Value (CSV). In ShipWorks, a CSV is called a 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 process 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. Go to Excel and click on the From Text button located in the Get External Data ribbon.
3. Go to the ShipWorks export file you wish to view in Excel. Then, click Open.
The Excel Text Import Wizard will open.
4. Ensure that Delimited is selected on the first screen. Then, preview your data to be sure that the fields in your file are displaying in the correct columns. Click Next.
5. 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. 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.
Still Need Help?
Please feel free to reach out to one of our awesome Technical Support Representatives in St. Louis. We are happy to help.
Have a comment to share about this article? We'd love to hear from you. You must be logged in to your Support Portal account to leave a comment.