Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Aug 12, 2005, 12:52 PM   #1
alexf
macrumors 6502a
 
alexf's Avatar
 
Join Date: Apr 2004
Location: Planet Earth
How to open a CSV file in OS 10.4?

I need to open a CSV file in OS 10.4 and cannot find an application which will display the data in a legible format. CSV is now one of (or perhaps THE) most common database formats out there, so I am not sure why this is so difficult.

Any suggestions?
__________________
"Whenever you find you are on the side of the majority, it is time to pause and reflect."
-Mark Twain
alexf is offline   0 Reply With Quote
Old Aug 12, 2005, 12:59 PM   #2
jeremy.king
macrumors 603
 
jeremy.king's Avatar
 
Join Date: Jul 2002
Location: Fox Lake, IL
By what do you mean legible?

TextEdit or TextWrangler will open it fine.

Microsoft Excel will open it as a spreadsheet.

What are you looking to do with it?
jeremy.king is offline   0 Reply With Quote
Old Aug 12, 2005, 02:21 PM   #3
Doctor Q
Administrator
 
Doctor Q's Avatar
 
Join Date: Sep 2002
Location: Los Angeles
You can probably open it in AppleWorks too.
__________________
Oh do pay attention 007. In the wrong hands, this cylindrical 12-core Mac Pro with three 4K displays, FirePro graphics, and Thunderbolt 2 could be very dangerous.
Doctor Q is offline   0 Reply With Quote
Old Aug 12, 2005, 02:42 PM   #4
alexf
Thread Starter
macrumors 6502a
 
alexf's Avatar
 
Join Date: Apr 2004
Location: Planet Earth
Quote:
Originally Posted by kingjr3
By what do you mean legible?

TextEdit or TextWrangler will open it fine.

Microsoft Excel will open it as a spreadsheet.

What are you looking to do with it?
Well, I work as a Web designer / developer and I am maintaining a store for a client. We have a major product update, and they sent me all the new data as a CSV file. This would be fine if we were using a database, but we are not; I am doing everything by hand. I need to see each product and associated info (price, number, etc.) separated by line breaks, not commas.

Thanks for the help.
__________________
"Whenever you find you are on the side of the majority, it is time to pause and reflect."
-Mark Twain
alexf is offline   0 Reply With Quote
Old Aug 12, 2005, 02:44 PM   #5
tobefirst
macrumors 68040
 
tobefirst's Avatar
 
Join Date: Jan 2005
Location: St. Louis, MO
So, you're saying you need a Comma Separated Values file to not separate by commas? (:
tobefirst is offline   0 Reply With Quote
Old Aug 12, 2005, 02:50 PM   #6
tobefirst
macrumors 68040
 
tobefirst's Avatar
 
Join Date: Jan 2005
Location: St. Louis, MO
I thought about this for a minute....

Would it work to take the CSV file, open it up even though it has all the commas, and just do a "Find and Replace" with returns in place of commas? Would that solve the problem?
tobefirst is offline   0 Reply With Quote
Old Aug 12, 2005, 02:54 PM   #7
alexf
Thread Starter
macrumors 6502a
 
alexf's Avatar
 
Join Date: Apr 2004
Location: Planet Earth
Quote:
Originally Posted by tobefirst
I thought about this for a minute....

Would it work to take the CSV file, open it up even though it has all the commas, and just do a "Find and Replace" with returns in place of commas? Would that solve the problem?
This is a good idea; I thought about this myself. I'll give it a try.

Ideally, I think I will need to have the client get me the data in some other format than CSV (e.g. Excel). If I am not mistaken, CSV is really meant to be plugged into a database, right?
__________________
"Whenever you find you are on the side of the majority, it is time to pause and reflect."
-Mark Twain
alexf is offline   0 Reply With Quote
Old Aug 12, 2005, 02:57 PM   #8
mkrishnan
Moderator emeritus
 
mkrishnan's Avatar
 
Join Date: Jan 2004
Location: Grand Rapids, MI, USA
Quote:
Originally Posted by alexf
Ideally, I think I will need to have the client get me the data in some other format than CSV (e.g. Excel). If I am not mistaken, CSV is really meant to be plugged into a database, right?
Wait... if you're comfortable with an excel file, why don't you open the CSV in Excel? Excel will handle this format very easily. I think CSVs are commonly used to interchange information both in databasing and spreadsheeting... usually they work for sort of two-dimensional records. So it isn't really a "database" format, at least not in the relational or object-oriented database sense.
__________________
Mira C. Krishnan
mkrishnan is offline   0 Reply With Quote
Old Aug 12, 2005, 10:47 PM   #9
alexf
Thread Starter
macrumors 6502a
 
alexf's Avatar
 
Join Date: Apr 2004
Location: Planet Earth
Quote:
Originally Posted by mkrishnan
Wait... if you're comfortable with an excel file, why don't you open the CSV in Excel? Excel will handle this format very easily. I think CSVs are commonly used to interchange information both in databasing and spreadsheeting... usually they work for sort of two-dimensional records. So it isn't really a "database" format, at least not in the relational or object-oriented database sense.
No, Excel will not open the file...
__________________
"Whenever you find you are on the side of the majority, it is time to pause and reflect."
-Mark Twain
alexf is offline   0 Reply With Quote
Old Aug 12, 2005, 11:07 PM   #10
Doctor Q
Administrator
 
Doctor Q's Avatar
 
Join Date: Sep 2002
Location: Los Angeles
Quote:
Originally Posted by alexf
No, Excel will not open the file...
Then it isn't a csv file like any I've run into it.

I thought your problem might have been with the line endings in the file, so I created a test csv file and tried changing the line endings to Unix style, Macintosh style, and PC style. Excel 2004 had no trouble with any of them.

Instead of dragging it into Excel, try this: launch Excel, select File->Open, set "Enable" to "All Documents" (not just "All Readable Documents"), navigate to your csv file, and select it. Does it open? Is it parsed into separate columns?
__________________
Oh do pay attention 007. In the wrong hands, this cylindrical 12-core Mac Pro with three 4K displays, FirePro graphics, and Thunderbolt 2 could be very dangerous.
Doctor Q is offline   0 Reply With Quote
Old Aug 12, 2005, 11:15 PM   #11
CanadaRAM
macrumors G5
 
CanadaRAM's Avatar
 
Join Date: Oct 2004
Location: On the Left Coast - Victoria BC Canada
.CSV files

Excel - File: Open -- issue is that Excel will truncate long fields to 255 characters and will evaluate some text fields as numerals or calculations, possible example would be a phone number.

Filemaker Pro - File: Open (creates a new DB) or File: Import into an existing DB

BBEdit - File: Open. Yes you can search and replace, but be WERRY CAREFUL not to accidentally remove even one comma or paragraph mark, because the wheels will fall off...
CanadaRAM is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
An offline dictionary where one can import a csv file yiannisbot iPhone and iPod touch Apps 0 Feb 14, 2014 11:31 AM
fdisk: could not open MBR file /usr/standalone/i386/boot0: No such file or directory xpmrz Mac Basics and Help 0 Dec 31, 2013 03:59 PM
Please suggest CSV file reader davidlw Mac Applications and Mac App Store 2 Jan 19, 2013 07:12 PM
Adding/Modifying custom words programatically to iOS dictionary from a csv file ashwinr87 iPhone/iPad Programming 1 Sep 27, 2012 12:38 PM
Open folder in Finder or open file from HTML/browser mike1 Mac Programming 1 Sep 27, 2012 09:17 AM

Forum Jump

All times are GMT -5. The time now is 05:06 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC