3 Simple Ways to Create a Shared Spreadsheet

PDF download Download Article
Collaborate on a live spreadsheet in real-time using Excel or Google Sheets
PDF download Download Article

Want to make a live spreadsheet that you can edit with other people? Creating a shareable workbook in Microsoft Excel or Google Sheets makes it easy to collaborate on important projects with friends, family, and colleagues. This wikiHow article will teach you three easy ways to make and share spreadsheets in Microsoft Excel and Google Sheets.

Things You Should Know

  • You can use Excel Online to create and share shared spreadsheets for free.
  • If you and your collaborators subscribe to Microsoft 365, you can co-author spreadsheets on your PC, Mac, Android, iPhone, iPad, or on the web.
  • Google Sheets is another free way to make shared spreadsheets that you can edit with others.
Method 1
Method 1 of 3:

PDF download Download Article
  1. If you want to collaborate on a shared spreadsheet with friends and family on the web, you can easily create a shareable spreadsheet using the free Office Online . You won't need a Microsoft 365 subscription to use this method—just a Microsoft Account. [1]
  2. You'll see it in the left panel.
    Advertisement
  3. To start from scratch, click Blank workbook . Alternatively, you can select one of the templates to get you started.
    • If you already have a spreadsheet in Excel Online, select it from the list. Alternatively, you can open it from OneDrive.
  4. Click the green Share button at the top-right to bring up a menu, then click Share on that menu.
  5. Type the email address(es) of the person or people you want to share the spreadsheet with into the "To" field.
    • By default, anyone you share with can edit the shared spreadsheet. If you don't want the people you're sharing with to have edit rights, click the pencil icon, then select Can view .
  6. This emails a link to the shared spreadsheet to each of the addresses you entered. To view and edit the spreadsheet, your collaborators will just need to click the link in the email and sign in with their Microsoft accounts.
    7. Advertisement
Method 2
Method 2 of 3:

PDF download Download Article
  1. If you've already been working on a spreadsheet and want to share it with others, open that file now. Otherwise, open Excel on your PC or Mac and select Blank workbook to create a new workbook .
    • When you share an Excel spreadsheet using this method, you can collaborate with multiple other people and see their changes in real-time. This method works best if you and the people you're sharing with have Microsoft 365 subscriptions. [2]
    • You can create and edit the shared spreadsheet using any version of Excel that supports co-authoring as long as you have a Microsoft 365 subscription, including the Excel desktop app for PC or Mac, Excel for Web (with a Microsoft 365 subscription), Excel for Android, or Excel for iPhone/iPad. [3]
    • If you or any of your collaborators don't have Microsoft 365, use this method instead.
  2. To collaborate on a shared spreadsheet, you'll first need to save it in the XLSX, XLSM, or XLSB file format. If you haven't done so already, go to File > Save As (or Save As copy ), select a file name, and make sure to choose the XLSX, XLSM, or XLSB as the file format.
  3. Before you can start collaborating, you'll first need to add your spreadsheet to OneDrive, OneDrive for Business, or a SharePoint Online library. To upload to OneDrive:
    • PC & Mac:
      • Go to https://www.onedrive.com in your web browser and sign in with your Microsoft account.
      • Click Upload at the top.
      • Select Files .
      • Select your Excel spreadsheet and click Open .
      • Close Excel.
    • Android:
      • Go to File > Save As .
      • Select either OneDrive or SharePoint Online and then tap Save .
    • iPhone/iPad:
      • If you created the file, go to File > Name , give the file a name, select either OneDrive or SharePoint Online , and then tap Save .
      • If you opened an existing file, go to File > Save as copy , and select either OneDrive or SharePoint Online .
  4. You can skip this step if you're using Excel Web or the mobile apps. To do this, click the spreadsheet in OneDrive or SharePoint Online to open it, click the "Editing" menu, and then select Open in Desktop App .
    • If you see "Protected View" at the top of the spreadsheet, click Enable Editing now.
    • You can also close the browser tab with your spreadsheet if you'd like, as it's now open in the desktop app.
  5. If you're using the desktop or web version of Excel, it'll be a button that says Share . On mobile, look for the green icon of a person with a + .
    • If you're using the desktop app and see a small menu expand, click Share… again to continue.
  6. Type the addresses of the people you want to share the workbook with into the field at the top.
  7. By default, everyone you share with will have permission to edit the spreadsheet. If you'd rather recipients only be able to view the spreadsheet, click or tap the pencil icon and select Can view instead.
  8. This shares the spreadsheet with the selected recipients. Anyone who receives the link can click it to open and edit the spreadsheet.
    9. Advertisement
Method 3
Method 3 of 3:

Using Google Sheets

PDF download Download Article
  1. If you have a Google account, you can create a free shared spreadsheet using Google Sheets. This makes it easy to collaborate on the live spreadsheet with others.
    • Go to https://sheets.google.com in your web browser.
    • If you're not signed in with your Google account, you'll be prompted to sign in now.
    • Select an existing spreadsheet, or click Blank (or a template) at the top to create a new one now.
  2. You'll see this blue button at the top-right corner.
  3. In the "Add people and groups" field, type the names or email addresses of the people you want to share the spreadsheet with.
  4. If you want the people you're sharing with to be able to make changes to the spreadsheet, select this option from the menu. If you only want them to be able to comment or view the spreadsheet, you can choose one of those options instead.
  5. This emails a link to the spreadsheet to everyone you've added as a recipient. To view and edit the spreadsheet, recipients will need to click the link and sign in with their own Google accounts. [4]
    6. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      4 Easy Ways to Add the Time and Date Automatically in Sheets
      How to
      Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
      How to
      Use Google Sheets: The Ultimate Guide for Getting Started
      How to
      Copy the Same Text to Multiple Cells in Excel: Desktop & Mobile
      The 3 Easiest Ways to Sort by Number in Google Sheets
      How to
      Add Custom Calculated Fields to Pivot Tables in Excel
      How to
      Add Rows to a Pivot Table
      3 Easy Ways to Get Rid of Dotted Lines in Microsoft Excel
      Easily Embed Documents and Files in an Excel Spreadsheet
      How to
      Change the X Axis Scale in an Excel Chart
      How to
      Make a Google Spreadsheet: Beginners Guide
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      How to
      Add a Row to a Table in Excel
      How to
      Change an Excel Sheet from Read Only
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-gb/office/edit-in-real-time-with-friends-and-family-ec46367f-ec02-4896-bf2b-3ecd7db77697
      2. ↑ https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534
      3. ↑ https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104
      4. ↑ https://support.google.com/docs/answer/9331169?hl=en

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 314,595 times.

      Reader Success Stories

      • Pam Thomas

        Sep 18, 2016

        "Was not wanting to VPN into my sister's PC just to work on a shared file. I am now working from home and will ..." more
      More reader stories Hide reader stories
      Share your story

      Is this article up to date?

      Advertisement