How do I remove the ' before the tracking number on my CSV download?

Created:   |   Updated:

In ShippingEasy, our CSV downloads will have a ' before each tracking number. This is because spreadsheets will automatically truncate this number.

If you would like to omit this, just select the column on the spreadsheet, then do CTRL+F (for Windows) or COMMAND+F (for Mac) and "Find" and leave the "Replace" value blank.
This will cause the numbers to truncate. To change this, change the column format from "General" or "Number" to "Text".

Related articles:
How To: Merge multiple columns of data in Excel without losing any data
How To: Export tracking numbers back to my original CSV file


Please sign in to leave a comment.

Community browse


Questions & Answers

Issues & Bugs

Beta Feedback


Productivity: Features, Interface & Settings

Partners: Integrations, Carriers & Stores

Shipping: Orders, Labels & Shipments

Inventory: Products, Purchase Orders & Suppliers