How to open a CSV/tab-delimited file in Excel

Owned by Nicholas Cook
Last updated: Mar 26, 2024
2 min read

This article provides a guideline for opening CSV, tab-delimited, and other text-based files in Excel without losing the leading 0 on GTINs, and without having numbers get converted to exponential format.

 

1. Click "From Text/CSV"

image-20240326-150822.png

2. Click "Name"

image-20240326-150833.png

3. Click "Import"

4. Click "Transform Data"

5. Click the "UPC" header. (You will need to repeat this step, and the next three steps for each UPC/Barcode/SKU column to avoid them losing leading 0's and preventing them from getting converted to exponential numbers.)

6. Click "Data Type: Whole Number"

7. Click "Text"

8. Click "Replace current"