Routine uploading of data from Excel files to SAP remains a thorny challenge facing many companies today. Business users are feeling the pain of manually re-keying Excel data into SAP; while programmers in IT departments are having to constantly write new programs to automate the upload of excel files to SAP.

This paper describes 7 best practices that many companies have adopted in automating the upload of Excel data into SAP. Adopting these best practices will alleviate many of the pains that business users and IT analysts face in uploading Excel data to SAP.