/Copy URL Trick

Andrew Kamphey -

Picture this: You want to share your Google Sheet with someone else.

So you copy the link. Paste the link. And tell the other person the whole step-by-step of how to open the sheet, go to file > Make a Copy.

That sucks.

That's just awful for everyone. And a lot of typing.

There's a better way!

​

Add /copy to the end of the url.

BUT! You gotta take the non bits off the end first.

There's an even BETTER way!

​

BETTER SHEETS FIXED IT

Yeah that's right.

I fixed this whole process for you.

Take your url, go here, and paste it: BetterSheets.co/copy​

The new url with the /copy already added will be added to your clipboard.

You don't even have to hit command + C!

You can paste it now in your email to your friends, your boss, your coworkers, your employees, your VAs. anyone.

For example

This week I made a "My Barbie Checklist" spreadsheet I want to share with others:

​https://docs.google.com/spreadsheets/u/2/d/1O8pOWRuroI4tnpasNN2MXfVeG-gqCYeYJOU1f7zOPwM/edit#gid=0​

Now I go to BetterSheets.co/copy, paste the url.

voila!

You can copy the sheet with this link:

​https://docs.google.com/spreadsheets/d/1O8pOWRuroI4tnpasNN2MXfVeG-gqCYeYJOU1f7zOPwM/copy​

Benefits:

👍Convenience

Eliminates the need to manually edit URLs for sharing Google Sheets.

👍Efficiency

Saves time by automating the process of generating a copyable link.

👍 User-friendly

Provides a straightforward solution for sharing and copying Google Sheets.

Use Cases:

Collaboration

Share Sheets with coworkers. Enables them to easily make their own copies.

Education

Teachers can quickly distribute worksheets so students can easily duplicate

Data Collection

Researchers can share Sheets so each participant has a copy.

Types of People who could benefit:

Professionals

Project managers, consultants, or business owners who frequently share Google Sheets/

Educators

Teachers, instructors, or trainers who share educational resources

Researchers

Professionals conducting surveys, or collecting data

Make Sweet Sweet URLs with /copy at the end

Take your url, go here, and paste it: BetterSheets.co/copy

Share your sheets.

And then make sure your sheets are filled with awesomeness!