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
Hey guys, first post here. As part of my work, I have to deal with and respond to a lot of incoming messages from different chats: Linkedin/WhatsApp/Signal/IG. I try to use Unreads/Archive features...
There are plenty of advanced, powerful software filled with enough features to do almost anything. And then there are the tiny utilities that don't do much, but that are great at what they do do. ...
I came across Readwise this week and I thought it was a very nice app. It sends emails with highlights from Kindle books, Instapaper, Pocket, iBooks and other services. It also offers the spaced re...