Recently I took a webinar on Data Integration into Excel and found the hints there directly apply to Anaplan data integration. Nothing fancy...just my notes. Hope it can be used with you or your Clients.
Hints for successful data integration into Anaplan:
Text or csv
Insure all column headers are unique and descriptive
Use common formats for data
Do not mix text and numbers in the same column
Avoid special characters that may not be recognizable
Use consistent date formats
Define any missing values
Differentiate between zero value and blank data
Utilize attribute lists whenever possible to keep text data consistent
Example: List of Job Titles for a Job Title field to avoid typos, inconsistent abbreviations
One item I would add as an item 8 is to ensure that field headers in the Data module match the field headers in the integration file. This enables the import to match on names and not require a manual mapping.