0

I'm using IMPORTDATA to get some Crypto Rates. My Spreadsheet has Locale settings to Spain and the data from the csv have the numeric format of United States, so I'm getting wrong numbers.

There's a way to use IMPORTDATA function on this Spreadsheet or do I need to make a new one with Locale set to United States (or change Locale setting of the current one)?

This is the formula: =IMPORTDATA("https://cryptorates.ai/files/standard.csv")

2 Answers 2

1

Just change the locale of the CSV file, like this:

=IMPORTDATA("https://cryptorates.ai/files/standard.csv"; ","; "en_US")

https://docs.google.com/spreadsheets/d/1LnUWeKxuMpFf5vswKhtzr6UOVPitJe4KCY85k2cw1Pw/edit?usp=sharing

enter image description here

1
  • 1
    Thank you very much, this is what I was looking for. Apr 21, 2022 at 9:10
1

You can change the locale of your spreadsheet. Click File > Settings.

Regarding IMPORTDATA it hasn't any other parameter than the URL. Instead of IMPORTDATA, you might try to use a Google Sheets Add-on, Google Apps Script or a third-party service (nowadays there are a lot).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.