Opening and Saving Text CSV Files

Comma Separated Values (CSV) is a text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character.

If the field or cell contains a comma, the field or cell must be enclosed by single quotes (') or double quotes (").

To Open a Text CSV File in Calc

  1. Elektu je Formato - Ĉeloj.

  2. Locate the CSV file that you want to open.

    If the file has a *.csv extension, select the file.

    If the CSV file has another extension, select the file, and then select "Text CSV" in the Filter box

  3. Elektu je Formato - Ĉeloj.

    The Text Import dialog opens.

  4. Specify the options to divide the text in the file into columns.

    You can preview the layout of the imported data at the bottom of the Text Import dialog.

    Right-click a column in the preview to set the format or to hide the column.

    Konsileta bildsimbolo

    Check the text delimiter box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box.


  5. Elektu je Formato - Ĉeloj.

To Save a Sheet as a Text CSV File

note

When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost.


  1. Open the Calc sheet that you want to save as a Text CSV file.

    Nota bildsimbolo

    Only the current sheet can be exported.


  2. Elektu je Formato - Ĉeloj.

  3. In the File name box, enter a name for the file.

  4. En la kadro Filtrilo, elektu je "CSV-teksto".

  5. (Malnepre) agordu la kampajn eblojn por la CSV-teksta dosiero.

    Elektu je Redakti agordojn de filtrado.

    En la dialogo Eksporti tekstajn dosierojn, elektu la eblojn bezonatajn.

    Elektu je Formato - Ĉeloj.

  6. Elektu je Formato - Ĉeloj.

Bonvolu subteni nin!