Hi Kulbinder,
There are 3 options for you:
1. Copy and paste data from Excel to NAV directly as Mohana mentioned: remember to arrange columns before copy and paste data.
2. Use Configuration Package: create package, configure fields, export template, prepare data in exported template, import data from template file. You can refer to this link.
3. Try our new solution "Universal Excel Import" to be released in May:
3.1. Simply import data from Microsoft Excel with 4 steps: Browse Excel file, Select Excel Sheet, Choose Database Table, Map Fields.
3.2. All 4 steps can be run without user interaction if predefined.
3.3. Import data with dimension values.
3.4. Smart Choose Database Table by Sheet Name or predefined in Excel file.
3.5. Save time with auto map Excel Headers to nearest Fields Name/Caption.
3.6. Support insert new records only or update existed records only or both insert and update.
3.7. Field Validate trigger: can be invoked separately or skipped.
3.8. Record OnInsert and OnModify triggers: can be run or skipped.
3.9. Flexible settings in Excel file to adapt your business requirements such as Constant Values, Auto Number, Not Import Columns, Not Validate Columns, Not Insert New Record, Not Modify Existed Record, Predefined Table ID/Name/Caption, Skip Mapping Fields …
3.10. Support Web Client.
