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")

Improve this question

2 Answers 2

Reset to default
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

Improve this answer
1
  • 1
    Thank you very much, this is what I was looking for. Commented 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).

Improve this answer

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.