Import a spreadsheet of your guns and ammo

Already keep a list in Excel or Google Sheets? Put it into the blank template, save it as a CSV file, and the app adds it. Nothing already in the app changes.

Coming soon: importing arrives in the next app update, version 2.1.0. The templates are ready now, so you can fill yours in and have it waiting.

The blank templates

Two files. Each has the column names on the first line, two guide rows that start with # saying what goes in each column, and one row of example data. Keep the first line exactly as it is; the guide rows can stay or go, the app skips them. Delete the example and add your own rows.

What goes in each column

Ammo

caliber, brand, bullet_type and rounds_per_box are needed. Spelling that differs only in case or spacing counts as the same name, so “9 mm” joins an existing “9MM”.
boxes is how many you have now. It’s recorded as one entry dated the day you import, so your history starts from there. Leave it blank or 0 for a product you’re out of.
notes is anything you like, and price_per_box what one box cost, like 21.99. The price gives the app your cost per round.

Firearms

make, model and type are needed. Type is one of Pistol, Revolver, Rifle, Shotgun, Receiver, SBR, Suppressor, AOW, Machine gun or Other. Other words work too: “Stripped Lower Receiver” is read as Receiver, “Short Barreled Rifle” as SBR, “Silencer” as Suppressor. Anything the app doesn’t recognise is saved as Other, with your words kept at the top of the notes, so nothing is lost.
caliber, serial_number, purchase_date (written 2021-03-14), purchase_price, purchased_from, notes and clean_every_rounds are optional. Leave a cell blank to skip it.
sold_on (written 2024-06-01) marks a firearm you no longer have: it goes straight into Archived as sold or transferred, and doesn’t count against the free version’s three firearms. sold_to, sale_price and sale_note are optional details of the sale.

Saving the file from Excel or Google Sheets

Excel: File › Save As, choose CSV UTF-8 (Comma delimited).
Google Sheets: File › Download › Comma Separated Values (.csv).
Apple Numbers: File › Export To › CSV.

Get the file onto your phone however you like: email it to yourself, AirDrop it, or save it to Google Drive or iCloud Drive. The app reads it through the phone’s own file picker, so it never needs internet access of its own.

Importing in the app

Once the 2.1.0 update is on your phone:

Open Settings › Import from a spreadsheet. On a new install it’s also offered on the first screen after you set your PIN.
Pick the file. The app can also read its own export zip, if you saved one from another phone.
Check the preview. It says what will be added, what’s already there and skipped, and anything past the free limits.
Tap Import. Your ammo and firearms appear on Home with their boxes as today’s starting count.

If a row can’t be read, the app names the file and row number and imports nothing, so you can fix the row and try again.

Questions

Can I import a spreadsheet I already have?

Yes, once its columns match the template. Copy your columns into the template in Excel or Google Sheets, save it as CSV, and import that file. The app reads only its own column names.

What happens to what’s already in the app?

Nothing changes. An import only adds. A product or firearm that’s already there is skipped, and the preview tells you how many before anything is written.

Does an import count against the free limits?

Yes, in the order of the file. The free version keeps up to 3 firearms and 3 calibers; past that, the preview shows what needs Pro and imports the rest.

Can I move everything to a new phone this way?

A spreadsheet brings products and firearms, not your range trips, history, photos or settings. To move everything, make an encrypted backup on the old phone and restore it on the new one.

See everything the app does, or get help.