- Thank you received: 1
Import multiple columns from Excel
- brettm
- Topic Author
- Offline
Less
More
6 years 4 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?
Any way to do this please?
- bert
- Offline
Less
More
- Thank you received: 749
6 years 4 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
- brettm
- Topic Author
- Offline
Less
More
- Thank you received: 1
6 years 4 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.
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.