• Download an empty CSV template file: import_cold_steel.csv
  • Save the file on your desktop and open it in Excel:

  • Fill out the template with your cold steel data. See the table below for the file structure details.
    • Note 1: only Name field is mandatory and must be populated, all other columns are optional and can be left empty.
    • Note 2: wish list and owned items can be mixed in the same file. For wish list items set Wish list value to Y.
    • Note 3: for wish list items you can fill out the following columns: name, item type, dimensions, manufacturer and note.


    Column name Max length Note
    Type 50 Lookup data (please read more here).
    Seeded cold steel types.
    Name 200 Mandatory!
    Materials 200
    Condition 50 Lookup data.
    Seeded conditions.
    Dimensions 200 Item dimensions.
    Note 4000 Try not to use all available 4000 chars, keep it short and simple.
    Date purchased 8 Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
    Price purchased 30 Do not include the currency symbol, just numbers, for example 1299.95 ($1,299.55)
    Current value 30 Do not include the currency symbol, just numbers, for example 1299.95 ($1,299.55)
    Serial number 150
    Year built 30 Can be a string or just a number, for example 1987
    Manufacturer 100 Lookup data.
    Seeded cold steel manufacturers.
    Seller name 150 Lookup data.
    Seeded sellers.
    Seller address 150
    Seller phone 50
    Seller email 150
    Seller web 250 Seller web site URL, for example https://www.jgsales.com/
    Date disposed 8 Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
    Price sold 30 Do not include the currency symbol, just numbers, for example 1299.95 ($1,299.55)
    Buyer name 150
    Buyer address 150
    Buyer phone 50
    Buyer email 150
    Wish list 1 Put Y if this item is in your wish list.

    Lookup data

    The application maintains lists of reusable values (aka 'lookups') for some data fields. This simplifies manual data input and keeps the app data consistent and clean. In a new application installation those lists already populated (seeded) with some values. Here is the list of lookups for cold steel data:
    • Cold steel types
    • Conditions - shared with guns, stash (accessories)
    • Cold steel manufacturers
    • Sellers (name, address, phone, email, web site URL) - shared with guns, optics and ammunition.
    For the fields marked as "Lookup data" open the related lookup data link, find the value, (for example condition name) and copy and paste it to the field.

    If you don't find a value you need, type it in in the field - the import process will pick up this new value and add it to the lookup list.
    Seller data
    If you found a cold steel seller in the lookup list, just copy the value to 'Seller name' field. You can leave the remaining seller fields blank - the import process will fill them out for you.
  • Save your data as a CSV file. Feel free to change the file name.
  • Open the CSV file in Notebook. Take a quick look to make sure everything looks good. You should see something similar to this:
  • Transfer the file to the mobile device to start import process.