Plugins Factory

Jira asset management template for inventory CSVs

Copy a laptop or software licence CSV, replace the fictional rows, and prepare your inventory for import into Assets, AssetPilot or Jira work items.

Reviewed

This Jira asset management template gives you CSV files for an IT asset inventory, with one file per asset type. Copy the laptops file below, replace the fictional rows, and follow the guidance for importing into Atlassian Assets, AssetPilot or Jira work items (issues).

What's in the template

The laptops file has 16 columns: inventory details followed by laptop-specific fields. The software licences variant has its own columns for licence details. Keep each asset type in a separate file.

These are inventory data templates. They provide rows to import; you still need to configure the destination fields and mapping. All example rows are fictional, including the example.com emails and SN-EXAMPLE serials.

Copy the laptops CSV

Copy the header and rows into a text file, replace the examples, and save it with a .csv extension.

Tag,Name,Status,Serial,Location,Assignee email,Supplier,Purchase date,Purchase cost,Currency,Warranty end,Notes,Model,CPU,RAM,Operating system
LT-0001,Laptop - Design 01,In use,SN-EXAMPLE-0001,HQ,alex@example.com,Apple,2025-03-14,2399.00,USD,2028-03-13,Issued with charger,MacBook Pro 14,Apple M4 Pro,32 GB,macOS
LT-0002,Laptop - Engineering 07,In use,SN-EXAMPLE-0002,Remote,sam@example.com,Lenovo,2024-11-02,1899.00,USD,2027-11-01,,ThinkPad X1 Carbon Gen 12,Intel Core Ultra 7,32 GB,Windows
LT-0003,Laptop - Spare 01,Available,SN-EXAMPLE-0003,HQ,,Dell,2024-06-20,1499.00,USD,2027-06-19,Spare pool,Latitude 7450,Intel Core Ultra 5,16 GB,Windows
LT-0004,Laptop - Support 02,In repair,SN-EXAMPLE-0004,HQ,,Apple,2023-09-05,1299.00,USD,2026-09-04,Keyboard replacement,MacBook Air 13,Apple M2,16 GB,macOS
LT-0005,Laptop - Finance 03,Retired,SN-EXAMPLE-0005,HQ,,HP,2021-02-10,1099.00,USD,2024-02-09,Wiped and recycled,EliteBook 840 G8,Intel Core i5,8 GB,Windows

Columns explained

Required fields depend on the destination. In AssetPilot, Name is always required, along with any required fields for the type; the IT equipment Laptop type also requires Model.

Copy the software licences CSV

The type-specific columns are Licence key, Seats, Vendor, Renewal date and Vendor portal.

Tag,Name,Status,Supplier,Purchase date,Purchase cost,Currency,Notes,Licence key,Seats,Vendor,Renewal date,Vendor portal
SW-0001,Design suite - team plan,In use,Reseller Ltd,2026-01-15,1440.00,USD,Annual plan,KEY-EXAMPLE-0001,5,Example Software Inc.,2027-01-14,https://vendor.example.com
SW-0002,IDE licences,In use,Example Software Inc.,2026-04-01,2900.00,USD,,KEY-EXAMPLE-0002,10,Example Software Inc.,2027-03-31,https://vendor.example.com

Use the CSV with your import route

AssetPilot

AssetPilot is made by Plugins Factory, the publisher of this page.

The column names are the same as in its import templates for the IT equipment Laptop and Licence types, so AssetPilot suggests the mapping for you. Review the mapping and the row validation before importing.

Assignee email does not set assignments during import. Check assets out to people after importing. Files can contain up to 10,000 rows and must be 5 MB or smaller; the separate site limit is 5,000 assets. Rows with errors are skipped, and duplicate tags or serials within the file are flagged.

Learn more about AssetPilot.

Atlassian Assets

In your schema, open Schema settings → Import and create a CSV import structure. Map the columns to the intended object type and attributes, set mappings to ENABLED, then use Import data.

Set the date format to yyyy-MM-dd for these files: Assets defaults to MM/dd/yyyy. For later updates, configure a unique Tag or Serial attribute as the identifier; without an identifier, imports recreate objects. Map people using their email addresses.

Jira work items

A Jira admin can use System → External System Import → CSV. Map Name to Summary, which this route requires. This route creates work items for the inventory rows.

Follow the full steps to import assets into Jira from CSV.

Before you import

Start with the laptops CSV above: replace the example rows, check the required fields, then follow your import route. For help choosing a destination, read the Jira asset management guide.

Frequently asked questions

Can I add my own columns?

Yes. AssetPilot includes a type's custom fields after the base columns in its import template. In Assets, map your columns to attributes in the import structure.

Why use one file per asset type?

Laptops and licences have different fields. Assets maps imported data to object types, while AssetPilot provides a template for each type.

Which date format should I use?

Use YYYY-MM-DD for these files. AssetPilot prefers that format; in Assets, configure the import structure to use yyyy-MM-dd instead of its default MM/dd/yyyy.

Can I use the template in Excel or Google Sheets?

Yes. Save or export the completed sheet as CSV with UTF-8 encoding.

Sources