Is anyone aware of a way to export the IFS navigator to for example Excel?
Export navigator to excel
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
The navigator is a compressed xml (xml.gz) file in the client folder on the MWS.
You need 7 zip or equivalent to uncompress it but I’m not sure how you would then get it in to Excel in a friendly format. Hope this helps.
The navigator is a compressed xml (xml.gz) file in the client folder on the MWS.
You need 7 zip or equivalent to uncompress it but I’m not sure how you would then get it in to Excel in a friendly format. Hope this helps.
Thanks for your response. I’m aware of this XML existing but I haven’t been able to get it into a friendly format.
Hi Jur,
unzip the GZ-File, open Excel → File open → choose the Navigator.xml. You will get it in this Format:
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/36824e22-98bb-4eb2-ad83-c847c2bf7568.png)
Is this helpful?
Best regards,
Darius
where to find the GZ File?
![10th Reply Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/35b9e158-7759-463e-9e91-ca72142ca2ee_thumb.png)
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/4ca56222-681a-468f-9d9e-7687bdd10528.png)
I have this
However do not have 7 ZIP
maybe this is my issue :(
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/4ca56222-681a-468f-9d9e-7687bdd10528.png)
I have this
However do not have 7 ZIP
maybe this is my issue :(
Hi.
Probably solved the issue, but it looks like you try to open the compressed file. You need to exctract it before you do the import. I have not tried it yet, but i would recommend to use Power Query (part of Excel) where you could manipulate the import file.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.