BMI Microsoft Dynamics NAV Blog

Opening Microsoft Dynamics NAV / Navision Reports in Excel

Posted by Amy Valenzano on Feb 6, 2014 5:12:00 PM

 

Navision

Many times I have wished there was an option to print a Dynamics NAV / Navision report to Excel but there are only a select few reports that come out of the box with this capability.  I have, in the past, saved the report as HTML then opened that in Excel.  This does work, to some extent, but often requires quite a bit of time consuming re-formatting and clean up. 

I’m excited to say that we have become aware of a better option to pull a Dynamics NAV / Navision report into Excel.  Save the report out of Navision as an HTML file and then open that in Excel as previously stated.  From this point, save this file as a .csv (comma delimited) file.  Open the newly saved .csv file in Excel and you will get the data in a much more manageable format with a lot less cleanup and re-formatting required.

Give this a try and let us know how you make out.

 

Topics: distribution software, Navision, Dynamics NAV, Microsoft, Dynamics NAV 2013, Navision Training, Microsoft Dynamics NAV, NAV Training, Microsoft Dynamics Training