Hot answers tagged

3

A script cannot give a file to you (well, it could email it to you, but I think this is going too far). You'll need to use "save as csv" menu command, and since it only saves the current sheet, you'll have to create a sheet that has only those columns in it. The straightforward way is to just create a new sheet and type in cell A1 ={'My Sheet'!A:A, 'My ...


3

I took some test CSV data and pasted it into a Google Sheet. When I opened the clipboard and chose "split text to columns", my data was immediately split. There shouldn't be anything else you need to do. Try with a smaller sub-set of the data.


2

Actually, Google Sheets exports to CSV using UTF-8. In Excel, instead of using double-click to open a CSV file, use the Text Import Wizard as it allows to select the "File origin". On the "File Origin" field, select 65001: Unicode (UTF-8).


2

Based on Normal Human's answer, I've created a Google sheets script that will parse and email IFTTT based on a price threshold. Google sheet cells won't update ImportXml() or other external site data more than once every hour or so, even using workarounds. However, accessing external sites via the script works. Use the following script and set up a ...


2

My suggestion: Create a Google Spreadsheet with either ImportData (for CSV), ImportXML (for XML) or ImportFeed (for RSS/Atom). There is a trick to make it update more often than the Google default (whatever it is). Have a Google Apps script comparing the data in a particular cell to a given threshold. It can run every hour, and send an email when needed....


1

Generating a direct download link, as described in this article seems to work fine with the =IMPORTDATA function. To summarize, you take the SITE_ID string from the sharing link you have: https://drive.google.com/file/d/FILE_ID/edit?usp=sharing Using this, you can generate the direct download link for use with the =IMPORTDATA function: https://drive....


1

The best way to do this is to just select the cells you want to save as CSV, paste it into notepad, then find/replace tab with a comma.



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