Convert Multiple Excel Docs into a Single Google Sheet


This example combines several Cognos reports with excel output into a single google sheet —

summary outline:

  • combine all excel reports into one
  • upload/open excel doc using Google Sheets
  • delete uploaded original excel file

Run initial Cognos report with output to Excel 2007:

  • open
  • enable editing
  • save as “Master”
  • change tab name to “Report 1” (right-click tab)

Run 2nd Cognos report to Excel 2007

  • open
  • enable editing
  • rename tab as “Report 2”  (right-click tab)
  • right-click tab and move to 1st spreadsheet “Master”  (right-click tab)

Repeat for all requisite reports. Each tab in “Master” represents an individual report and as such must be named uniquely.

Once all tabs built in “Master” save and close.

Open Google Drive

  • New – File upload -> locate and select Master

From Google Drive double-click uploaded “Master.xlsx”

  • in preview window select Open with – Google Sheets
  • this will open in a new tab and you may leave this document open – this is now the converted Google Sheet “Master”

Go back to Google Drive and close preview window

  • delete original uploaded Excel file (it will be listed with a green X icon)

Share new Google Sheet as necessary

Need Help?

Contact our Service Desk, conveniently located in the ZSR Library.

Hours