Problem solve Get help with specific problems with your technologies, process and projects.

Upload data from Excel to SAP

I am new to SAP and would like to know how to upload data from an Excel sheet into the SAP scenario, like, if we...

are given customer master and material master data in Excel sheets, how do we upload this into the SAP scenario?

SAP does not support direct upload of Excel native format. You may export the data (save to file as .csv) and use the function GUI_UPLOAD or WS_UPLOAD. Then you have to convert the ASCII file into appropriate structures
(hint: command SPLIT ..into itab is very helpful).

This was last published in January 2005

Dig Deeper on SAP Basis administration and NetWeaver administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.


I am Shamala. I work on GSI-SAP system on daily basis by raising Purchase Requisitions and booking Goods Receipt. We receive around 40 requests on daily basis to launch Purchase Requisitions in GSI-SAP system. The details would be provided in Excel sheet. We need to copy paste the data in system in their respective fields. Wanted to check if there is a way to automate it. Data copying directly from Excel sheet to system without copy paste