NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping  →
SheetSteps
Google Sheets tutorials›Collaboration›Create a shareable link
Google Sheets · Verified tutorial

Create a shareable link in Google Sheets

Create a shareable link in B2. Enter exactly =REGEXREPLACE(A2,"/edit.*$","/edit?usp=sharing"). Do not change the spreadsheet URL in A2.

Verified by PhilisAbout 60 seconds
Quick answer

Create a shareable link in B2. Enter exactly =REGEXREPLACE(A2,"/edit.*$","/edit?usp=sharing"). Do not change the spreadsheet URL in A2.

Step-by-step

1

Select the targetCreate a shareable link in B2.

2

Apply the changeEnter exactly =REGEXREPLACE(A2,"/edit.*$","/edit?usp=sharing").

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

B2 contains the standard Google Sheets sharing-link form of the URL.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select B2 and repeat the final action. B2 contains the standard Google Sheets sharing-link form of the URL.

Example spreadsheet data

This is the clean fixture used for the verified run.

Spreadsheet URLShareable link
https://docs.google.com/spreadsheets/d/1SheetStepsExample/edit#gid=0

Video transcript

  1. Open the prepared Share link spreadsheet.
  2. Select the target. Create a shareable link in B2.
  3. Apply the change. Enter exactly =REGEXREPLACE(A2,"/edit.*$","/edit?usp=sharing").
  4. B2 contains the standard Google Sheets sharing-link form of the URL.

Related tutorials