Downloading .csv into numbers 3.5.2

One more thing to add that may help you help me.... When using the Keyword Tool, I get two options upon clicking download:

1.)AdWords Editor CSV (You can import this format (back into) AdWords as a Spreadsheet) *** I do not use this option, seems redundant...

2.) Excel CSV ***

*** are my comments. Anyone know what Excel's CSV 'standard' is??? (please don't beat me up asking about Windows junk!). It's my understanding that there are many different delimiter standards-not just commas. Again, counterintuitive, but I digress.

When I select download it AUTOMATICALLY selects Numbers, which, counterintuitively, is NOT the best file to open .csv files with (I have heard that pages or a text editor are better). So here are my questions:

Can anyone suggest a way that makes another file (i.e. NOT Numbers) be the default when downloading and/or opening .csv files?

Can anyone suggest a good app or program to do this with?

My Chrome browser (or Safari) automatically downloads it when I hit the "Download" button in AdWords. It then shows up in the browser-then when I click it, it opens as a Numbers file. There's no way (that's apparent) to assign it to a specific file OR save it as another type of file.

Opening Numbers, then clicking file>open does NOT work

Regarding CSV to Tab, when I DL from your link and click it it opens in a new window with a script box... 1.) I have no Idea where this file is located on my machine for future use (e.g. I searched for it in finder and couldn't find it-file or icon), 2.) I can't seem to open any relevant files on the left hand side (i.e. in the Actions category) The files are saved to my desktop, but that isn't visible nor are any relevant file storage folders... I can see "Files & Folders" in the actions bar, but searching that was not productive.

That's where my stuff goes too. However, I can open it by clicking in the upper right in Safari (where it shows the files I've recently downloaded) and access it. Usually I can find applications with finder (and sometimes Spotlight search, which IMO isn't all that great). I'm new to OS(X) so I'm still learning how to navigate the file saving nuances of it.

Thanks.
Matt

I found a simple solution. I downloaded LibreOffice and used it instead of Numbers. Too bad Apple can't figure out an easy way to have Numbers open this type of file. Granted, it's a bit archaic, but it's certainly important for many applications like DB's and large data sets (cough...spreadsheets...cough).

To clarify-I opened each file in Numbers, then converted to .csv (it can do that why can't it open it???) and then opened the .csv in LibreOffice. Ridiculous and IMO egg on Apple's face. Worlds largest company vs. freeware/nerds in mom's basement lol.

When I EXPORT (sorry-wrong terminology! I said convert in the previous post, but meant EXPORT) it to a csv file, it works when pasted into LibreOffice. I did not try reopening it then in Numbers...that might just work, but is nearly as circuitous my current method. Its funny that i can export as a csv and cant open the same file...

I did try your second suggestion and it did not work. As best I can tell Numbers won't use csv files with google's delimiters... I'm not sure what form they are in or how to tell. My understanding is that semi-colons, not commas are now the norm for csv?

I don't think opening it is circuitous, but opening>Exporting>reopening is... Especially for dozens to hundreds of files... Regardless if I reopen it with numbers or LibreOffice. Numbers WON'T open it directly...

I was not able to use the Automator Service to open any of these files. It opened and looked operational, but it couldn't find my files...??? It still seems like another work-around.

Matt