Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

1 points

How do I create a .csv file on my mac?

I am having issues doing some reporting. I have a file that I pull from safari- I need to be able to put this into numbers. Typically, in windows, I would paste the info onto a notepad and save as .csv, then open again in numbers.

So--I can't save in pages like that-- and I can't get it to past in numbers correctly. Any suggestions would be great!

Thanks

MacBook Pro, Mac OS X (10.7.2)

Posted on Oct 14, 2012 9:04 AM

21 replies

Melli D Author

Level 1

1 points

Oct 14, 2012 12:52 PM in response to Melli D

oh my word-- it worked. i saved it as a .txt file and then just went to the file on my desktop and renamed it. THANK YOU!! I even called Apple support and they spend 40 minutes trying to figure it out and finally said they can't. What an easy fix, that I just didn't think of! You guys rule!!

drdocument

Level 4

3,019 points

Oct 14, 2012 2:22 PM in response to Lanny

Lanny wrote:

Doesn't anyone read the previous posts? Saving it as a text file with the extension of .csv works.

Yes, that was my goof.

I accidentally failed to note in TextEdit that I was saving as RTF instead of TXT.

drdocument

Level 4

3,019 points

Oct 14, 2012 2:27 PM in response to michaelsip4

Interestingly enough, if a text file is tab-delimited (or otherwise delimited as well), if I choose Open from within Excel 2011 and then select the text file, Excel will present an import wizard which allows me to specify the parameters and end up with the delimited field contents in cells.

This Excel feature is handy. I am going to give Apple feedback with an enhancement request for Numbers.

Oct 14, 2012 2:59 PM in response to Melli D

Just looked at Numbers help file

To add CSV or OFX data to an open spreadsheet:

Select a sheet.
Do one of the following:
- To create one or more new tables, drag a CSV or OFX file from the Finder onto the sheet’s canvas.
- To add CSV or OFX data to an empty table, drag the CSV or OFX file onto the table.The data is added; additional columns are created if necessary.
- To add CSV or OFX data to a table that contains data, drag the CSV or OFX file onto the table.If the columns don’t match, choose an option from the sheet that appears. You can cancel the import, add columns to the table, ignore extra columns, or create a new table from the CSV or OFX data.

Melli D Author

Level 1

1 points

Oct 14, 2012 3:02 PM in response to MacPleased

the problem was, I couldn't get the data to sort out at all in numbers. Once I have the file in .csv form-- I can easily open it up in Numbers- and it works perfectly. I just needed to figure out how to get the text to that format. My answer was resolved. thanks!!

Garavani

Level 1

4 points

Jun 4, 2015 9:09 AM in response to bispymusic

Thanks so much! Simple but effective help.

How do I create a .csv file on my mac?