Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Purpose: For offices that use Google Sheets, this guide shows how to upload and open a report downloaded from OR PTC DCI into Google Sheets.

Outcome: Staff can upload and open a report in Google Sheets from OR PTC DCI.

Staff - Importing Excel Sheets into Google QRG v2.pdf

  1. Download the file from OR PTC DCI (see Formatting OR PTC DCI Reports for Download).

    Note
    titleNote

    If you save a report from DCI as a .CSV it will show up as an Excel document in your downloads. 

  2. Log into Google Drive.

  3. Right click on My Drive.                                                                                          

  4. Select Upload files.
    Image Added

  5. Locate the file in Downloads to upload.

  6. Select the file and then click Open to begin the upload process.
    Image Added

  7. Notification at the bottom shows upload is complete and file shows up in your Google drive.
    Image Added

Click to Download the Importing Excel Sheets in to Google QRG

...

Content by Label
showLabelsfalse
max5
spacesORPD
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "state_user" and type = "page" and space = "ORPD"
labelsstate_user

...