Import Orders Into Microsoft Office
If you're using Excel it's important that you import the CSV file instead of simply opening it. Here's how...
1. Open Microsoft Excel
2. Find Import Data (it may vary between different versions of Excel). In Excel 2003 it's Date > Import External Data as illustrated below...
3. Select your CSV file
4. proceed through the import wizard.
5. Ensure that the delimited and comma options are checked:
6. On the final step, select the tracking number column and change its format to Text then click Finish to import the data.
For more help, you may also want to refer to the Microsoft help page.