ECO code CSV sheet

When looking for a sheet with all of the openings and ECO codes in a .csv format I couldn't find anything so I wound up making it. I know I'm not the only one using a google sheet to analyze their games.

Here is the link:
docs.google.com/spreadsheets/d/1CehtdBIt5cOkRy6mbgMJlLjvfK1StGsqiKVCkeh9uqQ/edit?usp=sharing

Hope you find it useful.

hi!

Hmm, it should not be difficult to transform a Scid Eco file to a file in CSV format. The Python standard lib even has a module called csv. Looks like an ideal fun task to dig into Python programming :-)

https://docs.python.org/3/library/csv.html

A Scid Eco file has the following format:

A00a "Start position" *
A00b "Barnes Opening" 1.f3 *
A00b "Fried fox" 1.f3 e5 2.Kf2 *
A00c "Kadas Opening" 1.h4 *
A00d "Clemenz Opening" 1.h3 *
A00e "Ware Opening" 1.a4 *
(...)
E99 "King's Indian: Mar del Plata, Benko Attack"
1.d4 Nf6 2.c4 g6 3.Nc3 Bg7 4.e4 d6 5.Nf3 O-O 6.Be2 e5 7.O-O Nc6 8.d5 Ne7
9.Ne1 Nd7 10.f3 f5 11.g4 *
E99 "King's Indian: Mar del Plata, Benko Attack, 11...Kh8"
1.d4 Nf6 2.c4 g6 3.Nc3 Bg7 4.e4 d6 5.Nf3 O-O 6.Be2 e5 7.O-O Nc6 8.d5 Ne7
9.Ne1 Nd7 10.f3 f5 11.g4 Kh8 *
E99 "King's Indian: Mar del Plata, Benko Attack, 11...Nf6"
1.d4 Nf6 2.c4 g6 3.Nc3 Bg7 4.e4 d6 5.Nf3 O-O 6.Be2 e5 7.O-O Nc6 8.d5 Ne7
9.Ne1 Nd7 10.f3 f5 11.g4 Nf6 *
E99 "King's Indian: Mar del Plata, Benko Attack, 11...Nf6 12.Nd3"
1.d4 Nf6 2.c4 g6 3.Nc3 Bg7 4.e4 d6 5.Nf3 O-O 6.Be2 e5 7.O-O Nc6 8.d5 Ne7
9.Ne1 Nd7 10.f3 f5 11.g4 Nf6 12.Nd3 *

Scid ECO files are shipped with (guess what) Scid. You can download them from here (also in french and spain available):
https://sourceforge.net/p/scid/code/ci/master/tree/scid.eco

this is good stuff, thanks for the shares!

@selfbrain the purpose of this is I use a google sheet to analyze my games on a large scale. With this sheet I can correlate loss percentage to the opening that was played. I’ve learned I never win against some forms of the English.

Another way to go is to use https://www.chess-poster.com/english/openings/chess_eco_codes.txt, and write a couple lines of code to convert it into you desired csv format.

Alternatively, if you want a ready-made csv openings file, you can use something like this - https://github.com/tomgp/chess-canvas/blob/master/pgn/chess_openings.csv.

Hope this helps :)

@boilingFrog lol I’ve already done the work. That’s what the sheet is. I put it out there so everyone else could use it. I’ve already put it in csv format

@randywolf244 against English, try the line c4 e5 Nc3 Bb4. Vishy Anand played some interesting games with it.