# Request and validate imports instantly **URL:** \ **Category:** Getting Started\ **Created:** [July 18, 2017, 7:07pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625 "2017-07-18T19:07:36Z")\ **Posts on this page:** 12\ **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:** [July 18, 2017, 7:07pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/1 "2017-07-18T19:07:36Z")
It’s easier to request imports into TroopTrack! Start by going to **Support** `>` **Spreadsheet Import/Export**. This is a new, somewhat experimental, feature. If it proves useful we plan to expand on it. ## Use It First, upload your spreadsheet and specify the type of import. When you submit the request, your spreadsheet will be instantly validated. If there are any errors, the page will reload with messages of what the errors were so that you can fix your spreadsheet. If there are no errors, a new helpdesk ticket will be created with your attachement and the type of import so that we can import the file for you. **Your spreadsheet has to be in `.csv` format (comma-separated values).** The types of imports available are: - [Users](https://community.trooptrack.com/t/user-importer-for-all-unit-types/5236) - [Activities](https://community.trooptrack.com/t/import-your-activities-instantly/5624) - [Achievements](https://community.trooptrack.com/t/import-your-achievements-instantly/5623) - [Equipment](https://community.trooptrack.com/t/import-your-equipment-list-instantly/4627) - [Library](https://community.trooptrack.com/t/import-your-library-instantly/4865) - [Boy Scout Ranks](https://community.trooptrack.com/t/import-your-ranks-instantly/5646) - [Boy Scout Merit Badges](https://community.trooptrack.com/t/import-your-merit-badges-instantly/5647) - [Training](https://community.trooptrack.com/t/import-your-training-instantly/6170) ## Future Plans If this feature works as well as we hope, then in the future the import will happen instantly, so you’ll be able to perform your own imports any time you wish! ---
**Author:** ![DonHoover](https://avatars.discourse-cdn.com/v4/letter/d/7ab992/32.png) [@DonHoover](https://community.trooptrack.com/u/DonHoover)\ **Post date:** [July 21, 2017, 1:58am UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/2 "2017-07-21T01:58:59Z")
What I really want to be able to import is boy scout merit badge completion reports from camps, events, etc. ---
**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 21, 2017, 10:06pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/3 "2017-07-21T22:06:17Z")
You’ll probably be able to do that next week. I just finished building importers for Merit Badges and Ranks today. 🙂 ---
**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 24, 2017, 3:45pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/4 "2017-07-24T15:45:51Z")
We’ve got a Merit Badge importer now! I’ve linked to it in the list of importers above. ---
**Author:** ![avcangem](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@avcangem](https://community.trooptrack.com/u/avcangem)\ **Post date:** [August 3, 2019, 2:15am UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/5 "2019-08-03T02:15:44Z")
I would love to be able to import calendar events! We plan a year in advance and it is somewhat painful to enter each event manually…taking hours. Is this possible? ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [August 9, 2019, 5:27pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/6 "2019-08-09T17:27:23Z")
This has been requested in the past on other threads. The calendar is not just a calendar but a way to view all of the events and they contain much more information that just date, time, and description. There are so many components to an Event it would make for a very cumbersome import and a whole lot of validation. The other importers talked about on this page have much more static data and are specific to individuals. One way I have found to help with this task is to have my laptop at the calendar planning meeting and enter items as they are decided upon. I typically put in generic Camping Weekend or Service Project descriptions as a place holder then as we get closer to the event update with the specific data. ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [September 26, 2019, 5:04pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/7 "2019-09-26T17:04:13Z")
Scouts BSA Units, Check out the 9/20/19 Product Update, the Importers Boy Scout Ranks and Merit Badges has been removed, now you can request an import of ScoutBook data. > [@9/20/19 Product Update](https://community.trooptrack.com/t/9-20-19-product-update/9536): > > BSA IA 2.0 We have made progress with TroopTrack’s integration with the BSA’s new Internet Advancement updates (IA 2.0/Scoutbook). As most know with the recent updates the BSA made to their Internet … ---
**Author:** ![NancyRamirez](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@NancyRamirez](https://community.trooptrack.com/u/NancyRamirez)\ **Post date:** [September 8, 2022, 3:21pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/8 "2022-09-08T15:21:12Z")
> [@Spencer](#): > > It’s easier to request imports into TroopTrack! Start by going to **Support** `>` **Spreadsheet Import/Export**. This is a new, somewhat experimental, feature. If it proves useful we plan to expand on it. > > ## Use It > > First, upload your spreadsheet and specify the type of import. When you submit the request, your spreadsheet will be instantly validated. If there are any errors, the page will reload with messages of what the errors were so that you can fix your spreadsheet. If there are no errors, a new helpdesk ticket will be created with your attachement and the type of import so that we can import the file for you. Is this still valid? If so, what is an ETA for TroopTrack to import the file for us? ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [September 22, 2022, 2:25am UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/9 "2022-09-22T02:25:00Z")
It is still valid, this time of year is typically very busy and @dave said they recently lost one of their staff members, they are a small company, so any member moving on creates a lot for others to fill in for. I would imagine at this time it could take a week or more to get through all of the import requests. Get it in the queue and it will get processed. ---
**Author:** ![HassanAli](https://avatars.discourse-cdn.com/v4/letter/h/e9c0ed/32.png) [@HassanAli](https://community.trooptrack.com/u/HassanAli)\ **Post date:** [December 3, 2024, 4:46pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/10 "2024-12-03T16:46:34Z")
has this not become a self service feature yet? do we still need to request for bulk import ? ---
**Author:** ![AaronStorey](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.trooptrack.com/aaronstorey/32/1953_2.png) [@AaronStorey](https://community.trooptrack.com/u/AaronStorey)\ **Post date:** [December 3, 2024, 5:22pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/11 "2024-12-03T17:22:47Z")
No, most if not all of the spreadsheet importers have been automated. I know for sure the BSA Scoutbook importers are automated. The process is still the same though, and the importers can be found under the Support menu. ---
**Author:** ![HassanAli](https://avatars.discourse-cdn.com/v4/letter/h/e9c0ed/32.png) [@HassanAli](https://community.trooptrack.com/u/HassanAli)\ **Post date:** [December 3, 2024, 6:21pm UTC](https://community.trooptrack.com/t/request-and-validate-imports-instantly/5625/12 "2024-12-03T18:21:26Z")
Thank you @AaronStorey for your response. I was able to import them successfully except for one MB Advancement titled Citizenship in the Nation (2022) which keeps throwing this error, no matter what i do. I tried with and without the trailing spaces, no luck. ![image](https://canada1.discourse-cdn.com/flex027/uploads/trooptrack/original/2X/9/9ef8f0f46f042d6f5e7ed189163c0cd64cfb8637.png)