This is an example of a simple Excel spreadsheet imported via the free TablePress plugin. Here’s some information from the TablePress documentation, so it definitely has limitations:
“TablePress supports Microsoft Excel data formats for import (but no export!) of table data. Note that this support is still experimental, and not all data feature, like data types, are supported or available. Also, TablePress can only import the first worksheet of the Excel file. If you have problems importing tables from XLS or XLSX files, it’s recommend to save these tables in Excel as CSV files and try importing those.”
Problem noted: All blank date fields in the original Excel file were populated with a default date (January 1, 1970), and all other dates were imported with incorrect years. I’m not sure how to prevent this from happening, so I’d say this is not an ideal contender.
Student | Date Enrolled | Date Assigned | Class 1 Date | Class 2 Date | Class 3 Date | Completion |
---|---|---|---|---|---|---|
Student 1 | May 2, 2015 | May 9, 2015 | May 14, 2015 | June 13, 2015 | June 19, 2015 | February 7, 1900 |
Student 2 | May 2, 2015 | May 9, 2015 | May 14, 2015 | May 25, 2015 | June 19, 2015 | January 1, 1970 |
Student 3 | May 2, 2015 | May 9, 2015 | May 14, 2015 | May 25, 2015 | June 19, 2015 | January 1, 1970 |
Student 4 | May 2, 2015 | May 11, 2015 | May 14, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 5 | May 2, 2015 | May 11, 2015 | May 14, 2015 | May 25, 2015 | June 20, 2015 | January 30, 1900 |
Student 6 | May 2, 2015 | May 11, 2015 | May 14, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 7 | May 4, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 8 | May 2, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 9 | May 2, 2015 | May 11, 2015 | May 16, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 10 | May 4, 2015 | May 11, 2015 | May 16, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 11 | May 4, 2015 | May 11, 2015 | May 16, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 12 | May 4, 2015 | May 13, 2015 | May 16, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 13 | May 4, 2015 | May 13, 2015 | May 28, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 14 | May 4, 2015 | May 13, 2015 | May 28, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 15 | May 2, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 16 | May 2, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 17 | May 2, 2015 | May 13, 2015 | May 25, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 18 | May 2, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 19 | May 2, 2015 | May 13, 2015 | May 25, 2015 | June 12, 2015 | June 24, 2015 | February 7, 1900 |
Student 20 | May 6, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 21 | May 6, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 22 | May 6, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 23 | May 6, 2015 | May 13, 2015 | May 25, 2015 | June 13, 2015 | June 20, 2015 | February 7, 1900 |
Student 24 | May 6, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 25 | May 6, 2015 | May 13, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 26 | May 6, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 27 | May 6, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 28 | May 2, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 29 | May 2, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 30 | May 2, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 31 | May 2, 2015 | May 11, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 32 | May 8, 2015 | May 13, 2015 | May 25, 2015 | June 13, 2015 | June 20, 2015 | January 1, 1970 |
Student 33 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 34 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 35 | May 8, 2015 | May 13, 2015 | May 25, 2015 | June 14, 2015 | June 24, 2015 | January 1, 1970 |
Student 36 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 37 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 38 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 39 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 40 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 41 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 42 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 43 | May 8, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 44 | May 2, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 45 | May 2, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 46 | May 2, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 47 | May 2, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |
Student 48 | May 2, 2015 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 | January 1, 1970 |