{"product_id":"address-book-contact-list-spreadsheet","title":"Address Book Spreadsheet","description":"\u003cp\u003eThis address book spreadsheet keeps the people in your life in one list, with their phone, email and address, the group they belong to and the last time you were in touch. It is for anyone who wants a family organizer for contacts that also notices when a friendship has gone quiet.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eKeep in touch, not just keep numbers\u003c\/h2\u003e\u003cp\u003eYour phone knows every number you have. It does not know who you have quietly stopped speaking to. Type the date you were last in touch, and the file works out the days since. Once that passes a year, the row turns red and is counted on the dashboard.\u003c\/p\u003e\u003ch2\u003eWhat the contact list does\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e300 contacts with phone, email and address\u003c\/li\u003e\n\u003cli\u003eGroups from a drop-down, so the counts stay accurate: family, friends, work, neighbors, school, medical, trades and clubs\u003c\/li\u003e\n\u003cli\u003eLast in touch and the days since, with anyone past a year shown in red and counted\u003c\/li\u003e\n\u003cli\u003eBirthdays this month, counted from the same list, so it works as a birthday list without a separate calendar\u003c\/li\u003e\n\u003cli\u003eA card list column with its own count, so the holiday card list is ready every December\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eFive connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e walk you through getting started in a few minutes\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eContacts:\u003c\/strong\u003e the main list everything else reads from\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTasks:\u003c\/strong\u003e anything the contact list does not cover\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e group counts, birthdays this month, card list count and who you have not spoken to in a year\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA filled example and a blank copy\u003c\/h2\u003e\u003cp\u003eThe example copy holds 48 contacts across eight groups, with six birthdays this month and ten people nobody has spoken to in a year. The blank copy is ready for your own contacts.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel workbooks: the filled example and a blank one\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready the moment payment clears, for personal and business use on your own devices. Please do not share or resell them. Questions? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The Excel workbooks run on Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow many contacts does it hold?\u003c\/h3\u003e\u003cp\u003e300 contacts, each with phone, email and address, a group and a last in touch date.\u003c\/p\u003e\u003ch3\u003eHow does it show who I have lost touch with?\u003c\/h3\u003e\u003cp\u003eIt counts the days since the last in touch date you enter. Anyone past a year turns red and is counted on the dashboard.\u003c\/p\u003e\u003ch3\u003eCan I use it for my holiday card list?\u003c\/h3\u003e\u003cp\u003eYes. There is a card list column with its own count, on the same list as everyone's address.\u003c\/p\u003e\u003ch3\u003eDoes it track birthdays?\u003c\/h3\u003e\u003cp\u003eYes. Birthdays this month are counted from the same contact list, without a separate calendar.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597869973598,"sku":"OPX-174","price":18.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/address-book-contact-list-spreadsheet-01.jpg?v=1790832918","url":"https:\/\/opxviashop.com\/products\/address-book-contact-list-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}