ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TO USE THIS LIST properly you will need to make a copy of the file.
This will allow you to sort and filter by any of the columns.
File -> Make a Copy, and you're good to go!
2
3
This spreadsheet was made by Reddit user u/Fleffle (STO account @vanderben)
Feel free to ping me in either place if you notice any errors. My QA staff is not large :P
4
5
6
Last Updated:28 Jan 2025
7
8
Original Copy Updated:28 Jan 2025Up to date!Handy Dandy Link to Original Copy
9
^ This feature broke, apparently
Will look into it later
10
Download T6 table as .csv
11
Download entire sheet as .xlsx
12
13
Changelog:
14
7 Feb 2025Sortable/Filterable T6 Ship List V2 can be found HERE: https://docs.google.com/spreadsheets/d/1SSsxWmE8Oz35D6MvLheFNUfhWerHNkUGOGtjxLlrTuA
and the Alliance Garrett Command Dreadnought Cruiser has been added to it
15
28 Jan 2025Added Breen Keth Sarr Intel Courier
16
22 Jan 2025--- COMING SOON ---
Starting with the upcoming 15th Anniversary event, there will be a NEW VERSION of this spreadsheet, with a new URL. A link to it will be provided here as the final Changelog entry.

What's new about it?
The biggest thing is that it will UPDATE ITSELF.
You will no longer have to come back here and make a new copy every time a ship comes out.
With the new version, you make a copy once. And then your copy will pull in new ships as I add them to my copy!

I've included a few other features as well:
- New Column: Universal Console. This column and the Trait Name column will both include links to the wiki.

- New Option: Include X-Upgrades. You can use Column A to mark a ship as "x1", "x2", ("x3" someday?), etc. The table will have an option to add the x-upgrade level to its Device count and Universal Console Slot count.
- New Option: Include Universal Console Slots as Sci/Tac/Eng. Count Universal console slots as if they were Tactical or Engineering or Science slots. This is indended to help you answer questions like "Which of my ships can slot 5+ Isomag consoles?"
- New Option: Science Destroyer Modes. View Science Destroyers as if they were in Science Mode or Tactical Mode. This replaces their row in the table with two rows, one for each mode.

- New Tab: Mastery Package reference table
- New Tab: Ship Type reference table, with a Detailed and Simplified version
17
7 Jan 2025Added "Old Rivals" Mudd's Choice Bundle
18
15 Dec 2024Changed Compiler Science Dreadnought source to Phoenix
19
3 Dec 2024Added Obena Miracle Worker Heavy Cruiser note: blog says it has Juggernaut mastery which I assume is a copy-paste mistake from the Areore. blog also doesn't mention cruiser commands, so we'll see :)
20
2 Dec 2024Added Eleos Intel Scout Vessel
21
26 Nov 2024Updated Ferengi Nagus Marauder as it had Command spec added to a seat
22
11 Nov 2024Added Areore Miracle Worker Juggernaut
23
16 Oct 2024Added Lamarr Temporal Science Dreadnought
24
1 Oct 2024Added "32nd Century Legacy" Mudd's Choice Bundle
25
14 Sep 2024Added Typhoon Temporal Battlecruiser
26
13 Sep 2024Added Nova One Pilot Raider
27
20 Aug 2024Added Hirogen Predator Heavy Escort
28
1 Aug 2024Changed the Source for the Fek'ihri Byr'jai Interceptor to Mudd's (Single)
Also did the same for the Cnidarian, the Risian Cruiser, and the Terran Somerville since those were out of date
29
25 Jul 2024Added Heritage Starship Bundle
30
28 Jun 2024Added Credence Miracle Worker Dreadnought Cruiser
31
27 Jun 2024Added Vovin Obelisk Carrier
32
19 Jun 2024Added "Sol System Defense" Mudd's Choice Bundle
33
28 May 2024Added Aetherian Revelation
34
1 May 2024Added Dyson Science Destroyer Bundle
35
10 Apr 2024Added Kelvin Timeline Constitution II Intel Cruiser
36
22 Mar 2024Added Dread - Through the Ages Mudd's Choice Bundle
37
13 Mar 2024Added Orion D'var Temporal Science Vessel
38
14 Feb 2024Added 14th Anniversary Bundle
39
16 Jan 2024Added the Alliance Rex Pilot Escort and the Duderstadt Miracle Worker Science Spearhead.
Added Wingmen column to the Misc. section - at this time, it's Yes for all Vanguard ships and for the Rex
Updated the Full column for ships that have fullspec abilities despite not having a commander-ranked spec seat. At this time, that is the Rex, the Tamarian Cruiser, and the Hysperian Battlecruiser.
40
10 Jan 2024Added "Disco Inferno" Mudd's Choice Bundle
41
4 Dec 2023Added Borg Assimilator Dreadnought Carrier
42
30 Nov 2023Added Tamarian Deep Space Cruiser
43
15 Nov 2023Added Shrike Intel Juggernaut
44
22 Oct 2023Use "Publish to Web" in google sheets to make it easier to export
45
20 Oct 2023Added "Awesome Mix" Mudd's Choice Bundle
46
4 Oct 2023Added Dauntless II Command Science Dreadnought
47
28 Sep 2023Added Legendary Avenger Battlecruiser and Legendary Bortasqu' Battlecruiser
48
11 Sep 2023Added Protostar Temporal Science Spearhead
49
18 Aug 2023Added "Cruiserweight" Mudd's Choice Bundle
50
4 Aug 2023Added Friendship Command Flight Deck Carrier
51
25 Jul 2023Added Starfleet Flashback Bundle
52
26 Jun 2023Added Theseus Miracle Worker Destroyer and Hysperian Intel Battlecruiser
53
8 Jun 2023Added Constitution III Miracle Worker Cruiser
54
24 May 2023Added "As Seen On TNG" Mudd's Choice Bundle
55
8 May 2023Added Gorn Hunter Pilot Raider
56
6 Apr 2023Added Legendary Akira Multi-Mission Command Cruiser and Legendary Valdore Temporal Ops Warbird
57
8 Mar 2023Added Texas MW Escort
(I also noticed that I broke the Import tab (again) when I added the T5 Zen ships in January. Whoops.)
58
6 Mar 2023Updated all wiki links to point to the new STO wiki!
59
15 Feb 2023Added 13th Anniversary Bundle
60
21 Jan 2023Added the last of the data for Compiler Science Destroyer
Fixed some data on the T5 Zen Ships tab - the weapon slots were all scrambled.
61
20 Jan 2023Added World Razer Temporal Ops Juggernaut, and (for now) most of the data for the Compiler Science Destroyer.
Also added a T5 Zen Ships tab, intended for reference by folks with a shiny new 100% Off T5 Coupon to spend.
62
5 Dec 2022Added Fek'Ihri Byr"Jai Interceptor and finalized the Excelsior II Intel Heavy Cruiser
63
1 Dec 2022Added most of the info for the Excelsior II Intel Heavy Cruiser. Waiting for release to confirm a few things.
64
16 Nov 2022Added Praetor Command Warbird Battlecruiser
65
12 Nov 2022Expanded my script that validates data against the wiki to cover more columns, including the release date, the admiralty data, and the trait name. Fixed a lot of small errors.
66
20 Oct 2022Added the last info for the Federation Command Carrier Bundle ships
67
18 Oct 2022Changed Gok'tad source to "C Store (Mudd)"
Added the Norway/Valdres and Hiawatha/Seneca, though they're missing some information until their blogs go up. Usually I don't put them on the changelog until they're done, but these ones may have a longer wait.
68
6 Oct 2022Added Farragut Temporal Cruiser
69
29 Sep 2022I'm messing around with some visual things to make the table look better. At the moment, that includes:
- Clearing out any cell that just said "No" or "0". Those cells are now blank.
- Adding some color to a few of the headers. Might help find specific columns faster.
70
12 Sep 2022Added the Terran Somerville Scout Ship and Courier Pilot Raider
Changed the "Family" name from Hernandez to Somerville (I usually try to go with the oldest name, and I had assumed that the Hernandez was one of the Battle of the Binary Stars ships, with a Cryptic-original modern version. It's not, the Somerville appeared in a comic, Cryptic made the Hernandez)
Removed all of the Bold text from the Ships, Compare, and Small Craft tables. The intent was to make the text stand out better against colored backgrounds, but I'm gonna try it without the bold for a bit. Ping me if you hate it. I can also tune down any colors that are hard to read against.
71
6 Sep 2022Added most of the info for the Terran Somerville Scout Ship and Courier Pilot Raider
(will update again and set the Last Updated date when the blog goes up with the last few fields - power bonuses, cloak, flanking bonus)
72
29 Aug 2022Changed Risian Weather Control Vessel's source from Event Only to C Store (Mudd)
Changed T'Pau Scout Ship's source from C Store (Mudd) to Phoenix
73
24 Aug 2022Added "Primary Faction" Mudd's Choice bundle
74
11 Aug 2022Added Sagan Command Cruiser
75
21 Jul 2022Made some changes for Science Destroyers: There's a new column in the Science Vessel section titled "Tac Mode", and also the Tactical Seat is now marked as Rank 4 instead of Rank 3. (They were already marked as having an Experimental Weapon.)
The idea being that if someone wanted to search for ships that can equip, say, CSV3, then Science Destroyers should come up in those results.
There are other stat changes from Tactical Mode (like power levels, for instance) that are still not reflected, because I think they're too low-impact to be worth cluttering up my beautiful table for :)
76
14 Jul 2022Added Federation Responder bundle and associated Fleet ships
Fixed the name of the Jhu'ael Tactical Carrier Warbird. When I removed abbreviations a few weeks ago, a careless find-and-replace had turned it into "Jem'Hadaruael Tactical Carrier Warbird" :P
77
30 Jun 2022Fixed "Current Filter" counter in cell B1. It was always 1 too low - not sure how long it's been like that, probably just since either the Cniderian or the Acheron was added.
78
28 Jun 2022Added Cnidarian Defender
Also I realized today that the name abbreviation changes from 23 June will make your next Import rough, if you use that feature.
I'd recommend sorting both your old and new list alphabetically, and just copy column A manually. Then shift it to account for new ships. This is a one-time-only issue.
79
23 Jun 2022Added Acheron Terran Dreadnought Cruiser
Updated all wiki links to use fandom instead of gamepedia. They redirected anyway so I'm not sure it mattered, but whatever :)
Removed almost all abbreviations that were used in the Name column (WB, BOP, MM, Dread). I believe the only one remaining is MW for Miracle Worker.
- Surprisingly, this had almost no impact on the total width of that column. The widest name before was the L-Intrepid, which lost its MM abreviation but gained one for MW.
- There are still abbreviations throughout the Bundles, Mastery Packages, Traits, and probably other places that I do not plan on changing at this time.
80
08 Jun 2022Added "Carried Away" Mudd's Choice bundle
Changed the "Source" value for all Mudd's Bundle ships to "C-Store (Mudd)". Note that all of these are also still available through their original source, which is still in the "Orig Source" column
Changed the "Source" value for the Miradorn Raider and Mirror Engle to "C-Store (Bundle)". Both are also still available through Lockboxes, which is still in the "Orig Source" column
Fixed seating on Saturn and United Earth Defense Force Vessel. Saturn's ensign seat fixed from "Sci" to "Uni". UEDFV's Eng seat fixed to have Cmd spec.
Fixed mastery package on Laeosa, Fleet Laeosa (fixed "Science Vessel" to "Science WB"), Dineas, and Fleet Dineas (fixed "Destroyer" to "Tactical WB")
81
02 Jun 2022Added Sh'vhal Temporal Science Spearhead
82
19 May 2022Added Legendary Caelian Intel MM Explorer
83
11 May 2022Added California MW Utility Cruiser
Added columns for highest Tac, Eng, Sci, and Uni seats
Added "Full" column, which declares when a ship is full-spec. That information was already available, but not it's easier to filter on.
This is my favorite change in a while - added text above the Name column stating how many ship match the current filters.
84
8 Apr 2022Added Legendary Jem'Hadar Vanguard Pilot Attack Ship
85
31 Mar 2022Added Merian Command Science Dreadnought
Fixed some information around non-science Carriers. Namely:
- all Tactical Carriers are now correctly listed as having Subsystem Targetting,
- the Hur'q Vedcrid Hive Dreadnought Carrier now shows the correct Mastery Package (Tactical Carrier, despite having an Engineering commander seat. Weird.)
86
14 Mar 2022Added Admiralty Card information to all ships.
Note that the text I added does not always match the text in-game 100%. I standardized some inconsistent spacing and spelling, and made sure that careers were always listed in a consistent order (Eng then Tac then Sci)
Huge thanks to u/wkrick for also taking this on. If you haven't seen it before, they've written a web app that uses the data from this table - you can check it out here
87
10 Mar 2022Added "Lost in the Delta Quadrant" Mudd's Choice bundle
Added S31 Intel Dreadnought Cruiser
Corrected the Metaphasic Shield Array in the Small Craft tab
88
16 Feb 2022Import tab is finally here!
In the Ships tab, Column A exists for you to mark ships for whatever reason you want. I personally use it for marking the ships I own, or the ships I'm interested in. That sort of thing.
But when I update the spreadsheet and you make a new copy of it, you lose all those markings and have to copy them over again.
The Import Tab makes this easier. Try it out, and let me know if you see any problems.
89
Compare tab is also here!
Click the dropdowns in the top row and give it a try!
Columns will be cleared out if you delete the Name from the top row.

Note that a couple values that are color-coded in the Ships tab are not color-coded here yet. I'll be adding support for some of these (Source and Mastery Package are the priorities)
90
Took another pass at the centuries in the recently-added "Origin" column
91
Also corrected that the cloak on the Adamant is a Battle Cloak
92
13 Feb 202212th Anniversary Bundle added
93
Removed asterisks from entries in the Family column that included a Legendary ship. (The original intent was to make it obvious which families you could easily get every trait/console/skin by buying one legendary. But the addition of new ships to these families has made that less true.)
Removed asterisks from entries in the Faction column that represented ships that previously could not be acquired by other factions (Cross-faction flying makes those obsolete)
94
Corrected entries in the Mastery Package column that said "Dreadnought". The correct name for that package is "Dreadnought Cruiser"
95
Removed gray fill color from cells containing the word "No". The green "Yes" values pop well enough without needing the extra gray.
96
30 Jan 2022Two new columns:
- Release Date: date the ship was first available on PC
- Original Source: how the ship was first able to be acquired
97
23 Jan 2022Added "Original Copy Updated" feature above
98
Added Small Craft tab on a whim - the table in the wiki is missing some information, which is why you'll see some blank cells in the Mobility section.
99
11 Jan 2022Mudd Bundle Filters updated! In your copy of the spreadsheet, Fliter the Source column (C) to show only Lockbox, Lobi, and Promo ships. Then sort by the Bundle(s) column (D).
You'll get all the ships in Mudd's Choice Bundles grouped together :)

I also added the Origin column (G) recently, which is supposed to filter by the ship's in-universe species. I think I still have some mistakes in the centuries for the various future ships. Will take another pass at that eventually.
100
31 Oct 2021Added "Cruiser Command Analysis" columns to the far-right.