There are a few steps here.
Prepare your Google Spreadsheet
Make a copy of this spreadsheetarrow-up-right, 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.)
xls
Either:
(A) Open the downloaded file in Excel to display the raw data … or
(B) Use mb_excelexport_2csvarrow-up-right tool to display the raw data without needing Excel.
mb_excelexport_2csv
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
Last updated 4 years ago
Was this helpful?