How import data from Json API

When using Excel’s Get & Transform (Power Query) to pull JSON from an API, you usually need to send parameters either in the URL or in the body of a POST request, not as request headers. That’s likely why you’re not seeing results.

Try this approach:

Go to Data → Get Data → From Other Sources → From Web.
In the dialog, switch from “Basic” to Advanced.
Put the API endpoint URL in the first box (something like https://neofollower.com/panel/api/v2 if that’s the actual API base).
Add the parameters (key=YOUR_API_KEY and action=services) in the query string or request body depending on what the API expects.
Power Query should then return the JSON, which you can expand into rows and columns.

If it still fails, double-check the API docs: some services expect a POST request with form data, which Excel can’t always handle natively. In that case, a small VBA macro or PowerShell/Python script may be needed to fetch the JSON and load it into Excel.