In Numbers.app on iOS, is it possible to trigger a response if sheet contains differing data to other sheets in same file? If not able to formulate on iOS, then on a Mac? And will the trigger still show up when viewing same file on iOS? - Sheet 1 = contact list from phone A - Sheet 2 = contact list from phone B - Sheet 3 = message list from phone C - Sheet 4 = contact list from phone

contact name for phone 123-456-7890

- Sheet 1 = *contact doesn’t exist* - Sheet 2 = Jane Doe - Sheet 3 = Jane Doe - Sheet 4 = Ashley How can I set a trigger that will alert me to Sheet 4’s cell “Ashley”? Each sheet contains different - number of rows - column headers

I am downloading a CSV file, which Safari (annoyingly) puts directly onto the page. This CSV file is encoded with UTF-8, and has been verified to be correctly encoded with UTF-8 from the source file, as well as downloading it using other browsers. However, in Safari the character set is incorrect. It is using a Default character set, as seen by looking in the menu:

View > Text Encoding > Default

If I change this to:

View > Text Encoding > Unicode (UTF-8)

I get the correct characters displayed. Why is UTF-8 not the default? How can I force it to be the default? Isn't UTF-8 the default for the whole MacOS operating system, so I have no idea why Safari would be using something different.

I have a complex Numbers.app spreadsheet which contains a table with cells that are colored with different background colors. The different colors represent essential information. When I export the table to a CSV file in numbers (File > Export to… > CSV…) the color information is not included in the exported CSV in any way. That is a problem for me, since it is essential information. Is there anyway to include the cell background color information in a CSV export? Of course I want to retain and export all of the other usual information in the CSV export as well. Any workaround which can export this color information in any kind of structured format would be acceptable/interesting to know. ----- Note: I did notice that this cell background color information *is* preserved when exporting to Excel format (File > Export to… > XLS…). If there is no more direct way, I would love to also hear about an option to first export to Excel, and then export from Excel to a CSV format which somehow includes the structured color information. ------ Also Note: Yes, of course I am aware that CSV is a text-only file format. But out-of-band info could theoretically be included in an export in some kind of format like hex_color_value:text_value for each cell (comma-separated value). Something like that would really be ideal…

I am using a below script to combine several files into one. awk '(NR == 1) || (FNR > 1)' InterfaceStatistics*.csv > /home/vikrant_singh_rana/nfv/merge/InterfaceStatistics_merge_file.csv files are getting merged but the date format is being changed.. see column collectTime circle,collectTime,item,collint,beginTime,duration,endTime,ifIn Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE circle,collectTime,item,collint,beginTime,duration,endTime,ifIn Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP15/COMPUTE Looking for some help to keep the date column format intact. I am running this script on cloud shell environment.

I have a large CSV file with a total size of 214 MB. When I try to open this CSV file with Numbers, Number apps hangs. I have a mac m1 machine with 16 GB RAM. Can any one please tell me how to open a CSV file of this size in mac?

I need to merge multiple .CSV files (using the cat command) but without copying the header for each file. What's the best way to accomplish this task?

I wish to determine when the date my Apple ID was created. To do that, I followed the instructions in this answer: - https://apple.stackexchange.com/a/345405/279727 I am able to download an Excel file containing data corresponding to my Apple ID. However, I am unable to parse the Create Date field. The field simply shows 38:05.0 in the **Create Date** column. What could this mean?

On a computer that has Numbers installed, downloading a CSV file will automatically be converted to a Numbers spreadsheet and no longer be a plain CSV (not just the extension, but the contents themselves are transformed such that they are no longer readable in a text editor or similar). If the machine does not have Numbers on it then this conversion does not take place. The workaround is obnoxious at the time, opening the file in Numbers then saving from there into CSV so it can be actually used as intended. Is there anyway to disable this automatic transformation from happening (aside from uninstalling Numbers)? -------------------- **Update:** I have tried this on various machines and it is definitely a very spotty behavior. I am teaching Intro CS to a college class and all the students have "identical" machines (except whatever modifications they have made after they received them from the college). About 1/4 of the students experience this problem and none of them know why (not very computer-oriented students being a general-education class). It seems that on some computers with Numbers installed, opening a CSV file in Numbers will cause Numbers to convert the file to it's own format, delete the original CSV file, and replace it. I can't find a setting for this, but on certain student laptops this is always reproducible. Additionally, on some computers with Numbers installed, the mime-type text/csv (what the particular server is serving those files as) is considered a 'safe' file and then auto-opened with Numbers, as per https://apple.stackexchange.com/questions/961/how-to-stop-safari-from-unzipping-files-after-download So one solution is following @CraigStodolenak solution which causes Safari to them auto-open the file with a different program and the auto-conversion then never happening. Once I get access to another machine like this I will also try the ⌥ alt trick that disables auto-opening for a single link in Safari. As a side note, on my own machine from the school and another loaner I have received I cannot reproduce the issues with auto-opening or auto-transforming.

Lets say I have following CSV file: 1.0;0.125;0.1253 Opening it in Numbers gives me: Why are 1.0 and 0.1253 correctly presented as "1.0" and "0.1253", but "0.125" is presented as "125"? What do I have to do to get Numbers to display "0.125" correctly? --- Edit: My region and language settings are set to Europe/Germany.

I'm having an odd problem. I've recently decided to try Apple Mail as my default mail platform. Everything is being great until a coworker noticed that the **.csv** files I send come out with *blank rows* in between. - This is the original file (randomly generated for this example). - This is the file sent by another mail platform (Outlook Desktop for example), and opened with TextEdit app or Notepad in windows. - This is the file sent with Apple mail on Mac, and opened with TextEdit app or Notepad in windows. I've been looking into resources, and apparently there is some different with formats using such as CR in Mac, and CRLF in windows but I still can't answer this questions. 1. Why does this happen? 2. Is there a setting I can correct in Excel? 3. Is there a setting I can correct in the Mail app? 4. Will this happen with other types of files? Any help on this is appreciated! **Note: File also has blank rows when opening in Excel, or Numbers **after** it was sent through Apple Mail. Before this, the file looks normal in all apps mentioned above.**

Is it possible to trigger automatic CSV export of a .numbers file while saving / closing? The thing is, I'd like to keep two versions of the same file. One with the .numbers extension, where you can have nice formatting, filtering, etc, and a pure .csv which is obviously more convenient to work with for programming purposes. What is more, I don't want my co-worker to export the file by hand every time they change something because it will surely lead to a lot of sync errors and is a pain in the neck. The best would be something like On save trigger connected with a certain .numbers document defined in AppleScript, but I am not sure if AS supports something like that. In such a case, does anybody have any ideas on how to achieve such a goal?

I'd like to make a spreadsheet of a folder structure in my filesystem. Given a parent folder or volume as the input, the output should include: 1. Subfolders to the nth level (user-specified) 2. A clean/readable visual format showing the folder names and their hierarchy (perhaps each next level in the path breaks out to a new column) 3. The total size of each folder in GB You can't copy and paste more than the names of files directly from Finder, so I understand Terminal / zsh would be the way to achieve this. What command line code would output this result? **What I've tried:** Changing directory to the desired folder in Terminal and running du -k -d 3 gets me somewhat close (-k meaning kilobytes and -d 3 meaning depth of 3). But it's quite an unruly list that is tedious to translate into a spreadsheet format. I'd still prefer to export a .csv from that, generate GB to the second decimal place instead of KB, and perhaps have each level in the path name break out into a new column of the .csv.

I have a CSV file that I open in Numbers, I need one of the cells to be a URL clickable link though, and in the CSV file if I use something like this, it does not turn into a clickable link in Numbers:

=HYPERLINK("https://www.apple.com ","Apple")

If I type in the above in a cell in the Numbers app, then it automatically turns into a clickable link with the words "Apple". I am guessing if Numbers opens a CSV file, it does not support functions such as =HYPERLINK. Perhaps it has to be a Numbers formatted file for it to support functions? Is there a way to "ask" Numbers to open a CSV file in Numbers format so that it can understand the HYPERLINK function?

I hit _File | Save As_ and the output formats are only derivatives of the XLS. Why aren't CSV (and PDF etc) offered? I am on excel 2019 for MacOS

"Numbers" is the Mac OS counterpart to Excel. When you extract data from the Web, you can often export it into the .csv format, which is just a primitive version of Excel limited to a single worksheet. It is very easy to "save as" a .csv file into an .xls file. But, with Mac OS, when you export data into a .csv file, it actually exports it to Numbers. The interface is quite different. Is there a way to turn off Numbers so it does not automatically capture .csv data exports?

I want to convert some 20mb+ JSON files to CSV. Tried using webapps like https://konklone.io/json/ or https://www.convertcsv.com/json-to-csv.htm but they just crash. So how can I use other tools to do such conversions?

I am looking for a free editor to edit comma-delimited text files, or .csv format.

I'm currently using the default Numbers application to open my CSVs. My current use case involves a file that I had to use a different type of separator ( | ). Is there any way to change the separator? Right now when I open the file it just puts the entire row in one column.

I have a CSV file which is delimited with semicolons. I would like to open it in Numbers and edit. Currently, when I open it, it jumbles all the data, including the semicolons, into one column. It appears that the issue is that the delimiting character is set to something other than the semicolon. How can one change it? P.S. I have tried manually replacing the semicolons with commas using a text editor, and it fixed the issue. However, I would still like to know a more straightforward way to do so via Numbers.

I'm trying to merge a large number of CSV files all of which have identical columns using the terminal command cat *.csv >merged.csv. Some of the files have an NA value in the first cell. In these cases, that initial row gets added to the last row of the previous file. Here is a very simple example. ### csv1 - contains column headers ### csv2 - contains data ### cat *.csv >merged.csv yields this output ### my desired output is this