I've kept gift logs for years but my system just broke down when I tried adding 12 nieces and nephews lol. I'm super hyped to overhaul this!
I need to track:
Should I go full Excel data nerd or stick to my trusty notebook?
Honestly, once you hit that double-digit count for nieces and nephews, the notebook becomes a liability. For the requirements you listed—specifically URL storage and mobile access—a cloud-based spreadsheet or a database tool is basically the only logical move. I have been managing a similar list for years using a structured sheet because you cant click a link on a piece of paper, and copying long URLs by hand is just a recipe for broken links. A spreadsheet handles the data integrity better. I generally set up columns for Item, Recipient, Price, Store Link, and a dropdown for Shipping Status. For the link gathering part, using something like the Amazon Wishlist Chrome Extension is a decent option to streamline the data entry if you do most of your shopping there, as it pulls data into a list format pretty easily. Mobile access is native with the Sheets or Excel app, so checking your budget in a physical store works fine. Before you build out the whole grid tho, I have a couple questions about your specific needs. Are you looking to maintain historical data to avoid repeating gifts from previous years, or do you just need a temporary tracker for the current season? Also, are you looking for a system that can handle automated price tracking, or is manual data entry okay for your workflow?
Unfortunately, mobile spreadsheets are kinda clunky for data entry. I've had issues with the UI being frustrating when you're actually out shopping. @Reply #2 - good point! But to help you more:
Saw this earlier but just now getting to it. I've built several gift trackers over the years and notebooks always hit a scaling ceiling. I eventually moved to a structured sheet because tracking URLs on paper is basically impossible.