The purpose of this table is to help you rapidly develop small settlements for your fantasy TTRPGs sessions by rolling a bunch of dices with different attributes assigned to each roll.
The spreadsheet is setting-agnostic, this means that it can be used and tweaked for most settings but is still designed for fantasy worlds. There are some supernatural elements that can be triggered after all but there is nothing overly specific that wouldn't work in most settings with a degree of realistic demographics in them. Feel free to copy it and tweak it with elements specific to your setting!
The tables are supposed to to be used as inspiration for settlements from the size of a just a couple of buildings to small towns with around one thousand inhabitants. For bigger towns and cities, I would suggest designing the settlement with your specific capaign in mind, even for solo play..
The Landscape table and the "Why the settlement was formed?" table can contraddict each other if both are taken too literally in some combinations. My suggestion is to be inspired by the contraddiction and use it as a tool to create a unique gimmick. For example a camp of nomads working together for the sake of extracting a particular resource might be interested in a wild, rare and impossible to harvest plant that periodically grows in always different area of the same steppe.
Subrolls tables are there to help you get something in the end without much thinking, but they're not mandatory by any means as any other table.