How to download the FIAS database for a specific region?

Question

Python

Everything is needed in XLS format, preferably in python

Answer 1

DBF is divided into regions, and XML is all in one file (7+ gig uncompressed). I did loading from DBF because it's easier that way. data.nalog.ru/Public/Downloads/20190919/fias_dbf.rar
In DBF, each ADDROBJ table for one region weighs 50 meg, with house data - 4 times more, although in fact most of it is archival data.
I'm not sure at all that excel is capable of chewing this. Better some kind of database engine with indexing.

from dbfread import DBF
table = DBF("ADDROB77.DBF",encoding="cp866")

for row in table:
    for i,coll in enumerate(table.field_names):
        print("%d %s = %s"%(i,coll,row[coll]))
    break#только первая строка для теста

Well, one by one you write the line file to the excel file, you can also read the status codes from other DBF tables