How To: Saving a Spreadsheet as a Tab Delimited File Using OpenOffice Calc

Overview

Some selections in Tyler require you to create a spreadsheet and then save it as a ‘tab delimited’ file in order to upload it to your system (i.e. Bottom Text Load for Form L (02-18-15)).

This tutorial describes how to save a spreadsheet as a tab delimited file 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 {Tab} 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.