I compiled Excel tables with list of items in The Sims 1 (took about 15 hours) and The Sims 2 (took about 50 hours). Due to large amount of work spent making these stuff, and being probably the only person (or at least the first) who made such complete database of items in Sims games, I offer the database for paid download only.
List of items in The Sims 1:
List of items in The Sims 2:
Watch video to see the Excel files you receive after payment:
In 2003 shortly after I got The Sims 1 (base game only), I created a list of items in Word (146 buy mode items and 111 build mode items). I don’t remember how long took, but probably many days, I had no internet connection, not many things to do on computer, so I wrote full description of every item in The Sims menus (314 items were in total). I was screenshoting every item in game, minimize game, paste in Paint and write in Word on half screen of 1024×768.
In 2012 I created in Excel a list of Buy / Build Mode items in The Sims 2, indicating their price and the expansion packs that add items, it took me about 50 hours to write 4500+ item names and prices, using all expansions installed, then I used AnyGameStarter to start expansions one by one and see what items are added by each one.
I considered a necessity to create this list because been playing The Sims 2 with all expansion packs installed and I wanted to know which expansion pack does add the items I am using, so I can build houses with AnyGameStarter with minimum expansion packs required. I did not included motives or description (as I did for The Sims 1) considering them unnecessary and extra effort needed.
In December 2019 I recreated list of items in The Sims 1 in Excel, this time using “The Sims 1 Complete Collection”, it took about 15 hours, in addition of this I copy-pasted the descriptions from ~350 base game items from the Word document I wrote in 2003. I did not wrote description for remaining items to save time. At same time I spent about 5 hours improving The Sims 2 list of items, adding motives and visually-enhanced table.
After finishing The Sims 2 list of items in 2012, I was thinking about making a similar database with The Sims 3 list of items, after its last expansion pack will be launched, if The Sims 2 list sells well, but this did not happened.
The work will be more complex in case of The Sims 3 than The Sims 1 and 2, because there are some items added by patches and not by expansion / stuff packs.