you can, use this example to implement to your case =query({IMPORTHTML("https://www.bloomberg.com/markets/currencies","table")},"select Col1,Col2",1) Or hit me a msg if you need any further help