We developed an application(Microsoft Excel –Forms) which contained two facilities first was for designing an excel form as per their requirement by using the drag and drop option and the second was offline data collection in Macro enabled Excel Workbook. Microsoft Excel –Forms can later be used by various authenticated users to collect data. The distinctive advantage of E -FORMS is its ability to work in offline mode i.e. in absence of network connectivity. Data could be entered and temporarily saved using the apps for office forms integrated into the macro-enabled excel workbook and could be uploaded to the server as and when the network becomes available. The form provides bi-lingual support as well. E-forms imbibe upgraded features which enable the user not only to design forms but also to download them and operate on them even in absence of a network. SharePoint enables the user management of the application and provides authorization as per the type and needs of the user. Soon after the solution was developed we received encouraging positive feedbacks on the same.