From the list of classes >
> import CSV/XLS file. The import wizard will guide you through the steps.
If your file is already on your iPad in Numbers, here is a quick guide for you.
You can also drag and drop the file into the list of classes to import it.
> import CSV/XLS file. The import wizard will guide you through the steps.If your file is already on your iPad in Numbers, here is a quick guide for you.
You can also drag and drop the file into the list of classes to import it.
You can also use 'Open in' > iDoceo, to import a file. It will use the 'Import wizard' and by following the steps, you can create a new class with the data or add the data to an existing class. This method is flexible and does not require you to edit your CSV or XLS file headers
If you cannot use an XLS/XLSX or CSV file, you can still import your students’ names from any text-based source like Pages, a PDF or Word, by using the Copy & Paste feature. The video below explains the steps.
Which formats can be imported?
iDoceo is able to import data from CSV and XLS / XLSX files. Any spreadsheet software (such as MS Excel, Numbers, OpenOffice, LibreOffice) can export these files.
We recommend working with XLS/XLSX files
From the app or location holding your CSV/XLS/XLSX file, tap on 'Open in' > iDoceo and you'll be presented with the different options explained here. The import wizard will do the rest for you.
We recommend working with XLS/XLSX files
From the app or location holding your CSV/XLS/XLSX file, tap on 'Open in' > iDoceo and you'll be presented with the different options explained here. The import wizard will do the rest for you.
iDoceo will let you select which sheet to import if more than one sheet has been detected in your XLS/XLSX file.
I can't see the import wizard option when 'Opening in' iDoceo
This means the file is neither a CSV nor XLS/XLSX.
Make sure your file has the correct extension. If you are trying to import several CSV sheets at once, Numbers will create a ZIP file that cannot be processed by iDoceo. The file must end in .csv, .xls or .xlsx
Make sure your file has the correct extension. If you are trying to import several CSV sheets at once, Numbers will create a ZIP file that cannot be processed by iDoceo. The file must end in .csv, .xls or .xlsx
Which information can be imported?
Your students, their personal data, columns and their grades.
What about student photos?
First import the students’ names into iDoceo, the next steps are explained here.
How should I format my data?
The only mandatory requirement is that a single row must contain a single student's data. It can't be spread across different rows.
Optionally, another requirement is that the first row of your spreadsheet should hold your column names.
If you choose not to, importing will work, but the column header text will be empty.
The import wizard
The import wizard handles CSV and XLS/XLSX files for all three import methods: Drag & Drop, Import CSV/XLS file and 'Open In' > iDoceo. It has five stages.
1
Header Row Selection: In this step you have to select which row contains your column headers (students, birthdays, Student ID, Homework 1, exam 1, etc). Additionally, if you have more than one sheet in your file, you can select the sheet you want to import.
2
Student Name Composition: Select the columns containing first names and last names.
3
Personal Data: In this step you will assign which column headers represent which personal data fields, like Student ID column header is ID, or Father column is Father's Name. Leave columns that do not represent personal data fields unassigned in this step.
4
Gradebook Data: All the columns left unassigned in the previous step will be automatically selected in this one. Those columns will be added as columns in the gradebook. If you do not want to add one of them to the gradebook, deselect the column header with one tap.
5
Import: The last step of the wizard, here you will decide if you want to create a new class with all this data or if you would like to add this data to an existing class in iDoceo.
Any other specifics for CSV files?
Yes, if your spreadsheet software allows it, you should choose to store your file in UTF-8 (unicode) encoding.
If you don't, accented characters may appear incorrectly when you import the file.
Any other specifics for XLS files?
Yes, you'll need to save in XLS format from a fairly recent MS Excel (i.e Excel 2000 will work, but Excel 95 won't).
Open In > iDoceo
From your iPhone or iPad, go to the location where you have your file:
iPad Storage (Files App) or email: open the file and select the export button, then iDoceo and tap on it.
Google Drive: Locate the file and click on the three dots > Open In > Select iDoceo.
Dropbox: Select the three dots and choose Share > Export File, then look for iDoceo.
Any other location: Just look for the Export/Open in/Share options and select iDoceo.
When you are taken to iDoceo, the import wizard will open automatically.
iPad Storage (Files App) or email: open the file and select the export button, then iDoceo and tap on it.
Google Drive: Locate the file and click on the three dots > Open In > Select iDoceo.
Dropbox: Select the three dots and choose Share > Export File, then look for iDoceo.
Any other location: Just look for the Export/Open in/Share options and select iDoceo.
When you are taken to iDoceo, the import wizard will open automatically.
You can also use the 'Open In' option in the Mac, just go to where your file is > right click > Open With > iDoceo
Importing without cloud storage
You can use your own iPhone, iPad or Mac storage and from there Open in or Drag & Drop to iDoceo to import your files.
To transfer a file between devices, you can use your personal email, a USB drive or Wi-Fi transfer apps.
To transfer a file between devices, you can use your personal email, a USB drive or Wi-Fi transfer apps.
Appending data to an existing class: I already have some students in this class, what will happen if I import?
iDoceo, when importing, tries to find students with the same name and does not import them again (it only updates their personal data). New students will be imported alongside the existing students.
Importing a single-column CSV of student names
Try adding 2 or 3 empty columns when exporting to CSV, this will help iDoceo to determine the proper CSV format.
Creating a CSV file on Windows
When exporting you should be able to specify CSV and MAC (UTF-8) file format, this will make it easier for iDoceo to work with your file.