Written by Kirill Vasilyev on July 27, 2010 at 9:00 AM
In this article, I will teach you how to export any Open Office / Neo Office spreadsheet into a CSV file. CSV format is pretty standardized and can be used with almost any software that has file import feature. You can use CSV to transfer database information between several software products or use it to backup information you have in your software products.
CSV is always a plain text file, normally in unicode UTF-8 or UTF-16 text encoding. Every line of the file represents one record (a single customer record) that contains information about your customer in the form of data fields (such as name, email address, phone number, etc.) separated by a comma(normally), semicolon or TAB.
If your spreadsheet contains customers with Order, Name, Email, Product and Website columns, your CSV file would look as pictured below:
Note that the second example contains quotes around the data fields. The quote character is called Qualifier. Some spreadsheet processors add it for better clarity in case if commas are used in the fields. Normally, either quotes or apostrophes are used as qualifiers. Comma here is called Field Separation Character or delimiter. It can be comma, semicolon or TAB. By default Open Office / Neo Office uses comma as delimiter and quotes as qualifiers (the second example).
How to create a CSV file in Open Office or Neo Office
Open Office and Neo Office are identical in terms of making CSV files. Below is the example for Open Office, but if you have Neo Office, simply make the same steps.
1. Start the spreadsheet processor of Open Office / Neo Office.
2. Open your spreadsheet file.
3. Use the File->Save As… command in the main menu to open the Save dialog box.
4. When the Save dialog box is open, specify the file type as Text CSV (.csv) using the File Type combo box.
5. Specify file name and location using the Save As and Location boxes in the Save dialog box. The correct file extension for a CSV file would be .csv
6. If the following dialog box appears on the screen, press the Keep Current Format button on it.
7. Press the Save button and you will see another dialog box where you can specify the format of your CSV file.
You can leave the default format, but note you are using the quotes qualifier (here it is called Text Delimited). You will need to specify it in MacMassMailer when you import such a file. Also, you must use the Unicode UTF-8 or UTF-16 text encoding.
8. Press the Ok button and in a few seconds a new CSV file is created at the location you have specified.