You can use this example to implement to your case: =query({IMPORTHTML("https://www.bloomberg.com/markets/currencies","table")},"select Col1,Col2",1)