Answers.Body: <p>The format of the file is described <a href="https://database.lichess.org/#puzzles" rel="nofollow noreferrer">here</a>. According to this, the name of the columns are: PuzzleId, FEN, Moves, Rating, RatingDeviation, Popularity, NbPlays, Themes, GameUrl.</p>
  <p>I do not know of any software to deal directly with this type of file. But (I see you're a software engineer) it's not difficult to write a snippet to convert the csv file (mainly columns FEN and Moves) to a pgn file that could be opened with any chess database manager.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-12-28T16:56:31.373Z
Answers.LastActivityDate: 2020-12-28T16:56:31.373Z
Answers.UserDisplayName: lodebari
Body: <p>Lichess publishes tactics problems which can be <a href="https://database.lichess.org/lichess_db_puzzle.csv.bz2" rel="nofollow noreferrer">downloaded from database.lichess.org</a>.</p>
  <p>The file is in csv format. Which software can be used to read and play positions from this csv file?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-01-02T11:45:50.297Z
Comments.Text: lichess can do it itself if you have the game id - i didn't look into the csv  - it would be good if you add an example line to your question - i assume the game id is one of the columns. I also created an opensource python frontend http://lichess.bitplan.com/ which you could use as a basis for further work on this.
Comments.UserDisplayName: Wolfgang Fahl
Tags: <software><tactics><lichess>
Title: Chess tactics software which can read files
ThreadText: # Chess tactics software which can read files
  
  (Asked by: username_0 on 2020-12-26)
  
  Lichess publishes tactics problems which can be [downloaded from database.lichess.org](https://database.lichess.org/lichess_db_puzzle.csv.bz2).
  
  The file is in csv format. Which software can be used to read and play positions from this csv file?
  
  **Tags:** software, tactics, lichess
  
  > **Comments:**
  > **username_1**: lichess can do it itself if you have the game id - i didn't look into the csv  - it would be good if you add an example line to your question - i assume the game id is one of the columns. I also created an opensource python frontend http://lichess.bitplan.com/ which you could use as a basis for further work on this.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2020-12-28. Score: 1
  
  The format of the file is described [here](https://database.lichess.org/#puzzles). According to this, the name of the columns are: PuzzleId, FEN, Moves, Rating, RatingDeviation, Popularity, NbPlays, Themes, GameUrl.
  
  I do not know of any software to deal directly with this type of file. But (I see you're a software engineer) it's not difficult to write a snippet to convert the csv file (mainly columns FEN and Moves) to a pgn file that could be opened with any chess database manager.
  
  
  ---
  
  