How To: Saving a Spreadsheet as Comma Delimited File using OpenOffice Calc

Overview

Some selections in Tyler require you to create a spreadsheet and then save it as a comma delimited/comma separated values file (.csv) in order to upload it to your system (e.g Cash Receipts Input File (12-01-02)).

This tutorial describes how to do this using OpenOffice Calc.

Step-by-Step

1. Create your spreadsheet.

2. When you are ready to save, select ‘Save As’ from the ‘File’ menu.

3. Select ‘Text CSV (.csv)’ from the ‘Save as Type’ drop-down list.

4. Specify a save location.

5. Enter the name of the file in the ‘File Name’ box. Make sure that the ‘Automatic file name extension’ box is checked.

6. Click ‘Save.’

7. Depending on how OpenOffice Calc is set up, you might receive a message explaining that some of the formatting cannot be saved in the Text CSV file format. Click the ‘Keep Current Format’ button at this prompt.

8. The ‘Export of text files’ window appears.

9. In the ‘Field delimiter’ box, select ‘,’ (the comma) from the drop-down list.

10. Clear the entry in the ‘Text delimiter’ box so that it is completely blank.

11. Verify that the ‘Save cell content as shown’ box is checked.

12. Click OK.

13. Click OK at the warning message.