Related Articles

• 1 Convert a Spreadsheet Into a Comma-Delimited String
• 2 Make Excel 2007 Your Default Program
• 3 Convert CSV to Metastock Format
• 4 OpenOffice Calc: Encrypt a File

Just as the .docx file format serves as the default for Microsoft Word documents, the OpenDocument Text file format forms the default for the open-source Apache OpenOffice Writer application. The comma-separated values file format uses text files to convey comma-delimited information that functions like the rows in a spreadsheet or records in a database. With commas between each chunk of information, a single line of text comprises an individual data record. Turning an ODT file into CSV text requires almost the same process you'd use to turn a Word document into CSV.

Each file type has a default application that is associated with it. This means that when you double-click a file from the Finder it will open a specific application, for example on a fresh Mac OS X installation, all image files (png, jpg, gif, pdf, etc) will default to opening in Preview, and all text documents (txt, rtf, etc) will open in TextEdit. Aug 25, 2018  First, you say you are trying to download a chart and it is in CSV format. The CSV file will not contain a chart, but will contain data from which a chart might be created. Save the file; then double click it and OpenOffice will open it with whatever application has been set as the default for CSV files.

IntelligenceBank marketing operations software helps content marketers seamlessly manage digital assets, creative content approvals and compliance, and creative project management. We offer 24/7 support with offices in the US, Australia, and Canada. Our beautifully designed software is used by over 400 brands globally. Samsung smart tv channels list. M3U and M3U8 Export Tool is a Windows program designed to solve a step in the chain of actions required to make you a cheap DJ who plays music from a USB stick. Through integrating Digital Asset Management (DAM), online brand guidelines, marketing workflows and approvals with calendars and kanban, IntelligenceBank gives you a way to easily manage marketing and creative projects from end to end, within the one system.

Launch Microsoft Word and click on the 'File' tab in the ribbon interface. Click on the 'Open' option and set the 'File of Type' drop-down menu to 'OpenDocument Text.'

Navigate to the location of your ODT file. Click on the 'Open' button or double-click on the file name to open it.

Examine the text in your file. It should appear in single-spaced rows of text, with each line comprised of the same number of comma-separated items and no extra carriage returns creating blank lines.

Edit your text to comply with the specifications of the CSV format. CSV must consist of plain text, with no graphics or formatting. If you find a value that contains a comma, type double quotation marks around it so the program into which you import the CSV file recognizes the comma as part of the text and not a delimiting divider. Place the delimiting comma outside the quotation marks.

Click on the File tab and choose 'Save As' to open the Save As dialog box. Set the 'Save as Type' drop-down menu to 'Plain Text.' Select a location for your CSV file and click on the 'Save' button.

Open your CSV file in Windows Notepad. Open the 'File' menu and choose 'Save As.' Select the '.txt' file extension in the file name box, change it to '.csv' and save this new document version for use in applications that can't recognize the CSV format without a corresponding file name. If you're targeting your file at Microsoft Excel, you can use either version of your CSV document.

This is also inevitable because the following levels are not easy to overcome. However, it still stimulates the desire to conquer players and I think this is the attraction that the game is aimed at and you can exploit the attractions from here.

Tips

• To transform an ODT file into CSV text in Apache OpenOffice, LibreOffice or NeoOffice, open the file in the word-processing module of your favorite open source office suite and adjust your text to meet the demands of the CSV format.
• Any record in which a specific item, or field, remains blank should contain a delimiting comma that acts as a placeholder for the empty field. For example, if one record contains the values 'cat, dog, mouse, rabbit,' and the next record lacks the third value, it should appear as 'bird, gerbil,horse.'
• To distinguish further between the original ODT file and the CSV version you created, change the CSV file name so it doesn't match the original.
• If you edit the ODT file heavily to make it compliant with the CSV format, save a copy of your work, either in ODT or in DOCX format. Be careful not to overwrite the original ODT file.

Warning

• Test your CSV file in the program in which you plan to use it and edit it if it fails to import properly.

About the Author

Elizabeth Mott has been a writer since 1983. Mott has extensive experience writing advertising copy for everything from kitchen appliances and financial services to education and tourism. She holds a Bachelor of Arts and Master of Arts in English from Indiana State University.

Choose Citation Style

CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft Excel or OpenOffice Calc.

CSV stands for 'comma-separated values'. Its data fields are most often separated, or delimited, by a comma. For example, let's say you had a spreadsheet containing the following data.

The above data could be represented in a CSV-formatted file as follows:

Here, the fields of data in each row are delimited with a comma and individual rows are separated by a newline.

A CSV is a text file, so it can be created and edited using any text editor. More frequently, however, a CSV file is created by exporting (File > Export) a spreadsheet or database in the program that created it. Click on a link below for the steps to create a CSV file in Notepad, Microsoft Excel, OpenOffice Calc, and Google Docs.

Notepad (or any text editor)

To create a CSV file with a text editor, first choose your favorite text editor, such as Notepad or vim, and open a new file. Then enter the text data you want the file to contain, separating each value with a comma and each row with a new line.

Save this file with the extension.csv. You can then open the file using Microsoft Excel or another spreadsheet program. It would create a table of data similar to the following:

In the CSV file you created, individual fields of data were separated by commas. But what if the data itself has commas in it?

If the fields of data in your CSV file contain commas, you can protect them by enclosing those data fields in double quotes ('). The commas that are part of your data are kept separate from the commas which delimit the fields themselves.

For example, let's say that one of our text fields is a user-created description that allows commas in the description. If our data looked like this:

To retain the commas in our 'Notes' column, we can enclose those fields in quotation marks. For instance:

As you can see, only the fields that contain commas are enclosed in quotes.

The same goes for newlines which may be part of your field data. Any fields containing a newline as part of its data need to be enclosed in double quotes.

If your fields contain double quotes as part of their data, the internal quotation marks need to be doubled so they can be interpreted correctly. For instance, given the following data:

We can represent it in a CSV file as follows:

Here, the entire data field is enclosed in quotes, and internal quotation marks are preceded (escaped by) an additional double quote.

Here are the rules of how data should be formatted in a CSV file, from the IETF's document, RFC 4180. In these examples, 'CRLF' is used to represent a carriage return and a linefeed (which together constitute a newline).

1. Each record (row of data) is to be located on a separate line, delimited by a line break. For example:
   
2. The last record in the file may or may not have an ending line break. For example:
   
3. There may be an optional header line appearing as the first line of the file with the same format as normal record lines. The header contains names corresponding to the fields in the file. Also, it should contain the same number of fields as the records in the rest of the file. For example:
   
4. In the header and each record, there may be one or more fields, separated by commas. Each line should contain the same number of fields throughout the file. Spaces are considered part of a field and should not be ignored. The last field in the record must not be followed by a comma. For example:
   
5. Each field may or may not be enclosed in double quotes. If fields are not enclosed with double quotes, then double quotes may not appear inside the fields. For example:
   
6. Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double quotes. For example:
   
7. If double quotes are used to enclose fields, then a double quote appearing inside a field must be escaped by preceding it with another double quote. For example:
   

Microsoft Excel

To create a CSV file using Microsoft Excel, launch Excel and then open the file you want to save in CSV format. For example, below is the data contained in our example Excel worksheet:

Once open, click File and choose Save As. Under Save as type, select CSV (Comma delimited) or CSV (Comma delimited) (*.csv), depending on your version of Microsoft Excel.

After you save the file, you are free to open it up in a text editor to view it or edit it manually. Its contents will resemble the following:

The last row begins with two commas because the first two fields of that row were empty in our spreadsheet. Don't delete them — the two commas are required so that the fields correspond from row to row. They cannot be omitted.

OpenOffice Calc

To create a CSV file using OpenOffice Calc, launch Calc and open the file you want to save as a CSV file. For example, below is the data contained in our example Calc worksheet.

Once open, click File, choose the Save As option, and for the Save as type option, select Text CSV (.csv) (*.csv).

After you save the file, if you were to open the CSV file in a text editor, such as Notepad, the CSV file should resemble the example below.

As in our Excel example, the two commas at the beginning of the last line make sure the fields correspond from row to row. Do not remove them!

Google Docs

Open Google Docs and open the spreadsheet file you want to save as a CSV file. Click File, Download as, and then select CSV (current sheet).

Additional information

• See our CSV definition for further information and related links.