topic Re: Excel format in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/excel-format/m-p/4610735#M1086438 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Save your Excel data file as a Tab-delimited text file on your local drive (C:\) and name it with a .txt file extension, and use it.</P></BODY></HTML> Sat, 18 Oct 2008 14:07:16 GMT Former Member 2008-10-18T14:07:16Z Excel format https://community.sap.com/t5/application-development-and-automation-discussions/excel-format/m-p/4610733#M1086436 <HTML><HEAD></HEAD><BODY><P>I know how to upload data in txt file format to sap using lsmw.</P><P>I want to upload legacy data in Excel file format to sap using lsmw.</P><P> Then how to do this.</P></BODY></HTML> Sat, 18 Oct 2008 07:59:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-format/m-p/4610733#M1086436 Former Member 2008-10-18T07:59:59Z Re: Excel format https://community.sap.com/t5/application-development-and-automation-discussions/excel-format/m-p/4610734#M1086437 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in step num 7 of LSMW we will specify the file name there you give your source and excel file and in the DELIMITER tab select the semi colon radio button. by this i think u will be able to upload data from an excel file in LSMW.</P><P></P><P>please correct me if iam wrong.</P><P></P><P>abaper007.</P></BODY></HTML> Sat, 18 Oct 2008 11:03:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-format/m-p/4610734#M1086437 Former Member 2008-10-18T11:03:14Z Re: Excel format https://community.sap.com/t5/application-development-and-automation-discussions/excel-format/m-p/4610735#M1086438 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Save your Excel data file as a Tab-delimited text file on your local drive (C:\) and name it with a .txt file extension, and use it.</P></BODY></HTML> Sat, 18 Oct 2008 14:07:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-format/m-p/4610735#M1086438 Former Member 2008-10-18T14:07:16Z