Guides & Updates

Moving from spreadsheets to FMS

Prepare a firearm CSV, preview it, resolve issues and review the imported records before retiring your old spreadsheet.

Moving records is easier when you preserve the original spreadsheet and work on a separate copy. FMS's CSV inventory import adds firearm records. It does not import an entire workbook, ammunition history, maintenance history or attached files. 1. Preserve your originals Keep an unchanged copy of the spreadsheet and its supporting documents. If FMS already contains records, open Backup and Data, choose Create backup and then Verify latest backup before importing. 2. Prepare one row per firearm Save the working sheet as a CSV with these required column headers: Manufacturer,Model,SerialNumber,Caliber Keep serial-number cells as text so the spreadsheet does not remove leading zeros. Verify required values against your records. Optional supported columns include Category, ActionType, AcquisitionCondition, CurrentCondition, AcquiredDate, PurchasePrice, PurchaseSource, StorageLocation and Notes. Condition is also accepted as a fallback for CurrentCondition. Use unambiguous dates such as 2026-10-02 and plain decimal prices such as 1250.00. Check dates especially carefully: a blank or unrecognized AcquiredDate currently falls back to the import-time date. An unrecognized PurchasePrice becomes blank. A preview without validation issues does not prove every original value was interpreted as you intended. Keep each CSV record on one line; remove embedded line breaks from notes. Quote values containing commas, and double quotation marks within quoted values. Spreadsheet CSV export normally handles comma and quotation-mark escaping. 3. Preview before committing In Backup and Data, find Import and Export and select Preview CSV. Read the validation summary. Resolve missing columns, invalid values and duplicate identities in your working file, then preview again. FMS checks the combination of manufacturer and serial number against both the CSV and existing firearm records. This is an add-records workflow: importing the same firearm again is not an update operation. 4. Import and review When the preview is valid, choose Commit import. FMS records the import as one transaction and adds audit entries. Review the imported firearms against the spreadsheet, paying particular attention to serial numbers, acquisition dates, prices and condition. Add documents and photographs separately. Record other types of inventory and activity through their appropriate FMS workflows. Keep the original spreadsheet until you have verified the result and created a fresh encrypted backup. About CSV exports Export CSV can help you inspect field names. Serial numbers are excluded unless you enable Include Serial Numbers in Export. Exported CSV files are outside database encryption. A CSV is not a complete FMS backup, and exporting then re-importing it is not a full recovery workflow. If the imported result is unexpected, stop and request human support with your app version and non-sensitive error text. Do not send your spreadsheet or collection details through support chat.
FMS Backup and Data workspace with backup, CSV import and recovery controls
Backup and Data workspace. Appearance and available controls may vary by version.

FMS Backup and Data interface and CSV inventory importer; reviewed October 2, 2026

Browse all guides · Ask FMS support