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

  • Fill out the template with your gun data. See the table below for the file structure details. Note that only Gun name field is mandatory and must be populated, all other columns are optional and can be left empty.

    Column nameMax lengthNote
    Gun type50Lookup data (please read more here).
    Seeded gun types.
    Gun name200Mandatory!
    Condition50Lookup data.
    Seeded conditions.
    Caliber50Lookup data.
    Seeded calibers.
    C&R flag1Put Y if this gun is curio and relic eligible.
    Dimensions200Gun dimensions.
    Note4000Try not to use all available 4000 chars, keep it short and simple.
    Rounds fired10A positive number.
    Last fired date8Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
    Last cleaned date8Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
    Date purchased8Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
    Price purchased30Do not include the currency symbol, just numbers, for example 1299.95 ($1,299.55)
    Serial number150
    Year built30Can be a string or just a number, for example 1987
    Manufacturer100Lookup data.
    Seeded gun manufacturers.
    Seller name150Lookup data.
    Seeded sellers.
    Seller address150
    Seller FFL license150
    Seller phone50
    Seller email150
    Seller web250Seller web site URL, for example https://www.jgsales.com/
    Date disposed8Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
    Price sold30Do not include the currency symbol, just numbers, for example 1299.95 ($1,299.55)
    Buyer name150
    Buyer address150
    Buyer FFL license150
    Buyer phone50
    Buyer email150

    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 gun data:
    • Gun types
    • Conditions - shared with cold steel, stash (accessories)
    • Calibers - shared with ammunition
    • Gun manufacturers
    • Sellers (name, address, FFL license, phone, email, web site URL) - shared with cold steel, optics and ammunition.
    For the fields marked as "Lookup data" open the related lookup data link, find the value, (for example caliber or 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 gun 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.