USD to CAD spreadsheet converter (2024)
Have some 2024 US dollar amounts you need to convert to Canadian dollars? Look no further.
Simply paste in spreadsheet cells with your dates and amounts, hit convert, and this free utility will do the rest.
How to use
- Copy cells from your favourite spreadsheet application, like Excel, Google Sheets, or Numbers
- Paste into the blue box below
- Hit convert!
Your table will have new columns in Canadian dollars for the US dollar amounts found in the sheet.
Spreadsheet layout
Your spreadsheet should have a date column in YYYY-MM-DD format, like 2024-04-19, and a currency column starting with a dollar sign ($).
Here's an example of some coffees from my Ko-fi page:
| Date | Description | Amount USD |
|---|---|---|
| 2024-01-24 | PayPal (Ko-fi) | $2.59 |
| 2024-02-01 | PayPal (Ko-fi) | $5.47 |
| 2024-02-01 | PayPal (Ko-fi) | $2.58 |
Features
- Fast and free!
- Uses Bank of Canada Daily Exchange Rates
- For weekends and holidays, uses the nearest preceding date, following Income Tax Folio S5-F4-C1, Income Tax Reporting Currency
Tips
If your income from other currencies is below CA$200, you may not need to claim that income.
You can copy & paste from a website table, too!