Currency conversion in Google Sheets using the GoogleFinance function

Formula:

[A2] --> =INDEX(GoogleFinance("CURRENCY:USDCAD","price",A2),2,2)

Example:

WordPress Tip: Export WooCommerce category list (SQL, CSV, Excel)

Run this SQL in phpMyAdmin, and then click Export link at the bottom to save as CSV for Excel or other format.

Note: tested only on one level of subcategories.

Gist revisions are welcome: https://gist.github.com/tivnet/d9cca4a4f4cfebe143bc