Tag Info

Hot answers tagged


Use the IMPORTDATA() built-in function. AFAIK the refresh of the data is done on the server side, so refreshing or recalculating the spreadsheet very frequently could not make any difference. The time that it takes on the server side is not documented in an canonical source; some sources say that it takes 5 minutes others 1 hour. References IMPORTDATA - ...


I acknowledge that this does not answer "what is Google Spreadsheets’ new line character?". However, if not for OP for others wanting to get from a text file containing: hi,hello\r\nwelcome,to\r\npeaceful,world to : a process of the kind below may suit. The technique is basically to 'feed' Google Sheets with a replacement for \r\n that ...

Only top voted, non community-wiki answers of a minimum length are eligible