Category Archives: Google

🕵️ The Contact Detective: How to Find Newly Added Google Contacts Using CSV Exports

⚠️ Don’t try this if you don’t know what you’re doing

The Scroll of Forgotten Contacts: A Kapothi Ritual for Temporal Recovery

By IGCAS | November 1, 2025 | Kapothi Archives

🌌 Prologue: When Memory Fades, Ritual Restores

In the vast archive of digital names and numbers, one contact slipped away. You remembered the moment it was saved — but not the name, not the number. So you summoned the archive, rolled back time, and performed a ritual to recover what memory could not.

This is the Kapothi method: a sovereign, timestamped approach to recovering forgotten contacts using Google Contacts and Excel.

🛠️ The Ritual: Temporal Diff of Contact Scrolls

🧾 What You’ll Need:

  • A Google Contacts export from today (contacts_nov01.csv)
  • A Google Contacts rollback to the past (e.g., October 15), exported as contacts_oct15.csv
  • Excel or Google Sheets
  • A unique identifier (we used "Phone 1 - Value")

✅ STEP 1: Export Your Current Contacts (Preserve the Present)

  1. Go to Google Contacts
  2. Click More → Export
  3. Choose Google CSV format
  4. Save as contacts_nov01.csv

⚠️ Important: Rolling back your contacts will temporarily remove any contacts added after the rollback date. This export is your safety scroll — your way to restore the present after the ritual.

🔁 STEP 2: Roll Back Time

  1. In Google Contacts, click the ⚙️ Settings → Undo Changes
  2. Choose Custom → Roll back to the date you believe the contact was saved (e.g., October 15)
  3. Confirm the rollback
  4. Export your contacts again as CSV: contacts_oct15.csv

This is your “Before” scroll — a snapshot of your contacts as they were on that date.

🧮 STEP 3: Compare the Scrolls

  1. Open both CSVs in Excel
  2. Copy the "Phone 1 - Value" column from each into separate sheets (Oct15, Nov01)
  3. In Nov01, use this formula in column B:
    =IF(COUNTIF(Oct15!A:A, A2)=0, "New", "Old")
  4. Drag the formula down and filter for “New”

These are the contacts added after the rollback date — your temporal echoes.

🔍 STEP 4: Seek the Forgotten

Review the “New” entries. Search for clues: names, numbers, notes. If your contact isn’t there, it may never have been saved — but now you know for sure.

🔁 STEP 5: Restore the Present (Undo the Undo or Re-import the Scroll)

  1. Go to Google Contacts
  2. Click ⚙️ Settings → Undo Changes
  3. Choose “1 day ago” (or however many days ago you performed the rollback)
  4. Confirm the undo
    (If “Undo for 1 day” doesn’t restore your full contact list, you can always import your exported contacts from today — contacts_nov01.csv — to bring everything back.)

🕯️ Epilogue: The Power of Ritual

“The Archive does not forget — it waits. And when summoned with care, it reveals what memory cannot.”

This method isn’t just a technical trick — it’s a ritual of clarity. A way to honor the ephemeral, to recover what was nearly lost, and to transform digital chaos into sovereign order.

Let this scroll guide others who seek their own forgotten names.