# Import your Equipment List Instantly **URL:** \ **Category:** Getting Started\ **Created:** [February 9, 2017, 5:57pm UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627 "2017-02-09T17:57:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Spencer](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/spencer/32/427_2.png) [@Spencer](https://community.trooptrack.com/u/Spencer)\ **Post date:** [February 9, 2017, 5:57pm UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627/1 "2017-02-09T17:57:17Z")
**Upload files for this importer [like this](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625).** * * * We recently made an Equipment importer! You can now send us a spreadsheet of your equipment items and we can import them for you instantly. The spreadsheet should follow the pattern of our equipment export spreadsheet: **Required Columns:** - **`Name`** - **`Condition`** Optional Columns: - `Description` - `Location` - `Patrol name` - `Expires on` (DD/MM/YYYY) - `Purchased on` (DD/MM/YYYY) - `Cost` The order of the headers doesn’t matter, and any other headers will be ignored. The `condition` should be one of: ‘Like New’,‘Good’, ‘Usable’, ‘Needs Fixing’, ‘Needs Replacing’, or ‘Needs Maintenance,’ otherwise the item won’t be saved. Dates should be in DD/MM/YYYY format. Example: ``` +-----------+--------------+---------------+-------------+-------------+------------+ | Name | Condition | Description | Location | Patrol name | Expires on | +-----------+--------------+---------------+-------------+-------------+------------+ | Shovel 1 | Like New | | Mike's Shed | Patrol2 | | +-----------+--------------+---------------+-------------+-------------+------------+ | Trailer 2 | Good | 12 ft trailer | | Group 3 | 01/10/17 | +-----------+--------------+---------------+-------------+-------------+------------+ | Truck | Needs Fixing | | | | | +-----------+--------------+---------------+-------------+-------------+------------+ ``` ---
**Author:** ![IowaFossil](https://avatars.discourse-cdn.com/v4/letter/i/59ef9b/32.png) [@IowaFossil](https://community.trooptrack.com/u/IowaFossil)\ **Post date:** [March 1, 2017, 8:09pm UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627/2 "2017-03-01T20:09:53Z")
Can you make one of these for importing our Troop library? I can help supply the Column headings. ---
**Author:** ![Spencer](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/spencer/32/427_2.png) [@Spencer](https://community.trooptrack.com/u/Spencer)\ **Post date:** [March 8, 2017, 1:17am UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627/3 "2017-03-08T01:17:43Z")
It’s been done. We only store titles, descriptions, and conditions of book (besides information about whether they’re checked out or not), so that’s what you can import. ~~The library importer isn’t live yet, but will be soon.~~ Edit: The library importer is ready, @IowaFossil. Here’s the [user guide page](https://community.trooptrack.com/t/import-your-library-instantly/4865?u=spencer) for it. ---
**Author:** ![tsockriter](https://avatars.discourse-cdn.com/v4/letter/t/df788c/32.png) [@tsockriter](https://community.trooptrack.com/u/tsockriter)\ **Post date:** [July 14, 2017, 2:03pm UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627/4 "2017-07-14T14:03:58Z")
Would we have to send this to you every time? I see an export click, but not an import. We just got a new shed (very exciting) and want to fill it with inventory that’s been stored in everyone’s garages. 🤣 Tracy CO1027 ---
**Author:** ![Spencer](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/spencer/32/427_2.png) [@Spencer](https://community.trooptrack.com/u/Spencer)\ **Post date:** [July 14, 2017, 8:11pm UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627/5 "2017-07-14T20:11:08Z")
For now, yes, the files have to be sent to the helpdesk every time. We’re working on making this and other importers available directly without the helpdesk, but that’s not available yet. ---
**Author:** ![tsockriter](https://avatars.discourse-cdn.com/v4/letter/t/df788c/32.png) [@tsockriter](https://community.trooptrack.com/u/tsockriter)\ **Post date:** [July 14, 2017, 9:24pm UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627/6 "2017-07-14T21:24:54Z")
Okay thank you. It sounds like a girl leadership data entry job for now. 😄 This will be great. Thank you for all your work on TT. Tracy ---
**Author:** ![EricWillman](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/ericwillman/32/3341_2.png) [@EricWillman](https://community.trooptrack.com/u/EricWillman)\ **Post date:** [April 10, 2023, 2:25pm UTC](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627/7 "2023-04-10T14:25:05Z")
Could this be used to update existing equipment items, or is import only for adding new equipment? For example, if we move a large portion of our equipment to a new storage location, can I export my inventory, bulk edit the location field, then re-import the file, or would I need to edit each item manually through the equipment pages?