From time to time I get people asking me about sharing a Numbers spreadsheet with somebody
that's say on Windows and using Excel.
People automatically think well I can go to Export and Export to Excel.
Send them an Excel document and they work on it and send it back to me and I have to
Import that into Numbers.
Go back and forth and it seems rather clunky.
It is.
Especially since Excel really doesn't work with multiple tables per sheet in the way
that Numbers does and all of that.
A much better way to share your spreadsheet with somebody that's either on Windows and
uses Excel or maybe for some other reason doesn't have Numbers or just about any platform
that they're on is to share it using the Collaborate feature.
So here I've got a sample Numbers spreadsheet.
I'm going to go and Save it and I'm going to save it to my iCloud Numbers folders although
you don't necessarily have to.
Once I Save it I'm now going to go and turn on Collaboration.
This will allow other people to see and edit the document.
So I'm going to click on Collaborate and I get to turn on Share Options here.
So I'm not going to worry about adding people right now.
I'm just going to turn on Share Options and for this example I'm going to say Anyone with
a Link can actually view and edit this.
But I'm also going to add a password.
So I'm going to go in here and add a password and I'm going to Set it.
So now this is a password protected sheet.
So sending this to somebody it's now as insecure as you might think because they need the password
to get in.
But by not using the People I Invite means they don't have to have an iCloud account.
So Anyone With the Link and I can set it to View Only or Make Changes.
So choose which one you want.
I'm going to say they can make changes.
I'm going to hit Copy Link as the way to share with them.
Now I could do Mail and just automatically send an email message.
But I'm just going to hit Share.
Now it's going to copy the link to this in my Clipboard.
I can paste it into an email.
I can paste it into Messages.
Whatever I want.
So now this is shared.
You can see Collaborate is turned on.
It's green and all of that.
So now I'm going to show you what it looks like if somebody else gets ahold of this link.
You send it to them.
So let me go and create a new private window in Safari.
So this is a private window.
The reason I made it private is that it means I'm not logged into anything.
That's what the privacy does.
I'm not logged in.
There's no cookies.
None of that.
So it's kind of simulating if somebody on another Mac got this link.
I'm going to paste the link in.
You can see here it's iCloud.com/Numbers and then a long thing.
So this could be somebody on Windows, on Edge browser, somebody using Chrome on any machine.
They go to this link and this is what's going to happen.
It's going to load up this spreadsheet and it's going to ask them for a password.
It's that password that you created.
I'll hit okay.
Now they have access to that spreadsheet.
It gives them a little welcome message there.
It asks them for a name because it doesn't know who they are.
You haven't used an iCloud account so this person is an anonymous person at this point.
So we'll just do Test Guy and hit Join.
Great.
Then it tells you here under Shared that there's Test Guy and the original owner.
Great.
There's colors.
A little pinkish color there and a yellowish color there.
Now I can view the spreadsheet pretty much with the same functionality that you have
in Mac Numbers it's just that it's in a web browser.
I can make changes.
So I can change this 106 to 107.
Now look what happens when I go back to Numbers here.
See that 107 was updated.
The updates happen in realtime.
So I can actually move these windows around so you can see the private browser here.
So this is the other person and this is me in Numbers here.
You can see wherever I click they see in yellow.
Wherever they click I see in red and numbers can be made in realtime and reflected in both.
Now it's very instant here but, you know, somebody half way across the world with a
slower internet connection it may take a second or two for it to update.
But you know you don't have to be on.
You cannot be using this spreadsheet at all.
This can be closed.
They could access it at a completely different time.
View things.
Make changes.
Then you go back to the spreadsheet.
Open it up again and then you'll see those changes reflected there.
So it's a great way to share spreadsheets with somebody.
They don't need to have Numbers.
They don't need to have Excel.
They just basically need a modern web browser on a device and they'll be able to go and
view and edit the information.
You don't have to mess with exporting to Excel and reimporting back in.