Skip to content
English
Customer Portal
  • There are no suggestions because the search field is empty.

Exporting Feedback and Input Data to Excel

This article explains how to export all feedback, tasks, and related input data from the Mavim Portal and transform it into a structured Excel report. This method allows you to analyze, filter, and report on all collected feedback, including the underlying feedback details.

Export Feedback Data from the Portal

  1. Open the Input/Feedback overview in the Mavim Portal.
  2. Scroll to the bottom of the page and click Export
  3. Select the following export options:
    • All
    • Include Input Offline Versions
    • All Online Versions
  4. Click the JSON/API icon.
  5. Click OK.

The portal will generate a URL containing the JSON representation of the feedback data.

Import the JSON file into Excel (2 different ways)

1) Import via Web

Excel can connect directly to the data source. Using this connection allows you to:

  • Refresh the data directly from Excel.
  • Avoid repeating the export process.

To update the report later, simply select Refresh in Excel.

  1. Open a new blank Excel workbook..
  2. Go to Data → From Web.
  3. Paste the generated URL
  4. If authentication is required:
    • Select Basic Authentication
    • Enter your username and password

2) Import via file

First save the JSON Data

  1. Open a new browser tab or window.
  2. Paste the generated URL into the browser address bar and press Enter.
  3. The browser will display the JSON data.
  4. Select all content using Ctrl+A.
  5. Copy the content using Ctrl+C.
  6. Open Notepad (or another text editor).
  7. Paste the content using Ctrl+V.
  8. Save the file with a .json extension, for example: FeedbackMavim.json
    You may choose any file name, as long as the file extension remains .json.
  1. Open a new blank Excel workbook.
  2. Navigate to the Data tab.
  3. Select: Get Data → From File→ From JSON
  4. Browse to the saved JSON file.
  5. Select the file and click Import.

    Excel will open the Power Query Editor.

    Transform the Data

    After importing the JSON file, you will typically see the following elements:

    • @odata.context
    • value (List)

    Perform the following steps:

    1. Right mouse click on List (next to Value) and choose 'Drill Down'.
    2. Click 'To Table'.
    3. Click OK.
    4. Click on the 'Columns to Expand' button


    5. You can now choose which attributes should be included in the Excel report.
    6. When the notification 'Load more' appears at the bottom of the Expand Columns, click on 'Load more' and also uncheck the option 'Use original column name as prefix' 
    7. Click OK
    8. Select Close & Load.

    Excel will now generate a table containing all selected feedback records and attributes.

    The report can include information such as:

    • Feedback title
    • Feedback description
    • Tasks
    • Submitter
    • Creation date
    • etc.

    After completing these steps, you will have a fully functional Excel report containing all feedback and input information from the Mavim Portal. The data can be filtered, analyzed, shared, or used for further reporting and auditing purposes.

    © 2026 Mavim. All rights reserved.