CreateSpreadsheet

garyo edited this page Dec 13, 2014 · 1 revision

Create New Spreadsheet Content

Follow the instructions either under update an existing spreadsheet in place or prepare a new spreadsheet to accomplish the indicated goal.

Update an Existing Spreadsheet in Place

!inline pages="/CSV" quick="yes" raw="yes"

Upload the New Content

  • Open the spreadsheet to be updated. Make sure you are logged in as a r/w user.

  • From the "File" menu, select "Upload new version...".

  • On the pop-up requestor, select "Browse" and choose the CSV file you just created. !inline pages="/Tweak" quick="yes" raw="yes"

  • You're done! Wasn't that easy?

Prepare a New Spreadsheet

!inline pages="/CSV" quick="yes" raw="yes"

Upload the New Content

  • Go to Google's upload page.
  • Select "Browse" and choose the CSV file you just created.
  • Choose a name for the spreadsheet if needed.
  • Push the "Upload File" button to upload the file and display the new spreadsheet. The read-only URL for this spreadsheet is now in your URL selector box. !inline pages="/Tweak" quick="yes" raw="yes"

Get the Read/Write Link

  • Push the "Share" tab.
  • Tick the checkbox beside "Anyone can view this document" and then SIT ON YOUR HANDS until it responds (up to a minute!).
  • Enter your own Google account in the "Invite people" box and then click the "Invite Collaborators" button.
  • In the pop-up pane, fill in the message box as you see fit and click the "Send Invitation" button.
  • In short order, you should receive mail from Google with the read-write link. Publish the read-only and read-write links as you see fit.
Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.