Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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")
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
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).
