# Import a table from Excel to Navision 2013 **URL:** \ **Category:** Technical Forum\ **Created:** [July 22, 2014, 10:09am UTC](https://www.dynamicsuser.net/t/import-a-table-from-excel-to-navision-2013/54011 "2014-07-22T10:09:47Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![nikolas\_dot](https://avatars.discourse-cdn.com/v4/letter/n/bcef8e/32.png) [@nikolas\_dot](https://www.dynamicsuser.net/u/nikolas_dot)\ **Post date:** [July 22, 2014, 10:09am UTC](https://www.dynamicsuser.net/t/import-a-table-from-excel-to-navision-2013/54011/1 "2014-07-22T10:09:47Z")
Hello there, I am a pretty new ERP Consultant and very new to Nav 2013. We would like to do an import of our customer Item list which is an excel file into Dynamics NAV 2013. I have tried to do it several times but with no luck. Can someone please advise me on how to import it? and if is possible provide me with step by step instructions. Regards, Nikolas K. ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [July 22, 2014, 11:01am UTC](https://www.dynamicsuser.net/t/import-a-table-from-excel-to-navision-2013/54011/2 "2014-07-22T11:01:25Z")
Welcome to DUG What steps did you try? 1.you check Rapidstart services 2.you can write xmlport 3.you can simply copy from excel and paste in NAV but make sure that fields in excel and NAV match and fields are validated based on order. ---
**Author:** ![nikolas\_dot](https://avatars.discourse-cdn.com/v4/letter/n/bcef8e/32.png) [@nikolas\_dot](https://www.dynamicsuser.net/u/nikolas_dot)\ **Post date:** [July 22, 2014, 12:39pm UTC](https://www.dynamicsuser.net/t/import-a-table-from-excel-to-navision-2013/54011/3 "2014-07-22T12:39:32Z")
Hello Mohana, Thanks for the quick reply. I have basically tried through Rapidstart Services but I did not manage to get it working because: My steps: I go to Configuration Worksheet - (27) Items Table – Import from Excel Template – And then I get no error or any message and am stuck. Is it possible to give me step by step for Rapidstart please? Thanks ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [July 22, 2014, 12:44pm UTC](https://www.dynamicsuser.net/t/import-a-table-from-excel-to-navision-2013/54011/4 "2014-07-22T12:44:56Z")
You should first export the template and prepare the data in that template and import. You can see this video for reference [http://www.youtube.com/watch?v=AuRQGitHfJw](http://www.youtube.com/watch?v=AuRQGitHfJw) ---
**Author:** ![nikolas\_dot](https://avatars.discourse-cdn.com/v4/letter/n/bcef8e/32.png) [@nikolas\_dot](https://www.dynamicsuser.net/u/nikolas_dot)\ **Post date:** [July 22, 2014, 12:56pm UTC](https://www.dynamicsuser.net/t/import-a-table-from-excel-to-navision-2013/54011/5 "2014-07-22T12:56:41Z")
Ok in the case that i have been given by the customer something like this bellow, Is there something that i can do?? | **Vendor number** | **Suppliers Item Code** | **Barcode1** | **Description** | **UOM** | **Qnt per UOM** | **PUOM** | **Qnt per PUOM** | **Invoice price** | **Discount on invoice** | **Net Cost** | **Retail Selling Price** | **Product Group Code** | **VAT Prod. Posting Group** | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | 133000089 | SOD1 | 8523000498540 | (10X25cl) btl | 10PACK | 1 | CASE | | € 9,40 | 0 | € 9,40 | 6,50 | E0289 | VAT19 | | 133000089 | SOD1 | 8523000498563 | ( 10X25cl) btl 2’S | CASE | 2 | CASE | | € 9,40 | 0 | € 9,40 | 10,90 | E0289 | VAT19 | | 133000089 | SOD5 | 8725000212354 | 33cl btl | EA | 1 | CASE | 24 | € 13,80 | 0 | € 13,80 | 0,75 | E0289 | VAT19 | | 133000089 | SOD2 | 8725000417563 | 66cl btl | EA | 1 | CASE | | € 11,50 | 0 | € 11,50 | 1,40 | E0289 | VAT19 | | 133000089 | SOD2 | 8718104901782 | 66cl btl 12’s | CASE | 12 | CASE | | € 11,50 | 0 | € 11,50 | 15,50 | E0289 | VAT19 | | 133000089 | SOD3 | 5010549185236 | 50cl btl | EA | 1 | CASE | | € 23,70 | 0 | € 23,70 | 1,95 | E0291 | VAT19 | ---
**Author:** ![nikolas\_dot](https://avatars.discourse-cdn.com/v4/letter/n/bcef8e/32.png) [@nikolas\_dot](https://www.dynamicsuser.net/u/nikolas_dot)\ **Post date:** [July 22, 2014, 12:58pm UTC](https://www.dynamicsuser.net/t/import-a-table-from-excel-to-navision-2013/54011/6 "2014-07-22T12:58:54Z")
Sory for the mess there [+o(]