Exporting a CSV - Troubleshooting

The standard way of listing cards to eBay from CDP is to add a Connection, select card(s), then click List / Send to eBay. More info here.

Some CDP users export a csv from a CDP batch, and then upload the csv to eBay to create listings.

This workflow works only if eBay is your only channel. And any listings created in eBay this way are not synced to CDP inventory.

We recommend making any and all updates in CDP before exporting the csv. If you need to make additional modifications to the csv before uploading to eBay, you can do so in Excel or Google Sheets. Just make sure that the formatting or field type of each column is not changed.
 

eBay CSV Upload Fails After Editing in Excel (Leading Zeros Removed)

Symptoms

You export an eBay bulk-upload .csv from Card Dealer Pro (CDP) and:

• Uploading directly to eBay works

• But if you open the CSV in Excel and edit anything (ex: Custom SKU, Price), the upload fails in eBay

• eBay may show errors related to business policies (or other validation issues), even though the file “looks” identical

Root Cause

Excel is auto-converting certain CSV fields when the file is opened/saved.

The most common issue is that Excel converts ZIP/postal codes to numbers and removes leading zeros (example: 02138 becomes 2138). Once saved, the CSV no longer matches what eBay expects, and the upload can fail.

How to Fix It (Best Practice)

Do not open the CSV by double-clicking it. Instead, import it in a way that preserves formatting as text:

Option A — Import the CSV into Excel (Recommended)

1. Open Excel (blank workbook)

2. Go to Data → From Text/CSV

3. Select the CDP export file

4. In the import preview, set problematic columns (like ZIP/postal code) to Text (or use “Transform Data” in Power Query to set data types)

5. Load the data, make your edits (SKU/Price), then Export/Save as CSV

Option B — Force Excel to Keep Data as Text

If Excel shows a prompt like “convert” when opening a CSV:

• Choose the option that does NOT convert data (leave values as-is / treat as text)

(If the prompt stopped appearing, it’s usually because Excel started auto-opening without asking.)

Option C — Use Google Sheets (Works, but watch ZIPs)

1. Upload CSV to Google Drive

2. Open in Google Sheets (it converts into a sheet)

3. Make edits

4. Download as CSV

5. Verify ZIP/postal codes still have leading zeros before uploading to eBay

Quick Validation Before Uploading to eBay

Before uploading, spot-check:

• ZIP/postal code column: leading zeros still present (ex: 02138, not 2138)

• Any other “number-like” identifiers you don’t want reformatted (SKUs, IDs) are still exactly as intended

Workaround

If you don’t need to edit the file:

• Export from CDP and upload directly to eBay (this avoids the conversion issue entirely)

Related Notes

If you suddenly start seeing errors after editing, and this “used to work,” it’s typically because:

• Excel settings/behavior changed (updates), or

• You opened the CSV in a different way (double-click vs. import)