Skip to main content

How to Create an Excel Workbook in a SharePoint Document Library

· 4 min read
Jagdish Kumawat
Founder @ Dewiride

A workbook made in a SharePoint document library belongs to the team, not to one person's OneDrive. You don't need to make it on your computer and upload it: the library's Create or upload menu creates a blank workbook in place and opens it in Excel for the web.

The example creates a workbook called Team Budget in the Documents library of a SharePoint site.

Step 1: Open the Library​

Open the SharePoint site and the library, here Documents. If the workbook should go in a folder, open the folder first (How to Create a Folder in a SharePoint Document Library).

Step 2: Select Create or upload, Then Excel workbook​

Select Create or upload, then Excel workbook:

The Create or upload menu with Folder, Files upload, Folder upload and Word document, and Excel workbook outlined in red above PowerPoint presentation

A new tab opens with a blank workbook in Excel for the web. Microsoft's Create a new file in a document library says Your new file is automatically saved to the document library and has a generic file name. Mine was called Book.

Step 3: Give It a Name​

Select the name, Book, at the top of the page, type the new one, here Team Budget, and press Enter (How to Rename an Excel Workbook in Excel for the Web):

The top of Excel for the web with the name box open showing Team Budget, next to the cloud icon

The cloud with a green tick next to the name means the change is saved:

The top of Excel for the web showing Team Budget as the workbook's name, next to a cloud icon with a green tick

The Result​

Back in the library's tab, after a refresh, Team Budget.xlsx is in the list:

The Documents library listing the Scripts folder and Team Budget.xlsx, modified A few seconds ago by Admin User

Everyone who can open the library can open the workbook, and Power Automate can find it by its library and name.

Common Mistakes​

MistakeWhat happensDo this instead
Leaving the generic name BookNew workbooks are hard to tell apart in the libraryRename it as soon as it opens
Creating it in your OneDrive and sharing itThe file lives in your OneDrive, not with the team's filesCreate it in the team's library
Looking for a Save buttonExcel for the web saves as you goCheck the cloud icon next to the name

Troubleshooting​

SymptomLikely causeFix
Excel workbook isn't on the menuThe library offers only the file types its owner has set upAsk the site owner
The workbook isn't in the listThe library's tab hasn't refreshedRefresh the browser
Others can't edit the new workbookMicrosoft's article says a library that requires check-out leaves a new file checked out to youCheck it in

FAQ​

Can I rename it from the library instead?​

Yes. Microsoft's article: select ... (Show more actions) next to the file, then Rename, enter a name and select Rename.

Do I have to close the tab to save?​

No. The workbook saves itself; switch back to the library's tab when you're done.

Can I create Word or PowerPoint files the same way?​

Yes: Word document and PowerPoint presentation are on the same menu.

Conclusion​

Create or upload → Excel workbook creates a blank workbook in the library and opens it in Excel for the web. Rename it from the top of the page, and it's saved to the library as you work.

Additional Resources​