I created a sample program for retrieving article lists using the Hatena Blog AtomPub API. You can try it on the following Google Colab.

Google Colab
colab.research.google.com

After running the above program, an Excel file like the following will be downloaded.

はてなブログの記事一覧の取得例
Google Docs

The "metadata" sheet stores blog information, and the "items" sheet stores the list of articles.

Some aspects may be unclear due to the notation in column A of the "metadata" sheet, the heading rows, and the heading rows of the "items" sheet (which are designed for connection with other applications), but I hope this is helpful when using the Hatena Blog AtomPub API.