O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exporting Data to CSV Files

When you need to share only the data from an Excel worksheet, you can export it to a comma-separated values (CSV) file. CSV is a very widely used standard for data exchange and consists of text with commas separating the contents of each cell. So when you export a worksheet to a CSV file, you export only the text—Excel strips out all formatting and nontext objects, such as charts or pictures.

To export a worksheet to a CSV file, follow these steps:

  1. If the workbook contains any unsaved changes, save it.
  2. Make active the worksheet you want to export.
  3. Choose File images Save As fromthe menu bar to display the Save As dialog box. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required