Import multiple columns from Excel

More
5 years 7 months ago #7564 by brettm
Import multiple columns from Excel was created by brettm
I have multiple column headings that I would like to import Into individual columns rather than copying and pasting individually into the Gradebook.

Any way to do this please?

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #7565 by bert
Replied by bert on topic Import multiple columns from Excel
Drag and drop the file into the list of classes > import wizard > append data
The following user(s) said Thank You: brettm

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #7566 by brettm
Replied by brettm on topic Import multiple columns from Excel
That worked! (Of course it did, it's iDoceo!)

I could not import empty columns.

I had to have some data in the first column for iDoceo to complete the import. I just put a '1' in the first cell of my import spreadsheet (in cell A2).

Also, in the iDoceo Import Wizard (as I had no student names in my file) I unticked the column that iDoceo suggested for student names. The Import Wizard says you have to have student names but it appears that you do not.

Thank you, as always Bert.

Please Log in or Create an account to join the conversation.