CONNECTED TECHNOLOGY. CLEARLY EXPLAINED.
Home network and device inventory
Keep a manual record of exact devices, versions, network roles, service dependencies and open questions in an editable two-sheet workbook.
Practical resource · By Admin · Version 1.0 · Reviewed 20 October 2026.
A household system becomes easier to understand when the next person can identify what is connected, which version it runs and who maintains it. This workbook starts blank. It records what you enter; it does not discover devices or assess the security of a network.
Download the device and network inventory XLSX · v1.0 · 9.7 KiB
Two worksheets: Device inventory with 30 prepared device rows, and Network map with 20 prepared network rows. Includes editable cells, status choices, filters, frozen headers and date formats. No macros or external data connections are included.
Make the system understandable
Identify the exact device
Use an internal device ID and record the model or variant, firmware, room or role, app/service and relevant support source. A familiar product name does not identify its exact configuration.
Connect the two records
Give each network or connection segment an internal Network ID. Use the same ID on each relevant device row, and record any hub/controller by its device ID. Matching these IDs is a manual review task.
Record responsibilities without secrets
Use an owner role such as household administrator or facilities contact. Keep passwords, recovery codes and private account identifiers in a suitable separate system, outside this inventory.
Build and maintain the record
1 · Map the networks
Start on Network map. Identify the connection type, exact router or gateway, responsible role and known internet dependency. Describe offline behavior you have observed, or leave a clear open question. Record the last checked date.
2 · Add one device per row
On Device inventory, record the internal device ID, exact model, network and hub/controller IDs, firmware, app/service and support source. Use the same ID consistently on both worksheets. A blank row means no record has been entered.
3 · Mark evidence and uncertainty
Use the evidence-status choices to distinguish Unknown, Documented, Observed, Needs review and Not applicable. Keep the source or observation context in the notes. Needs review is highlighted; the workbook does not calculate a security or compatibility score.
4 · Review after a change
Update the record after adding, replacing or resetting a device, changing a network role or updating important software. Keep a dated copy. To add more records, extend the table and copy the existing formats and validation to the new rows, then check the choices still work.
Use your own copy
Open the XLSX in a compatible spreadsheet application and save a copy you control. The pale amber cells are editable. Do not enter actual household details into a shared public copy. Your chosen spreadsheet or storage application controls how your saved file is handled.
Check your spreadsheet app
Open a copy in an XLSX-compatible app. Check the status choices, filters, frozen headers and date display before adding real records. Microsoft Excel desktop has not been tested for this release.
Version and reuse
Original IoTPapa workbook by Admin, version 1.0, reviewed 20 October 2026. Personal and internal business use with attribution is permitted. It is a manual planning record, with no network scan, automatic inventory or security certification.
Download the current version
Download the device and network inventory XLSX · v1.0 · 9.7 KiB
Two worksheets: Device inventory with 30 prepared device rows, and Network map with 20 prepared network rows. Includes editable cells, status choices, filters, frozen headers and date formats. No macros or external data connections are included.
Use the inventory in a wider plan
CONTINUE READING
Plan a useful home routine
Connect your device map to needs, control roles, privacy and recovery.
CONTINUE READING
Record a purchase decision
Use the fillable checklist before adding another device or service.
CONTINUE READING
Understand the connections
Explore routers, hubs, gateways and the roles behind a network label.