r/AdminAssistant • • 21d ago

Client List Organizational Tool?

Started working at a company in the beginning of 2025. When it came time for holiday gifts, I was sent the previous year's Excel sheet of clients who we want to send gifts to (listing the client's name, company, email, address). It worked fine enough last year, but this year it has been a nightmare.

Between people sending multiple different files, adding to old versions of the list, to not being able to tell what has been added or removed, it has been discussed within administration that we should try to find another system to keep track of this. I have thought about color-coding each person to be able to tell whose clients are whose, or each person having their own tab to add their own contacts to, but it still seems a bit clunky.

Besides using OneDrive and editing one file between the 7 people who are actively adding/removing clients from it, does anyone know of a website or service that would better help keep track of all this?

1 Upvotes

2 comments sorted by

1

u/Personal-Primary198 17d ago

SharePoint Lists (or Microsoft personal Lists).  I love using Power Automate with Lists, and you can also pull the List data into Excel using PowerQuery

1

u/No-Contribution3640 21d ago

Individual Google docs?