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
41 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
25 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
29 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
0answers
120 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
32 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 ...
1
vote
1answer
522 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 ...
3
votes
2answers
4k 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
2k 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
45 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
108 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
283 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
6k 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 ...
5
votes
3answers
8k 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
1k 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 ...
4
votes
3answers
15k 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
503 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
1k 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 ...
0
votes
2answers
13k 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 ...
6
votes
5answers
20k 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.