Sometimes you don't want to download a file manually; you want to pull data directly from a live web link. Go to the tab and select From Web . Paste the URL that provides the JSON output.
Ensure your JSON is saved with UTF-8 encoding to avoid weird symbols replacing your characters (like emojis or special accents). Conclusion how to download json data in excel
Method 4: Copy-Paste and "Text to Columns" (Not Recommended) Sometimes you don't want to download a file