Skip to main content
eBay
  • Daily Deals
  • Sell
  • Customer Support
  • Shop Deals
 eBay Turbo Lister

CSV Import/Export FAQs

What is "CSV"?
"CSV" stands for Comma Separated Values. It is a text-only format used to store data, often used with spreadsheet or database software. In a CSV file, "fields" of data are separated by commas. This allows programs to re-create the correct field structure for the data by reading through the file and starting a new field every time a comma is encountered.

Here is a simple example of a CSV file: "This is my item title,1234,This is my item description"

Read into a spreadsheet program or similar, the example above would result in three data fields with the following values:

  • This is my item title
  • 1234
  • This is my item description
What is a CSV "import" or "export"?
"Importing" a CSV file refers to a program reading a CSV file and entering the data into its own storage. "Exporting" a CSV file refers to a program taking data that it has stored and creating a new file that contains the data in CSV format.

How do I create a CSV file?
There are many ways to create a CSV file. The most common is to use a spreadsheet program such as Microsoft Excel. (In Microsoft Excel, just select File > Save As…, then select "CSV (comma delimited) (*.csv)" in the "Save As Type" drop-down selector.)

How do I export items to CSV format from Turbo Lister?
To create a CSV file containing items that are in your Turbo Lister program, just select the items you'd like to export, then select File > Export Selected Items. You'll then be prompted to name your new CSV file.

How do I import items from CSV format into Turbo Lister?
To import a CSV file into Turbo Lister, first make sure that the file has the correct set of columns that Turbo Lister will be looking for (see below). Then select File > Import From… > CSV. Then select the file you'd like to import.

Why does Turbo Lister support importing and exporting items in CSV format?
Many sellers have their listing information stored in spreadsheet or database programs. This feature will help those sellers get their listing information into the Turbo Lister program much easier than cutting-and-pasting or entering by hand. This feature will also allow all users to transfer listings between separate installations of Turbo Lister, or even between users in the same installation. For example, if you want to transfer your listings from your Turbo Lister program at home to your Turbo Lister program at work: Just export the listings to a CSV file, email the file to your other computer, and import the file into the other Turbo Lister program.

What is the Turbo Lister CSV format? (advanced users only)
If you'd like to create your own CSV files to import into Turbo Lister, the correct columns to put in your CSV file are listed below. You must make sure that your CSV file contains the specified columns to ensure that the file will be able to be successfully imported into Turbo Lister. (Note: The easiest way to get an example template for your CSV files is to create an item in Turbo Lister and export it to CSV format. The resulting file can serve as a CSV "template" for you.)
  • For the Boolean fields listed below, 1 = "on" or "yes", and 0 = "off" or "no"
  • Fields 69-77 are applicable to Sothebys.com listings only
  • Fields 78-79, 90-93 are applicable to eBay Motors US listings only
  • Fields 80-89 are not currently used.

Other tips:

  • Any field containing a comma or a double-quote character must be surrounded by double-quotes. (To specify a double-quote character within the field, you must enter two double-quote characters. Example: "He said, ""Goodbye"", then he left.")
  • Newline characters should be replaced with %0a in text fields (Description).
Note: Creating CSV files "from scratch" is for advanced users only - we recommend that most users create items with the user interface provided by Turbo Lister.


Field Number Field Name Values
1 Site
  • eBay US = 0
  • eBay Canada = 2
  • eBay UK = 3
  • eBay Australia = 15
  • eBay Belgium (French) = 23
  • eBay France = 71
  • eBay Germany = 77
  • eBay Italy = 101
  • eBay Belgium (Dutch) = 123
  • eBay Netherlands = 146
  • eBay Spain = 186
  • eBay Taiwan = 196
2 Format
  • Auction = 1
  • Dutch Auction = 2
  • Live Auctions = 5
  • Ad Format = 6
  • Store Inventory = 7
  • Fixed Price = 9
3 Currency
  • US $ = 1
  • C $ = 2
  • GBP = 3
  • AU $ = 5
  • EUR = 7
  • NT $ = 41
4 Title Text
5 Description Text
6 Category 1 Category ID
7 Category 2 Category ID
8 Store Category Store Category Number
9 Pic URL URL
10 Quantity Integer
11 Duration [3, 5, 7, 10, 20, 30, 60, 90, 120]
12 Starting Price Currency amount
13 Reserve Price Currency amount
14 BIN Price Currency amount
15 Private Auction [0, 1]
16 Counter
  • No counter = 0
  • Honesty-style = 1
  • Green LED = 2
  • Hidden = 3
17 Buyer pays shipping [0, 1]
18 Seller pays shipping [0, 1]
19 Payment Instructions Text
20 Specifying Shipping Costs [0, 1]
This must be set to "1" if you are specifying values for many of the following fields (e.g. Shipping & Handling).
21 Shipping & Handling Currency amount
22 Additional Shipping Currency amount
23 Insurance Option
  • No counter = 0
  • Optional = 1
  • Required = 2
  • Insurance incl. in S&H = 3
24 Insurance Amount Currency amount
25 Sales Tax Amount Currency amount
26 Sales Tax State State abbreviation
27 Apply tax to total [0, 1]
28 Accept PayPal [0, 1]
29 PayPal Email Address Text (email address)
30 Accept MO Cashiers [0, 1]
31 Accept Personal Check [0, 1]
32 Accept Visa/Mastercard [0, 1]
33 Accept AmEx [0, 1]
34 Accept Discover [0, 1]
35 Accept Payment Other [0, 1]
36 Accept Payment Other Online [0, 1]
37 Accept COD [0, 1]
38 Payment See Description [0, 1]
39 Accept Money Xfer [0, 1]
40 CCAccepted [0, 1]
41 CashOnPickupAccepted [0, 1]
42 MoneyXferAccepted [0, 1]
43 MoneyXferAcceptedinCheckout [0, 1]
44 Ship-To Option
  • SiteOnly
  • WorldWide
  • SitePlusRegions
  • WillNotShip
(if "SitePlusRegions" is specified, at least one of the following 9 fields must be "1")
45 Ship-To Africa [0, 1]
46 Ship-To Asia [0, 1]
47 Ship-To Caribbean [0, 1]
48 Ship-To Europe [0, 1]
49 Ship-To Latin America [0, 1]
50 Ship-To Middle East [0, 1]
51 Ship-To North America [0, 1]
52 Ship-To Oceania [0, 1]
53 Ship-To South America [0, 1]
54 Escrow Buyer [0, 1]
55 Escrow Seller [0, 1]
56 BuyerPaysFixed [0, 1]
57 Location - City/State Text
58 Location - Region Country-specific code - There are a lot of these, so we recommend you find out which code you need by exporting an item with that region selected. (e.g. San Francisco = 49)
59 Location - Country Country-specific abbreviation - There are a lot of these, so we recommend you find out which code you need by exporting an item with that country selected. (e.g. United States = "US")
60 Title Bar Image [0, 1]
61 Gallery [0, 1]
62 Gallery Featured [0, 1]
63 Gallery URL URL
64 Bold [0, 1]
65 Highlight [0, 1]
66 Featured Plus [0, 1]
67 Home Page Featured [0, 1]
68 Gift Icon [0, 1]
69 EstimateLow Currency amount
70 EstimateHigh Currency amount
71 ItemNotes Text
72 Condition Text
73 Measurements Text
74 NumItems Text
75 ShippingNotes Text
76 InventoryNumber Text
77 AuctionCode Text
78 DepositType
  • No deposit = 0
  • Other method = 1
  • Fast deposit = 2
79 DepositAmount Currency amount
80 ShippingRate Currently not used
81 ShippingCarrier Currently not used
82 ShippingMethod Currently not used
83 ShippingPackage Currently not used
84 ShippingMachinable Currently not used
85 ShippingWeightUnit Currently not used
86 WeightPounds Currently not used
87 WeightOunces Currently not used
88 ShipFromZipCode Currently not used
89 ShipFromZipCode Currently not used
90 Year The year of the vehicle the part fits.
91 MakeCode There are many possible values. We recommend that you find out what code you need by exporting an item with that vehicle make selected.
92 ModelCode There are many possible values. We recommend that you find out what code you need by exporting an item with that vehicle model selected.
93 EngineCode There are many possible values. We recommend that you find out what code you need by exporting an item with that vehicle engine selected.


  • Return to Turbo Lister Home


  • Additional site navigation