# Convert Navision report to Microsoft Excel

**URL:** <https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219>\
**Category:** Developers Forum\
**Created:** [September 5, 2005, 7:09am UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219 "2005-09-05T07:09:28Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![kamlesh\_nit](https://avatars.discourse-cdn.com/v4/letter/k/f475e1/32.png) [@kamlesh\_nit](https://www.dynamicsuser.net/u/kamlesh_nit)\
**Post date:** [September 5, 2005, 7:09am UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/1 "2005-09-05T07:09:28Z")

</div>

hi all, Can any one just me the logic how to convert report after running in microsoft excel sheet

---

<div class="post-metadata">

**Author:** ![tinoruijs](https://avatars.discourse-cdn.com/v4/letter/t/d78d45/32.png) [@tinoruijs](https://www.dynamicsuser.net/u/tinoruijs)\
**Post date:** [September 5, 2005, 7:14am UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/2 "2005-09-05T07:14:50Z")

</div>

Hi, There are many topics about Excel and reports on [mbsonline.org](http://mbsonline.org). Try using the search-facility on this site. Probably the following thread can help you. [http://www.mbsonline.org/forum/topic.asp?TOPIC\_ID=10041&SearchTerms=excel,report](http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=10041&SearchTerms=excel,report)

---

<div class="post-metadata">

**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\
**Post date:** [September 5, 2005, 9:09pm UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/3 "2005-09-05T21:09:11Z")

</div>

The starting point is to get a good understanding of Table 370. THe best way to start, is to look at report 29. It will take you about 15 minutes to create your first Excel report, but after that the next ones you will program much faster. The way I started, was by just creating a new report based on Item Table, and pulling the code from Repore 29, that basically just cerated a very simple Itme No, Description qty on hand spread sheet.

---

<div class="post-metadata">

**Author:** ![ara3n](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@ara3n](https://www.dynamicsuser.net/u/ara3n)\
**Post date:** [September 7, 2005, 3:26pm UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/4 "2005-09-07T15:26:09Z")

</div>

There is also another product that works with all navision version and doesn’t require any modification or coding. It works realy well with list reports. It is basically a printer driver that writes it to excel. [http://helican.com/products/](http://helican.com/products/)

---

<div class="post-metadata">

**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\
**Post date:** [September 29, 2005, 10:34am UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/5 "2005-09-29T10:34:30Z")

</div>

Hi Ahmed, from the web site this product looks great, is it any good? Do you have clients using it successfully? Have you tried it with the Customer Aging Statement, that’s always the one they want?

---

<div class="post-metadata">

**Author:** ![ara3n](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@ara3n](https://www.dynamicsuser.net/u/ara3n)\
**Post date:** [September 29, 2005, 5:24pm UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/6 "2005-09-29T17:24:37Z")

</div>

Hello David I’ve been using it and customer agin looks good. I’ll ask them to put a screenshot of customer aging report. and post a link here.

---

<div class="post-metadata">

**Author:** ![Sam\_Bartley](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@Sam\_Bartley](https://www.dynamicsuser.net/u/Sam_Bartley)\
**Post date:** [September 30, 2005, 8:03pm UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/7 "2005-09-30T20:03:15Z")

</div>

If you mean “how can I save Navision Report output to an Excel spreadsheet?”, take a look at [www.print2excel.com](http://www.print2excel.com). I’ve only tried the demo but it looks like a good tool.

---

<div class="post-metadata">

**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\
**Post date:** [September 30, 2005, 8:48pm UTC](https://www.dynamicsuser.net/t/convert-navision-report-to-microsoft-excel/10219/8 "2005-09-30T20:48:03Z")

</div>

I also looked at print2excel, BUT the interesting thing about helican, is that they have a specific version for Navision, which I assume will be able to better interpret column positions.
