We can easily insert country currency in excel sheet, but the main problem is how to get real time currency rate changes, so in this post I will show you how to add real time currency converter for Saudi Arabia Riyal to Indian Rupees in Microsoft Excel, this method will work all the version of MS Excel from 2003 to 2016.. lets see how to do this.
1. In google search for “x-rates” open the first link select the Saudi Riyal (SAR) and Indian Rupees (INR) and click on “Rates table”
2. Open Excel click on “Data” click on “From web” copy the x-rates’s url and paste it in “Address” and click on “Go” click on arrow mark the table will be selected, now click on “Import” and “ok” wait for few seconds.
3. The Saudi and Indian currency will display in sheet (please watch below video to know how to do calculation and update currency regularly)
Watch video tutorial.. Please like, share & subscribe