What to click to convert currency in Google Sheets

Up-to-date currency conversion rates right from your spreadsheet.

Open your desired spreadsheet.

Create a column with price.

Create a column with currency symbols.

Double click on a next free column in the first row our your data and type in formula =A2*GOOGLEFINANCE("CURRENCY:USD"&B2).

Press Enter and wait a bit for data to load.

Repeat from step 5 for each row with data or simply drag the first loaded row down.