How to Share a Google Sheet with Everyone

Author: Iqbal | Guide: Google Sheets |

URLs or links are one of the best ways to share Google sheets with everyone.

Obviously, if you are working for an organization or a team, then you will require to share the Google sheets with the data with a certain number of people. For that, you must know the correct and the most convenient way to do so. Apart from that, you can also save Google sheets as PDF and then share them. This article revolves around sharing Google sheets in just 6 easy steps.

Google Sheets - Share Your Spreadsheet With Others

Share Google Sheets With Everyone in 6 Steps

Step-1 Open The Google Sheet to Share: It can not be more obvious that you have to first open the Google sheet that you want to share with other people.

It's your wish and you can open it on any of the devices that you want like your PC, Tablet Laptop or mobile phone.

Image titled Share google sheet with everyone step-1

Step-2: Tap On the 'file' Tab: The next step of this technique is to click on the 'File' tab from the top left side of your spreadsheet.

Image titled Share google sheet with everyone step-2

Step-3 Click on 'Share': The 'File' tab of Google sheets contains various options like:

  • New
  • Open
  • Import
  • Make a copy
  • Share
  • Email
  • Download
  • Rename, etc

All these options in the File tab are related to that particular Google file only. So, from here you how to select the option that says 'Share'.

Image titled Share google sheet with everyone step-3

Step-4 Click On 'Share With Others': From the two given options:

  • Share with others
  • Publish to web

Click on the first option that are 'Share with others.

Image titled Share google sheet with everyone step-4

Step-5 Tap On 'Change to Anyone With The Link': A panel with the title of 'Get link' will now open up on your screen. At the bottom of this panel you will find the option that says 'Change to anyone with the link'.

Just click on this for now.

Image titled Share google sheet with everyone step-5

Step-6 Click On 'Copy Link': Now, you can simply tap on the 'Copt link' button from the right side of the link which is in green colour.

After copying, you can share the Google sheet with anyone by sharing this link.

Image titled Share google sheet with everyone step-6

FAQ

How Can I Share a Google Sheet Publicly?

Link helps you to share your Google sheet with only those people that you want. But, there is also another option that helps you to share your Google sheet in public. To share your Google sheet publicly:

  • Open that particular Google sheet.
  • Then, upload the sheet to your Google drive.
  • Then, click on the blue 'Share' button on the top right-hand side of your chosen Drive file.
  • Click on 'Advanced' at the bottom right side of the page.
  • Then, simply select the 'Change' option.
  • You will now be able to see various options for sharing the link.
  • Choose 'Public' on the web option.
  • Finally, choose 'Save'.

Can Multiple People edit The Same Google Sheet at the Same Time?

When you share your Google sheet with a number of people, then there is a high chance that two or more people want to edit the sheet at the same time.

You do not have to get worried about that at all. Because Google sheets allow up to 10 people to edit one sheet at the same time. You can also share Google sheets on WhatsApp.

Similarly, talking about Google Docs, a total of 50 people can add the Google document at the same time.

Is It Possible To Share a Google Sheet as a Read Only File?

If you are sharing your Google sheet with a large number of people or sharing it publicly, but do not want them to alter any data in the sheet. Then, you must share it as a read-only file.

To share your google sheet as a read-only file, the following steps can help you:

  • Go to your Google sheet file or document.
  • Then, click on the 'Share' button.
  • After choosing the people with whom you want to share the file, click on the drop-down menu on the right side.
  • Then, select 'Viewer'.

Now, they would not be able to edit the sheet.

 

 

 

 

Another Method 

Are you thinking that you will have to share google sheets with everyone for an upcoming project but do not know how? Well, you are in the right place. It is very normal to share a google sheet with everyone as it actually is a group platform for various needs. Everyone can work on it together, update it, edit it, add comments, add rows and columns and make your work easy and lively. So, let us look at the following steps and get you started.

Share a Google Sheet With Everyone: 6 Steps

Step-1 Open Google Sheets Application: Firstly, on your mobile device, look for a green paper icon. It has a slight fold from the top-right corner. It has a white square over it divided into four equal cells. That icon is your Google Sheets application icon. Cannot find it on your phone?

  • Then go to play store and type google Sheets in the search bar.
  • Look for the icon as described above.
  • Once you find it, download it and let it install.

Thus, you will be ready to use the Google Sheets application.

 image titled Share a Google Sheet with Everyone step 1

Step-2 The Three-Dot Icon: On opening the google sheets application, you will see a list of sheets that you have created. Select the sheet that you want to share with everyone. Or you can create a new sheet too.

  • On opening the desired sheet, you will see a three-dot option on the top-right corner of the document.
  • It will look like a broken vertical line.
  • By clicking on that, a drop-down menu will appear in front of you.

image titled Share Google Sheet with Everyone step 2

Step-3 Click on Details: In the drop-down menu there are many different options. To share a google sheet with everyone, click on the details option. It is just above the help and feedback option.

 image titled Share a Google Sheet with Everyone step 3

Step-4 Click on Not Shared: Basic details of your google sheet are available here. 'who has access' is the last information on that page. Here you can see if it is shared or not.

  • It is not shared by default and is shown with a lock option.
  • To change this setting, click on the not shared option.
  • Thus, you are taken to the next page.

image titled Share Google Sheet with Everyone step 4

Step-5 Click on Restricted: You will see the owner's information on top of the next page. Below that there is an option for link settings. It will show as 'restricted' beside the people icon. You have to click on that for changing it.

 image titled Share a Google Sheet with Everyone step 5

Step-6 Change the Setting: Now here click on the restricted, you will go to the next page where you will have to click on restricted again. As a result, you will be at a page from where you can share a google sheet with everyone.

  • On that page, the blue tick will be on 'Restricted.'
  • You have to tap on 'anyone with the link' just below that.
  • To clarify, it will take a few moments before you will see the option of 'anyone with the link' on your screen.
  • By going back to the details page, you will see that there will be a world globe icon in place of the lock icon as a result of the change.
  • Thus, you can share a google sheet with everyone now.

share a google sheet with everyone

So, share your google sheet with anyone like this. You can share it in any format you like. The easiest option is to just copy the link and send it to anyone you want. Isn't it easy? So, what are you waiting for? Start your group task now and meanwhile also share the google sheet with your peers.

 

Was this article helpful ?

No