Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [csv]

Comma Separated Value, or comma-delimited text file, is a plain text format for exporting and importing data between otherwise incompatible databases and spreadsheet applications.

2
votes
1answer
166 views

Prevent Safari from transforming downloaded CSV files to Numbers files

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 ...
0
votes
0answers
8 views

How to convert CSV to Mac Keyboard replacements plist?

I've exported snippets of aText to CSV and want to import them as keyboard replacement snippets in mac. Is there any tool or script which: Can do this coversion one off? I can do the import manually. ...
1
vote
2answers
153 views

plistbuddy command value from csv, search and insert

I have a plistbuddy command that I need to execute for 100 different users. The value I have to enter for the 100 individual users depends on the hostname. I was thinking I could use a csv that has ...
2
votes
0answers
73 views

Download entire iTunes 12.7.4.76 purchase history as CSV file (iMac 21.5-inch 2017, MacOS High Sierra 10.13.4)

Looking to download my iTunes purchase history and found this AppleScript by @Boris42, Download entire iTunes purchase history as CSV file (MacOS High Sierra), however it's not working on my iMac. ...
0
votes
1answer
296 views

Download entire iTunes purchase history as CSV file (MacOS High Sierra)

Has anyone found a way to download iTunes Purchase history into some type of csv or text format? The closest thing I could find was this StackExchange answer of a great applescript that could ...
2
votes
1answer
475 views

Unable to open CSV file

I have a reasonably sized CSV file (40 Megabytes). I know that some apps won't work with certain encodings, and that they will throw error if the encoding isn't ASCII. But its alarming that even ...
0
votes
1answer
356 views

How to save changes in a CSV file using Mac Numbers?

I have a .CSV file, it opens well in Numbers ~4, but when i do changes in that file (editing row color, etc) i can't correctly save it. If i try to save it as .numbers - when i open that .numbers file,...
3
votes
2answers
3k views

How make Safari always download CSV files instead of opening them in-page? [duplicate]

When you click on a link containing to a CSV file, Safari renders it by default. Most other browsers will download them in this circumstance and I'd like to make Safari do the same. What's the ...
2
votes
1answer
340 views

I am trying to “split text to column” on a .csv file in pages

I have one column that is asking for my customer's name, some of my customers put just one and others put several names (first, last, title, etc.) I am trying to change this column to split at the ...
0
votes
1answer
49 views

Open CSV wtih Excel from Finder

Is it possible to open a CSV file with Excel direct from Finder and have the data grouped into columns. I know this is possible through the "File > Import" route, but it takes a lot of time if you are ...
4
votes
1answer
4k views

Save Excel file as pipe-delimited values file

I know that you can save an Excel spreadsheet as a CSV file and that this will put quotes around any fields that have commas in them. I have commas in one of my columns and want pipe (|) delimited ...
3
votes
0answers
6k views

Excel: how to change Default file option to UTF-8 away from Macintosh file option?

When I double-click and open a csv file in Excel, the OSX Excel always opens it in Macintosh format destroying the visualisation of UTF-8 files with malformatted umlaut characters such as ö and ä. I ...
3
votes
1answer
275 views

Most effective way to backup contacts from iPhone to plain .csv - format

I got a corrupted iPhone 5 with latest iOS 10.2 Before I will start over from scratch I would like to backup all my contacts and notes. I would prefer to store them to .csv format, because they are ...
4
votes
3answers
4k views

Open CSV File with Different Separator

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? ...
1
vote
2answers
578 views

need AppleScript to search a 2 column table, w/o Excel, Numbers, etc

don't know how elementary a question like this is, but... • I have a 2 column csv file that I want to search for a value in col A and then grab its matching value in col B. • I will store the csv ...
0
votes
2answers
92 views

How can one jump to a specific line in Numbers?

In Numbers on a MacBook Pro Early 2013, how can one jump to a specific line, such as line 4223860. The data is actually csv formatted, and I have no clue what is inside that line. Any help is very ...
1
vote
1answer
885 views

iOS app for exporting HomeKit data?

I have bought an Elgato Eve HomeKit-compliant weather sensor. It works well enough but unfortunately its accompanying app does not support data export. From what I understand about Apple HomeKit, ...
4
votes
2answers
4k views

Applescript: Automate Excel to convert .xls to .csv

I'm trying to batch process converting a folder of .xls files to .csv using Applescript for MS Excel V15.15. I'm using a sample I found online to model it : set theOutputPath to (path to desktop ...
0
votes
1answer
1k views

How Can I Convert A .TXT File To A .CSV File Without Losing Any Of The Content Of That Document?

I've been trying for about 4 days now to complete the seemingly simple activity of converting an OS X keychain text dump to a correctly formatted .csv with no progress, much less success. I posted a ...
1
vote
1answer
194 views

OSX: Dupe-checking / Merging / Cleaning iCloud Contacts & importing 350 additional ones

I'm in a bit of a pickle, I've been given an errand (or.. so I thought ;) ) to run, of cleaning up 1100 iCloud Contacts for a friend, who runs a little business. He also handed me 350 additional ...
3
votes
2answers
20k views

Separate multiple comma separated values in Numbers

One of the CSV files I'm using has lumped the address into one single cell, separated by commas. For example: 12 Fairy Tale Lane, Wonderland, Oz, Neverland I need to separate these into Address 1, ...
1
vote
1answer
344 views

Calendar App with CSV import

At the moment i'm trying to switch from Outlook to Apple Mail / Cal.app and would like to know if anyone here has found a way to batch import Calendar events consistently from CSV files. The usual ...
2
votes
2answers
9k views

How to export Contacts version 9.0 data or .abbu file to .csv or other usable spreadsheet format

In the newest Apple Contacts version 9.0, how do you export all contacts or an .abbu file to a .csv file or other usable spreadsheet format? Dragging and dropping to Numbers does not work. Exporting ...
2
votes
2answers
5k views

How do I preserve leading zeroes in Mac Excel?

I'm using Excel (v 14.4.4) on my Mac (10.9.5). I have opened a CSV file and I wish to save it to an .xls format (Excel 97-2004 Workbook). I have a column that has 6 digit numbers, some of which ...
0
votes
1answer
97 views

Xls to csv - Numbers creates multiple csv files for some reason

I have a small xls file which 200Kb of size. When I export it to csv format, Numbers creates multiple csv files. How do I make it create a single one?
2
votes
1answer
2k views

How can I import OS X Mavericks server accounts from a CSV file?

I'm trying to create new users on my OSX server by importing short & long names from a CSV file. When I attempt to import the CSV I get the following error: The file couldn't be imported ...
1
vote
0answers
102 views

.csv file strange behaviour on my Mac

I have this .csv file I created and I am in trouble when I open it on my Mac. Both using excel or a text editor the file has a lot of new lines in the middle of each line, i.e. a single line is split ...
2
votes
1answer
6k views

Comma separated list to Columns / Mac Numbers

I have a very huge list of Data (.txt file) .e.g. 945874,stu2,3826,120558,74,15 1836682,CHAOSTAURUS,90,978,3853,0 1411981,KasiaLover,101,28285,684,5 8270041,Daniel33de,3883,2389,2397,1 ..... etc ...
12
votes
8answers
40k views

How to gracefully import CSV files into Numbers.app v3?

I have a process, which has worked faithfully for years in Numbers '09, whereby I download my Bank account data in CSV format, then drag that data directly into my Numbers sheet (after creating an ...
0
votes
1answer
4k views

How to open CSV file with Microsoft Excel and get the information into separate columns?

I have a problem opening my .csv files in Excel; when importing them, all the information is in one column. How do I get Excel to separate the information automatically into different columns? I have ...
0
votes
2answers
104 views

Numbers.app - How do I add a series of columns

I have a spreadsheet with about 600 rows and 20 columns. I want to add a unique identifier to each cell so that I can use the exported CSV output in another app. So I thought that I could add a ...
1
vote
1answer
547 views

Exporting CSV with Numbers with different languages

I am exporting a file from Numbers to CSV and it contains language other than English, like Japanese or Russian. After I export the CSV, all these funny characters shows up in the CSV. Is there a ...
0
votes
1answer
593 views

Expand Sending Email with Applescript

I read with interest the article regarding sending an email based upon parsing through a csv file to pick up the name and email address. This looks like most of what I need to accomplish my objective ...
5
votes
4answers
23k views

Customize delimiter character with Excel CSV save-as

Is there any way to do this? I need to use a pipe "|" as my delimiter. On Windows you can change this during the export. On Mac I haven't found a way. As a side note, my files have commas in the ...
15
votes
6answers
45k views

Merging Multiple CSV Files without merging the header

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?
2
votes
2answers
3k views

How to export address book to mailchimp or CSV file?

I want to export specific address book groups to mailchimp from a clients Mac computer. The client have version OS X Lion (10.7) and the Mac she has is faulty and will be scrapped soon. Therefore it ...
8
votes
6answers
53k views

Export iTunes music library information (album, artist, track names) to CSV or spreadsheet format?

Is there a way to export album/track information from an iTunes music library into, say, a comma-separated values (CSV) file, or another spreadsheet-friendly format? I'd like to be able to grab a ...
1
vote
3answers
1k views

Connect to ODBC and export data as CSV?

Is there a way I can connect to a data source via ODBC and export the data to a CSV file on the mac? Open-source software to do this would be great, otherwise is it possible from the command-line?
1
vote
4answers
2k views

Are there any clean-up tools for Address Book data?

I use a great add-on tool called Thunderplunger to clean up my address book in the Mozilla Thunderbird email client, but I need something similar for the original Mac Address Book too. Basically I ...
1
vote
1answer
2k views

Is there a data collection app that exports CSV to Dropbox?

I'm having some serious issues finding a data collection program (Spreadsheets?) for use with my Dropbox account. The application should be able to export CSV files, and automatically upload them to a ...
4
votes
2answers
47k views

How to open .CSV file with Microsoft Excel?

I was told that I could open a .CSV file with Excel. However, my Microsoft Excel refuses to recognize the file. I have tried my different ways to open it in Excel but the program didn't give me a ...
21
votes
12answers
50k views

Free .CSV text file editor for Mac OS X?

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