Essbase rules files support multiple data source formats for loading data. Standard supported formats include text files (.txt), Microsoft Excel files (.xls), and comma-delimited files (.csv). The .dat format is typically Essbase's native data export format and is loaded directly, not through rules files.