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.
Our current sales process is a very barebones: when a lead completes a form on our website, we send them an automatic email. When the lead responds, we use Front to assign the threads to each other...
Ever been frustrated learning how to use a new piece of software because of all the options and not sure where to start? Is there any software that can switch to a "beginners" mode? Meaning, hide...
Sometimes you need a new app—and there's nothing that exactly fits the need. That's part of what's made tools like Notion so popular, since you can customize them and build new tools that fit what ...