Setup raw data

There are a few steps here.

Steps
Description

Prepare your Google Spreadsheet

Make a copy of this spreadsheet, which we'll use below.

Download from ManageBac

Go to Reporting —> Historical Reports and download the xls files provided there. (At the moment only PYP is currently supported.)

Either:

(A) Open the downloaded file in Excel to display the raw data … or

(B) Use mb_excelexport_2csv tool to display the raw data without needing Excel.

Take the downloaded file and open it in such a way so that Google Spreadsheets can read it.

Either: (A) Copy and paste the displayed raw data and paste into Google Spreadsheet …  or (B) Save as CSV, and import into Google Spreadsheet

Bring the raw data into Google Spreadsheet

Prepare Google SpreadsheetDownload from ManageBacUse mb_excelexport_2csv toolPlaceholder

Last updated

Was this helpful?