ImportFromWeb is currently compatible with Google Sheets only and does not work directly with Excel. However, there’s good news for Excel users who want to benefit from web data scraping.
You can easily export data from Google Sheets to Excel. Here’s how you can do it:
1. In Google Sheets, open the document containing the scraped data.
2. Go to the “File” menu.
3. Select “Download” and choose the format you’d like to export to, such as “Microsoft Excel (.xlsx).”
The data will be downloaded as an Excel file, which you can then open and use in Microsoft Excel.