For managing a high school reunion, I would like to convert an Excel spreadsheet of contact info to an online directory.

Amy B 20 Reputation points
2026-03-28T15:51:49.56+00:00

My spreadsheet contains old data for classmates. An online directory would allow classmates to login and update their own info. This would assist in better communication for planning an upcoming reunion. However, this group is elderly so the process needs to be easy.

Microsoft 365 and Office | Excel | For home | Windows
0 comments
Answer accepted by question author
Kal-D 7,375 Reputation points Microsoft External Staff Moderator
2026-03-29T19:36:30.4733333+00:00

Hi Amy B,

Yes, this can be done, and a simpler option than asking classmates to work directly in Excel is to use Microsoft Forms.

You can create an easy form with fields like name, address, phone number, email, and reunion interest, then share a link for classmates to fill out. Their responses are automatically saved into an Excel spreadsheet that you manage behind the scenes.

For an older group, this approach is often much less intimidating because they see a simple form instead of a spreadsheet. It also works very well on tablets and iPads, which many people find easier than using a laptop.

One thing to keep in mind is that Forms is mainly a one‑way collection tool. If someone submits the form more than once, it will usually create multiple rows in Excel, so you may need to do a bit of occasional cleanup.

In short, you can keep Excel as your master list while classmates update their details through a much easier form. It is not a true online directory where each person logs in and edits an existing record, but for reunion planning it is often the simplest and most user‑friendly approach.

Please let me know if this proves useful to you, or if you would like further assistance.

I'm looking forward to your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amy B 20 Reputation points
    2026-03-28T15:56:36.5366667+00:00

    In my opinion, Excel is intimidating to some individuals who have never used it. While I love it, my experience has been that people in my age group (70s) are not comfortable. I am look for a way to easily populate fields outside of a spreadsheet format. Is this possible?

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-03-28T15:52:02.1033333+00:00

    Excel and Office for the web can help share and collaboratively maintain a simple contact list, but they do not provide a full “directory with individual logins” experience. A practical approach for an elderly group is to use a shared online Excel workbook as the directory and let classmates edit their own rows.

    A simple setup using Excel for the web and OneDrive:

    1. Create the online directory workbook
      1. Open OneDrive and select View online.
      2. Select + New > Excel workbook to create a new online workbook.
      3. Rename it (for example, “Class Reunion Directory”) by selecting the file name at the top and typing a new name.
      4. In the first row, add column headers such as: Name, Email, Phone, Address, Notes, etc.
      5. Paste or import the existing contact data from the current Excel spreadsheet into this new workbook.
    2. Share the workbook with classmates
      1. In the online workbook, select Share.
      2. Enter the email addresses of classmates who can use email and the web.
        • Alternatively, create a shareable link and send it via email or instant message.
      3. Configure sharing so that invitees can edit, so they can update their own information.
    3. Make it easy for an elderly group
      • Include simple instructions in the first worksheet (for example, a short text at the top):
        • “Find your name in the list.”
        • “Click in your row and update your information.”
        • “Close the browser tab when finished; changes are saved automatically.”
      • Keep the layout simple: one table, clear column names, large font.
    4. Allow real-time collaboration
      • Because this is an Excel for the web workbook stored in OneDrive, multiple classmates can edit at the same time.
      • Changes are saved automatically, and everyone always sees the latest version.
    5. Use the directory for reunion planning
      • Sort or filter the table (for example, by city or attendance status) directly in Excel for the web.
      • Export or copy the list into Word if needed for mail merge (for example, to create printed directories or mailing labels).

    If more advanced features are needed later (such as more structured contact management or reports), the contact data can be moved into Access, which is well suited for managing contacts and mailing addresses and can be used with Word to print form letters, envelopes, or mailing labels.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.