2 Easy Methods for Creating a CSV File

PDF download Download Article
An easy-to-follow tutorial on making CSV files
PDF download Download Article

Do you need to create a CSV file for your data? A CSV file, which is a “comma-separated values” file, allows you to save your data in a table-structured format, which is useful when importing data into databases and web applications. This wikiHow article teaches you how to create CSV files using Microsoft Excel, OpenOffice Calc, Google Sheets, and in a text editor.

Things You Should Know

  • Using a spreadsheet application like Excel, Google Sheets, or OpenOffice Calc is the easiest way to make CSV files.
  • If you can't use any of those programs, you can use a text editor like Notepad or TextEdit.
  • In a spreadsheet program, go to File > Save As > File Type > CSV . In a text editor, go to "File > Save As > File Type > All Files" and name the file with .csv at the end.
Method 1
Method 1 of 2:

Using a Spreadsheet Application

PDF download Download Article
  1. Open a new spreadsheet in Microsoft Excel , OpenOffice Calc, or Google Sheets . You can use any spreadsheet software to easily convert table data to CSV files. [1]
    • If you want to convert an existing spreadsheet to CSV format, skip to step #4.
  2. For example, if entering data for items you’re selling, type “Item Name” into cell A1, “Item Price” into cell B1, “Item Description” into cell C1, and so on.
    Advertisement
  3. Using the example outlined in step #2, write the item name in cell A2, the item’s price in cell B2, and the item’s description in cell C2.
  4. If using Google Sheets, this option will read as “File > Download as.” [2]
  6. You have now created a CSV file, and commas will automatically be added to the file to separate each field. [3]
    7. Advertisement
Method 2
Method 2 of 2:

Using a Text Editor

PDF download Download Article
  1. Open Notepad on your PC or TextEdit on your Mac. Because CSV files are actually just plain text files in a specific comma-separated format, you can use your computer's built-in text editor to create one. [4]
  2. For example, if entering data for items you’re selling, type the following onto the first line: “name,price,description.” There must be no spaces between items.
  3. Using the example outlined in step #1, write the actual item name, followed by the item’s price and description. For example, if selling baseballs, write “baseball,5.99,sports.” [5]
  4. If leaving any fields empty, make sure you include the comma, or the remaining fields will be off by one.
  5. Alternatively, press Ctrl + S on your keyboard if you're using a PC, or Cmd + S on a Mac. [6]
  6. To do this, click the drop-down menu next to Save as type and select All Files . Next, type a name for your file and end it with .csv .
    • Click Save . You have now created a CSV file that you can easily import into a spreadsheet program, database, or web application.
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I execute a CSV file?
    Community Answer
    CSV files are not executables, so you can’t “run” it like an app. These files are usually read by programs that use it as data.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 2 Helpful 30
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Get a Calendar on Your Desktop
      How to
      Easily Import Data from Evernote to OneNote
      7 Simple Ways to Add a Check Mark to a Word Document
      3 Quick Ways to Open a Pages File on PC or Mac
      How to
      Open WordPad in Windows 10
      How to
      Redact or Black Out Text in Word: 3 Ways
      How to
      View, Open, and Edit a .CSV on Windows or Mac
      How to
      Use Notepad++
      How to
      Delete Recent Documents in Microsoft Word or Excel
      How to
      Change the User Interface Language of LibreOffice
      How to
      Format a Word Document to Look Professional
      A Complete Beginner's Guide to Use LibreOffice
      40 Funny Pranks to Make The Whole Office Laugh
      How to
      Open Notepad
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/use-excel-to-open-or-save-a-worksheet-in-the-opendocument-spreadsheet-ods-format-c7114baa-f08a-49eb-aefd-f5d61ed347cd
      2. ↑ https://support.microsoft.com/en-us/office/save-a-workbook-to-text-format-txt-or-csv-3e9a9d6c-70da-4255-aa28-fcacf1f081e6
      3. ↑ https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
      4. ↑ https://support.apple.com/guide/textedit/open-documents-txte51413d09/mac
      5. ↑ https://support.microsoft.com/en-us/office/create-or-edit-csv-files-to-import-into-outlook-4518d70d-8fe9-46ad-94fa-1494247193c7
      6. ↑ https://support.microsoft.com/en-us/windows/help-in-notepad-4d68c388-2ff2-0e7f-b706-35fb2ab88a8c

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 435,031 times.

      Is this article up to date?

      Advertisement