How To Create A SharePoint Excel File: Step-By-Step Collaboration Setup

I still remember the first time I tried sharing an Excel file with my team in SharePoint. The confusion was real, but the solution was surprisingly simple.

Creating an Excel file directly in SharePoint means your team can edit simultaneously without version chaos. It takes under 2 minutes once you know where to click.

No special permissions needed—just a SharePoint site and an Office 365 account. The file lives in the cloud, accessible from any device with an internet connection.

You’ll get real-time collaboration, automatic saving, and one source of truth for your data. Here’s how to set it up without the headaches.

What Youll Need

Instructions

Here’s the method I use to set up a shared Excel file that teams can edit simultaneously.

Open your web browser and go to your organization’s SharePoint site. I recommend using Microsoft Edge or Google Chrome for the smoothest experience. Log in with your work or school account if prompted.

Locate the document library where you want to create the Excel file. If you don’t have one set up, you’ll need to create it first by clicking New and then Document library from the SharePoint homepage.

In the document library, click the New button in the top menu bar. From the dropdown menu, select Excel workbook. This creates a blank spreadsheet directly in the library.

Wait 5-10 seconds while SharePoint generates the file. The new workbook will open automatically in Excel Online. You’ll see the familiar Excel interface with a blank worksheet ready for data entry.

Click the Share button in the top-right corner of the Excel Online window. In the sharing panel that appears, enter the names or email addresses of the people you want to collaborate with. You can also add an optional message explaining the purpose of the file.

Set the permission level to either Can edit or Can view depending on what access each person needs. For real-time collaboration, select Can edit. Click Send to notify them via email, or Copy link to share the URL directly.

In Excel Online, you’ll see colored flags representing each person currently editing the file. To ensure smooth collaboration, ask team members to use the same version of Excel (either all in the browser or all in the desktop app).

Save the file with a descriptive name by clicking in the title bar at the top. The name will auto-save to SharePoint. Verify that all collaborators can access and edit the file by checking the Shared with list in the top-right corner.

Return to the SharePoint document library. Click the three dots next to your Excel file and select Version history. This shows all previous versions of the file, allowing you to restore an earlier version if needed.

To enable versioning for new files automatically, go to the library settings (gear icon), select Library settings, then Versioning settings. Set Create major versions to Yes and specify how many versions to retain. This protects your data from accidental changes.

Tips and Common Mistakes

These insights will help you avoid the most common pitfalls when setting up collaborative Excel files in SharePoint.

Browser Selection Matters: While Step 1 recommends Microsoft Edge or Google Chrome, I’ve found Edge handles SharePoint’s integration slightly better for Excel Online. Avoid older browsers like Internet Explorer—they often cause compatibility issues with the real-time editing features.

Document Library Setup: Before starting Step 2, ensure your document library has proper permissions configured. I learned this the hard way when a team member couldn’t access our files because the library inherited restrictive permissions from its parent site.

File Generation Patience: The 5-10 seconds mentioned in Step 2 is crucial. Don’t refresh or navigate away during this time, or you’ll risk creating duplicate files. SharePoint is processing your request in the background, even if the interface doesn’t show immediate feedback.

Version History Pro Tip: In Step 5, when enabling versioning, set it to retain at least 50 major versions. I’ve needed to restore files from 3 months prior before, and having that history saved a critical project from accidental data loss.

Frequently Asked Questions

Creating a SharePoint Excel file is a breeze once you follow the steps! 🎯 By leveraging SharePoint’s collaboration features, you can streamline teamwork and boost productivity. Ready to dive deeper? Try setting up your first shared file today and explore advanced features like co-authoring and version history.