Access Education Finance accepts catalogue files in .CSV or .TXT format. The file must include a header row, and the columns must appear in the correct order.
Required Column Order
The file must contain the following four columns in this exact order:
Code (minimum 3 characters, alphanumeric).
Description.
Unit.
Price.
đ Note: If the file does not have a header row, or the headers are not in the order listed above, the file will not upload.
Things to Check Before Importing
Check the file is saved as .CSV or .TXT. If it isn't, open the file in Excel and save it as one of these formats.
Check the file has a header row with the column names matching the order above.
Open the file and confirm the column order matches: Code, Description, Unit, Price.
Common Reasons a Catalogue Import Fails
If the import is rejected as invalid, check for the following issues:
Missing columns â one or more of Code, Description, Unit, or Price is absent.
Invalid price â the Price column contains a value that is not a valid number.
Duplicate codes â the same code appears more than once in the file.
Invalid CSV format â the file must be comma-separated with exactly 4 columns and a new line for each row.
Code length â the Code must be between 3 and 12 characters.
Description too long â the Description must not exceed 255 characters.
Unit too long â the Unit must not exceed 12 characters.