When downloading data from a table (using the respective icon next to the filter box), a CSV (Comma Separated Values) file is downloaded.
This can be opened using Excel and will appear as any other normal spreadsheet. However, Excel tends to automatically format data, and this may lead to confusions. Take for example the data for the column 'Completed/Total' (referring to courses):
Completed/Total 3/7 0/1 5/10
Depending on your regional settings in Excel, this may be imported as:
Completed/Total July-3 0/1 October-5
Which clearly is not what you needed… The solution to this is to use Excel's import wizard:
-
Click on file→Import
-
Choose “CSV file” and navigate to the .csv file you downloaded
-
In Step 1, choose “Delimited”
-
In Step 2, select the delimiter you want to use (Comma is the default for eFront, but it may be semicolon too)
-
In Step 3, select the column that presents the problem and select “text” as the data format
-
Finally, select where to put the data (leave as is if you're importing in an empty worksheet)