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.

learn more… | top users | synonyms

0
votes
1answer
56 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 ...
0
votes
0answers
12 views

Missing Items From KeyChain Dumps

I'm using the process outlined here to export my OS X keychain items to .csv files. After getting many blank .csv files, I adapted the script using this guy's suggestion. After making this change, ...
0
votes
1answer
47 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 ...
0
votes
2answers
224 views

How do I separate multiple comma separated values in Numbers

So, 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
vote
1answer
82 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
2k 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
476 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
58 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
513 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
48 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
3k 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 ...
6
votes
4answers
13k 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
3k 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
67 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
0answers
166 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
383 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 ...
0
votes
4answers
11k 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 ...
6
votes
3answers
15k 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
2k 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 ...
7
votes
4answers
25k 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
703 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
1k 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 ...
1
vote
2answers
23k 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 ...
11
votes
8answers
26k 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.