Importing and Exporting CSV Files /text/scalc/guide/csv_files.xhpnumber series importdata series importexporting; tables as textimporting; tables as textdelimited values and filescomma separated files and valuestext file import and exportcsv files;importing and exportingtables; importing/exporting as texttext documents; importing to spreadsheetsMW deleted "importing;text data bases" and copied 4 index entries from scalc/guide/csv_formula.xhpOpening and Saving Text CSV Files
Comma Separated Values (CSV) is 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 content of a field or cell contains a comma, the contents of the field or cell must be enclosed by single quotes (') or double quotes (").To Open a Text CSV File in CalcChoose File - Open.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 File type boxClick Open.The Text Import dialog opens.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.If the CSV file uses a text delimiter character that is not listed in the Text delimiter box, click in the box, and type the character.Click OK.To Save a Sheet as a Text CSV FileWhen 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.Open the Calc sheet that you want to save as a Text CSV file.Only the current sheet can be exported.Choose File - Save as.In the File name box, enter a name for the file.In the File type box, select "Text CSV".(Optional) Set the field options for the Text CSV file.Select Edit filter settings.In the Export of text files dialog, select the options that you want.Click OK.Click Save.Tools - Options - %PRODUCTNAME Calc - ViewExport text filesImport text files