No more Power Query needed.

Excel's Import From Text function takes lists of text and processes them into spreadsheet data. The process works using delimiters -- special characters that denote where the beginning and end of each ...

You can link Google Sheets with Microsoft Excel by creating a web query in Excel. But this is only one-way integration which means that the changes made to Google Sheets will automatically be updated ...