How to Save a Google Sheet as an Excel File and Upload It Into ARIS Online (AO)

ARIS Online (AO) currently prompts you to download the assessment as a Google Sheet. However, you’ll need to convert your file to Microsoft Excel (.xlsx) before it can be uploaded.

These instructions walk you through converting your Google Sheets to an Excel (.xlsx) file. Please note, Excel does not have to be on your computer for you to save a file as an .xlsx file.

This article walks you through:

1. Saving a Google Sheet as an Excel file
   
   
2. Uploading the Excel file into a learner profile
   
   

Prefer to watch these instructions?  Here’s is a video tutorial of how this looks in action

Part 1 — Save Your Google Sheet as an Excel Spreadsheet

1. Open your Google Sheet that contains the assessment data.
   
   
2. In the top menu, click File.
   
   
3. Hover over Download.
   
   
4. Select Microsoft Excel (.xlsx).
   
   
5. The Excel version of your file will download to your computer.
   
   

Part 2 — Upload Your Assessment File Into ARIS Online (AO)

1. Go to your ARIS Online dashboard.
   
   
2. Click on the “Learners” tab in the left-hand navigation menu, then use the drop-down menu to select the desired student. 
3. Click on Assessment in the learner’s profile.
   
   
4. Click on Add Assessment.
5. Click on Upload a Filled Template.
6. Click on Upload Formatted Template.
   
   
7. Locate in the files on your computer the Excel spreadsheet you just downloaded.
8. Toggle on the assessment dates you wish to upload into your learner profile.
9. Click Save Selected Assessments.
   
   

When the upload completes, your assessment data will appear in your AO dashboard.

All fields included in your template — including dates — will display exactly as they appear in the file.

Run into problems?  Here are some troubleshooting tips.