How to Export a CSV File from Common Programs

Select the program you use from the list below to see instructions and screenshots on how to export a Comma-Separated Value (CSV) file.

Microsoft Office Excel 2010

Click on any of the screenshots on the right to see an image that matches each step.

Excel 2010 File > Save As Excel 2010 Save As CSV Excel 2010 Filename Excel 2010 Warning multiple sheets Excel 2010 Warning CSV compatible
  • Once you've created your spreadsheet, click the green File button in the top-left and click the option to Save As.
  • In the new window, select the Save as type drop-down menu and choose CSV (MS-DOS) (*.csv).
  • You can now change the File name as well as the location where you will save it. Click Save when you are ready.
  • A warning may appear about your workbook containing multiple sheets. Click OK to continue.
  • Finally, you will receive a warning about features not being compatible. Click Yes to complete saving the file.

Microsoft Office Excel 2007

Click on any of the screenshots on the right to see an image that matches each step.

Excel 2007 File > Save As Excel 2007 Save As CSV Excel 2007 Filename Excel 2007 Warning CSV compatible
  • Once you have created your spreadsheet, click on the Office button in the very top-left, hover your mouse over Save As and a new window will appear to the right; click on Other Formats.
  • In the new window, select the drop-down menu for Save as type and choose CSV (Comma delimited) (*.csv).
  • You can now change the File name as well as the location where you will save it. Click Save when you are ready.
  • Finally, you will receive a warning about features not being compatible. Click Yes to complete saving the file.

Microsoft Office Excel 2008 (Mac)

Click on any of the screenshots on the right to see an image that matches each step.

Excel 2008 File > Save As Excel 2008 Save As CSV Excel 2008 Filename
  • Once you have created your spreadsheet, select File and choose Save As....
  • In the new window, select the drop-down menu labelled Format and choose Comma Separated Values (.csv).
  • You can now change the file name and location before clicking Save to complete the process.

Apple iWork 2009 Numbers

Click on any of the screenshots on the right to see an image that matches each step.

Apple iWork 2009 File > Save As Apple iWork 2009 Save As CSV Apple iWork 2009 Filename
  • Once you have created your spreadsheet, select File from the top menu and choose Export... from the drop-down menu.
  • At the top of the new window that appears, select the icon labeled CSV at the top. Secondly, change the Text Encoding to Unicode (UTF-8) before clicking Next at the bottom.
  • The final window allows you to alter the filename and location before you finish by clicking Export.

LibreOffice 4.x.x Calc

Click on any of the screenshots on the right to see an image that matches each step.

LibreOffice 4.x File > Save As LibreOffice 4.x Save As CSV LibreOffice 4.x Edit filter settings LibreOffice 4.x Warning confirm file format LibreOffice 4.x character set UTF-8
  • Once you have created your spreadsheet, select File from the top menu bar and choose Save As....
  • Change the drop-down menu labelled Save as type to Text CSV (.csv) (*.csv).
  • You can now change the File name, but make sure you check the box for Edit filter settings at the bottom of the window.
  • You may receive a warning asking you to Confirm File Format. Select Use Text CSV Format to continue.
  • The final window requires you to set the proper Character set: Unicode (UTF-8). Click OK when completed.

Google Drive Spreadsheet

Click on any of the screenshots on the right to see an image that matches each step.

Google Spreadsheets File > Save As Google Spreadsheets Save As CSV
  • Open your spreadsheet in Google Drive, then select File from the top menu. Hover your mouse over Download as and choose Comma-separated values (.csv, current sheet) from the pop-out menu.
  • Your browser will then prompt you to save the file to your hard drive. Click OK to complete the download.