Skip to main content
eBay
  • Daily Deals
  • Gift Cards
  • Sell
  • Help & Contact
  • Shop Deals
Home > Sell > Seller Central > Advanced Selling > Seller Tools > Turbo Lister > CSV

Seller Tools

Choose A Topic

Welcome

Turbo Lister
  FAQ
  Top Tips
  Troubleshooting
  Exporting/
  Importing Records


Selling Manager Products
  Selling Manager
  Selling Manager Pro

Blackthorne Products

Tool Recommendations

Featured Customer

Feature Comparison Table

 Importing and Exporting Records  
  • What is "CSV"?
  • What is a CSV "import" or "export"?
  • How do I create a CSV file?
  • How do I export items to CSV format from Turbo Lister?
  • How do I import items from CSV format into Turbo Lister?
  • Why does Turbo Lister support importing and exporting items in CSV format?
  • What is the Turbo Lister CSV format? (advanced users only)
     
    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 items > From.... Then select the file you'd like to import.

    To import listings directly from eBay simply select File > Import items > From eBay Listings… Then select to import Active and/or Ended listings. Once your listings are imported, you can edit or list the item again to eBay.
     
    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 or Region

    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

    ShippingType

    1 = Flat shipping rates
    2 = Calculated shipping rates

    83

    ShippingService

    USPS Priority Mail = 7
    USPS Parcel Post = 8
    USPS Media Mail = 9
    USPS First Class Mail = 10
    UPS Ground = 3
    UPS 3-Day Select = 4
    UPS 2nd Day Air = 5
    UPS Next Day Air Saver = 6

    84

    ShippingPackage

    Letter = 1
    Large Envelope = 2
    USPS Flat Rate Envelope = 3
    UPS Letter = 7
    Package/Thick Envelope = 4
    Large Package/Oversize 1 = 5
    Very Large Package/Oversize 2 = 6

    85

    ShippingIrregular

    0 = Standard, 1 = Irregular/Not Standard

    86

    ShippingWeightUnit

    1 (always)

    87

    WeightMajor

    Integer

    88

    WeightMinor

    Integer

    89

    ShipFromZipCode

    A ZIP code

    90

    PackagingHandlingCosts

    Currency amount

    91

    Year

    The year of the vehicle the part fits.

    92

    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.

    93

    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.

    94

    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.

    95

    ThemeId

    There are many possible values.  We recommend that you find out what ThemeId you need by selecting an item with the desired theme selected.

    96

    LayoutId

    There are several possible values.  We recommend that you find out what LayoutId you need by selecting an item with the desired layout selected.

    97

    AutoPay

    0 = Disabled, 1 = Enabled

    98

    Apply Multi-item Shipping Discount

    0 = Disabled, 1 = Enabled

     

  • Helpful Links
    Customer Support
    Tour (audio / html)
    Discussion Board
    User Guide

    Additional site navigation