Google Spreadsheet

You can import a Google spreadsheet with all worksheets without using any complicated Google authentication. You only need to enable the public share link.

  • Open a spreadsheet file in Google.
  • In the top right corner, click Share.
  • Click "Get shareable link" in the top right of the "Share with others" box.
  • To choose whether a person can view, comment, or edit the file, click the Down arrow next to "Anyone with the link."

  • Copy the link and paste it in the Google Sheet URL of the Import menu.

Adding Worksheets.

To make sure Databox downloads all worksheets you will need to add them separately by it's unique link ID.

  • Open a spreadsheet file in Google.
  • search for the gid number in the browser URL field. Select and copy it.
  • Go to the import menu of your Databox object, select import from Google and click on Add new worksheet ID.
  • Add the table name you want to use and the gid number you have copied previously.
  • Click Download & Append or Download & Replace.