# Anyone got a list of all the skills and their rank, primary attribute and secondary attribute

**URL:** <https://forums.eveonline.com/t/anyone-got-a-list-of-all-the-skills-and-their-rank-primary-attribute-and-secondary-attribute/111853>\
**Category:** Third Party Developers\
**Created:** [October 8, 2018, 11:38am UTC](https://forums.eveonline.com/t/anyone-got-a-list-of-all-the-skills-and-their-rank-primary-attribute-and-secondary-attribute/111853 "2018-10-08T11:38:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Holly\_Tustola](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/holly_tustola/32/100503_2.png) [@Holly\_Tustola](https://forums.eveonline.com/u/Holly_Tustola)\
**Post date:** [October 8, 2018, 11:38am UTC](https://forums.eveonline.com/t/anyone-got-a-list-of-all-the-skills-and-their-rank-primary-attribute-and-secondary-attribute/111853/1 "2018-10-08T11:38:29Z")

</div>

Hi,

Looking for a way to import a list of all the skills names and their relevant rank, primary attribute and secondary attribute into excel.

Anyone got a list of these/ know a easy way I can get them?

Thanks,  
Holly

---

<div class="post-metadata">

**Author:** ![Steve\_Ronuken](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/steve_ronuken/32/373894_2.png) [@Steve\_Ronuken](https://forums.eveonline.com/u/Steve_Ronuken)\
**Post date:** [October 8, 2018, 12:03pm UTC](https://forums.eveonline.com/t/anyone-got-a-list-of-all-the-skills-and-their-rank-primary-attribute-and-secondary-attribute/111853/2 "2018-10-08T12:03:42Z")

</div>

The details you’re looking for are in dgmTypeAttributes.

Skill names and IDs are in InvTypes (along with everything else)

To restrict it, you’d join in invGroups (using groupid) and restricting on categoryid (skills are all categoryid 16). you’ll probably want to restrict on published in invTypes too.

Then you’ll want:

Attribute  
180 primaryAttribute  
181 secondaryAttribute  
280 skillTimeConstant (The rank multiplier)

so something like:

```
select 
typename, 
coalesce(dta1.valueFloat,dta1.valueInt) skillRank, 
coalesce(dta2.valueFloat,dta2.valueInt) primaryAttribute, 
coalesce(dta3.valueFloat,dta3.valueInt) secondaryAttribute 
from invTypes
join invGroups on invTypes.groupid=invGroups.groupid and categoryid=16
join dgmTypeAttributes dta1 on dta1.typeid=invTypes.typeid and dta1.attributeid=275
join dgmTypeAttributes dta2 on dta2.typeid=invTypes.typeid and dta2.attributeid=180
join dgmTypeAttributes dta3 on dta3.typeid=invTypes.typeid and dta3.attributeid=181
where invTypes.published=1;

```

From the converted sde available at [https://www.fuzzwork.co.uk/dump/](https://www.fuzzwork.co.uk/dump/)

(There are excel exports, but it’s not the simplest of things to pull from them)

> <https://gist.github.com/fuzzysteve/fdea8f7bc19db47dadb18eb2b62615e2>

---

<div class="post-metadata">

**Author:** ![Holly\_Tustola](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/holly_tustola/32/100503_2.png) [@Holly\_Tustola](https://forums.eveonline.com/u/Holly_Tustola)\
**Post date:** [October 8, 2018, 3:16pm UTC](https://forums.eveonline.com/t/anyone-got-a-list-of-all-the-skills-and-their-rank-primary-attribute-and-secondary-attribute/111853/3 "2018-10-08T15:16:25Z")

</div>

Thank you, that has sorted my problem out and saved me a lot of time

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [January 6, 2019, 3:16pm UTC](https://forums.eveonline.com/t/anyone-got-a-list-of-all-the-skills-and-their-rank-primary-attribute-and-secondary-attribute/111853/4 "2019-01-06T15:16:29Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.