I deal with a lot of CSVs. I export them from analytics software, from email/CRMs, etc. I almost never want them in Excel, I want them in Google Sheets or even just to copy/paste the values out of it.
I would really like to do this without opening Excel every time for a copy/paste. Has anyone solved this janky painpoint? Pretty close to writing an AppleScript that just moves it to my clipboard after download.
We're working to solve this pretty common pain point you describe. CSVs are pretty messy to work with, and Excel generally makes them worse (incorrect delimiters, non-escaped quotation marks, etc). Going further, in building our CSV parser, we encountered dozens of different ways that CSVs didn't upload correctly if they had been modified in Excel (or even just opened once!) beforehand.
Small plug - we built Phiona to take CSV information (either local files, or from cloud drives like Dropbox or Google Drive) and then send them to Google Sheets. We use it every day to run our business too- there are so many applications where the easiest way to access data is in CSV format, and it's easier to put the data in Phiona and send it to Google Sheets than having to deal with manual copy-pasting!
This must be a bigger problem than I was aware of if someone is developing a product for it. Nonetheless I'll just point out that putting a .csv in Drive and then right-clicking and choosing Open With Sheets will just immediately open it as a spreadsheet. So there's no intrinsic need for Excel as an intermediary step. Obviously weird csv formattings are going to be a problem, Sheets doesn't seem to provide a csv import dialog (though you can always use split to column operations). And of course if you only want a portion of the data you're going to have to select and prune that at some point, in some tool. But it's easy enough in Sheets, unless your concern is not wanting to try to manage a huge data set in an online (slower) tool.
I assume you want to do something with the CSV files, like some ad-hoc data mining? The best tool for this job is Julia, using packages of CSV + DataFrames + Query https://dataframes.juliadata.org/stable/
You can import/export CSV files, use a SQL like interface to query and manipulate them, all in the command line. Try doing that in excel (or google sheet) to a one million line long CSV with hundreds of fields.
Once I got the CSV beaten down to a manageable size and I want to visualize using a convenient GUI tool I'll skip excel or google sheet, and use tableau.
I hear your pain. I've been working with CSV dumps for 10+ years now. If I need to get the data into Google Sheets, I would use Google Apps Script and just avoid downloading the CSV altogether and use the analytics software's API (if possible). Otherwise, I would have the CSV dumped to a folder in Google Drive and then use the Google Sheets API to read the data from that file into the Sheet. Lot of different ways to do this, but all of them unfortunately require a little bit of scripting.
That's an interesting problem you've outlined here.
1) Regarding sync sheets from CSV to Google Sheets, try to follow this https://blog.coupler.io/csv-to-google-sheets/ It will work in case your CSV is published somewhere (so it has an URL)
2) If you are uploading CSVs from different software -what software do you want to pull data from?
3) Regarding syncing data between different sheets - this tutorial might help you https://help.coupler.io/article/133-web-google-sheets-to-google-sheets
Google lets you subscribe to a calendar using a URL - although when using an Outlook 365 Calendar link, events are copied over once, and then the syncing stops. This seems to be a relatively new is...
Three major considerations I have been using to evaluate the plethora of options available: 1. Effortless/non-intrusive: It shouldn't feel like a video call 2. Price: As this app would be complime...
I've been looking to try something new for knowledge/documentation storage for a little while now. Confluence has always been there, but I find it to be relativly limited for the cost and additiona...