Feature Request - Copy Games Results from Analysis Tab (in CSV Format?)

I started to copy my game results into an Excel just like everyone does who wants to improve at chess. And I realized that I've been copying stuff manually. So, I was wondering, if it is possible to maybe do some of this driven by a button that could copy stuff like:
- date of game
- Color I played
- result
- Link to game
- name of opposing
- name and rating of opponent
- My Accuracy
- Number of Blunders and Mistakes

in to the clipboard and maybe even use a format that would support paste in Excel?

I don't if something like this is possible but it would probably help a few people in post game analysis working with their coach.

All of this data (with the exception of accuracy and number of blunders--but you can calculate those yourself if you really want to) is available in the PGNs for the games, which you can download here: lichess.org/@/dirkster99/download Then you could import them into a database in a program like Scid, which is going to be much more useful than a spreadsheet anyway. If you really want them in spreadsheet format (you shouldn't use Excel because it's nonfree--Gnumeric and LibreOffice Calc are good alternatives), it's very easy to write a program to read the PGNs and output a CSV file. Python has a great chess library which includes a PGN library. However, I don't really see the point in storing chess games in a spreadsheet without the moves themselves, since the moves are the most important part when analyzing. Better would be to use a program like Scid as I mentioned above.

Hmm... I am a bit miffed by the "like everyone does" part, @dirkster99 :) but yeah, I guess I could do this somehow.

How do you see it? As a user menu link, like Export games:


Or as a second button in advanced search:


Maybe something else?

Also, @AsDaGo , if you need something like Scid to keep track of your Lichess games, I believe that's saying something about a feature that is missing in Lichess itself.

Could you give me some ideas on how you use Scid to catalogue and search/sort/evaluate your games in ways that are not available in Lichess?

@AsDaGo I do not need a PGN export in this case, because I am happy with a hyperlink and use lichess when I need a visualization. I do need an additional database system to keep my games. And of course, Excel is a synonym for all existing clones like Open Office. The advantage I see with CSV format (eg.: TAB separated) is that it has potential to be useful in other media and tools (eg.: Notepad++), as well.

@TotalNoob69 "like everyone does" might be a bit of an over-statement:-) I just noticed that some guy on Twitch takes notes of his games in Excel, and I was asked by a better playing friend, who also coaches children, to take these notes to enable him to coach/consult me on possible avenues towards improvement. I just thought there ought to be more coaches asking their students to take notes of the Key Performance Indicators (eg.: Accuracy) of their games. To enable a good coaching without too much additional effort for data gathering and analysis - since this can be done easily in Excel.

I am not only keeping the KPI's but also enrich the records with personal notes on why I think I lost or won, what was noteworthy in the game, and such things. So, the KPI's are really just on key part of the record.

I hope this classifiers my use case :-)

I guess an extension in the 'second button in advanced search' area would be best, because this would allow me to play a few games and then do the aftermath on a couple of games in one go.

@TotalNoob69 said in #4:
> Also, @AsDaGo , if you need something like Scid to keep track of your Lichess games, I believe that's saying something about a feature that is missing in Lichess itself.
>
> Could you give me some ideas on how you use Scid to catalogue and search/sort/evaluate your games in ways that are not available in Lichess?

I mainly use it for longer games, not necessarily just games played on Lichess (e.g., OTB games too). Of course I could use a Lichess study (and I do use studies as well), but this way I can keep the analysis on my local machine. It is also much easier to sort and search a Scid database than a Lichess study (which can only go up to 64 games). I also use it for preparing for opponents, and you can only use Lichess for preparing for opponents from games played on Lichess.

I don't think any of these are shortcomings of Lichess or features that Lichess should have. It's a site for playing chess. Studies are great, but it doesn't need to try to be a chess database as well.

@dirkster99 said in #5:
> @AsDaGo I do not need a PGN export in this case, because I am happy with a hyperlink and use lichess when I need a visualization. I do need an additional database system to keep my games.

I still don't see how that is going to help you much, but if you really want it in CSV format, it is very easy to write a script to convert it like I said. You could also count the number of blunders and mistakes and evaluate the accuracy for games that are analyzed, just make sure you include "Evaluation" when you download the games.

> And of course, Excel is a synonym for all existing clones like Open Office.

It's not and you shouldn't use it as one, but let's not belabor the point.

> The advantage I see with CSV format (eg.: TAB separated) is that it has potential to be useful in other media and tools (eg.: Notepad++), as well.

I don't see the advantage of using a text editor to view your games. And you can do that with PGN too if you want, so that's not an "advantage" specific to CSV. And I'm not sure what a tab separated CSV is, since CSV stands for Comma Separated Values.

@AsDaGo said in #6:
> I also use it for preparing for opponents, and you can only use Lichess for preparing for opponents from games played on Lichess.

If you have the games of the other player, you can merge them into a PGN (see PGN Editor) and then create an interactive lesson, which you can play against with LiChess Tools.

I understand what you mean with the local database. I have plans to integrate such a thing in LiChess Tools, but the way browsers work makes it overly complex. I am still mulling it over, but I am now thinking of a companion app that you install on your machine and it does stuff through Lichess. Not a perfect solution, though.

@dirkster99 github.com/Siderite/lichessTools/issues/1024

Well, here you go: lichess.org/forum/team-l1chess-tools-users-team/good-things-in-v243