- Thank you received: 1
 
Import multiple columns from Excel
- brettm
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        
			
    
						7 years 2 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
 
			
    
						7 years 2 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
 
			
    
						7 years 2 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.