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

1
vote
0answers
17 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
18 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 ...
2
votes
0answers
791 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
692 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
0answers
24 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 ...
0
votes
0answers
32 views

How to maintain capital letters within a Numbers files exported as a CSV file?

I imported a CSV file into Numbers which contained emails, phone #'s, first and last names. I cleaned up the data in Numbers so that names started with capital letters and phone numbers contained ...
0
votes
0answers
37 views

Excel opens some of my .csv files as workbooks

Some .csv files open correctly, some do not, The .csv files that open incorrectly change to a workbook file, eliminating the file extension .csv. I have tried importing the .csv file but that didn't ...
0
votes
0answers
68 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
187 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
2k 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
4k 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
781 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
11k 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
316 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
2answers
929 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
963 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
9k 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
15k 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.