My Armory

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 1: only Gun 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, gun type, caliber, dimensions, manufacturer, C&R eligible and note.

Column name	Max length	Note
Gun type	50	Lookup data (please read more here). Seeded gun types.
Gun name	200	Mandatory!
Condition	50	Lookup data. Seeded conditions.
Bore condition	50	Lookup data. Seeded bore conditions.
Caliber	50	Lookup data. Caliber can be a single value, for example 9mm Luger, or a comma separated string, for example 5.56 NATO,.223 Rem Seeded calibers.
C&R flag	1	Put Y if this gun is curio and relic eligible.
Dimensions	200	Gun dimensions.
Note	4000	Try not to use all available 4000 chars, keep it short and simple.
Rounds fired	10	A positive number.
Last fired date	8	Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
Last cleaned date	8	Date in format YYYYMMDD, for example 20191201 (Dec 1, 2019)
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 gun manufacturers.
Seller name	150	Lookup data. Seeded sellers.
Seller address	150
Seller FFL license	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 FFL license	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 gun data:

Gun types
Conditions - shared with cold steel, stash (accessories)
Bore conditions
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.

Gun data import

Step by step instructions

Lookup data

Seller data