Accessing Sage 50 Import Templates
To access these important templates, follow these steps:
1. In Sage 50 Accounts click Help, then click About.
2. In the Program Details section, click the Program Directory link. This will open the Windows file explorer.
3. Double-click the Import Templates folder where you’ll the files you need.
In an Excel file, each row represents one record and each column represents a data field. The columns don't need to be in any specific order as you can define the columns as part of the import process.
In a CSV file, a comma separates each item of data, and each line of the file represents one record.
In both cases, each data unit has a maximum length. If you enter data that's longer than the defined maximum, for example, 10 characters in an 8-character field, then the data is simply shortened to the required length, but an error is not reported.
Check out this File Format Rules article for more guidance.