Why would you want to make a home inventory spreadsheet?
The rationale is of course simple, the best examples are probably the times where you can use a home inventory list to claim insurance when an unfortunate fire has happened or burglars has came and gone. Another way is to make it easier for you to replace items that have been damaged or misplaced and need to be replaced. This can happen for any number of reasons.
To create one, the first thing you would need to do is to get a template, a sample inventory report or a sample inventory sheet. Either of this would be helpful, if you can get a sample home inventory spreadsheet, all the better as this makes for less work that you actually have to do on the spot. Having one of the above your next step would be to do some modifications.
Using one of the templates or sample above, you would then look at it to see if it is usable for your needs. If it is inadequate in some way, then it needs to be remedied. The following pictures shows an example of how it can be done and what might be a possible ideal out come for you. This allows you to modify your sample inventory sheet to suit your needs.
From this sample output, you should now have a better idea of what it is you can do with the items at your disposal. Possible amendments and extensions could include:
Serial Number or Receipt number of the inventory item. This might help when you want an exact duplicate, or intend to claim a warranty or replacement.
You might want to go one step further from their physical location, and group them under an additional category. For example, all the forks and knives and spoons can go under cutlery or utensils.
Remember to save and backup your home inventory spreadsheet regularly, you never know what might happen.