From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/guide/csv_files.xhp | 104 +++++++++++++++++++++ 1 file changed, 104 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/csv_files.xhp (limited to 'helpcontent2/source/text/scalc/guide/csv_files.xhp') diff --git a/helpcontent2/source/text/scalc/guide/csv_files.xhp b/helpcontent2/source/text/scalc/guide/csv_files.xhp new file mode 100644 index 000000000..d0cbd01f0 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/csv_files.xhp @@ -0,0 +1,104 @@ + + + + + + + + Importing and Exporting CSV Files +/text/scalc/guide/csv_files.xhp + + + +number series import +data series import +exporting; tables as text +importing; tables as text +delimited values and files +comma separated files and values +text file import and export +csv files;importing and exporting +tables; importing/exporting as text +text documents; importing to spreadsheets +opening;text csv files +saving;as text csv +MW deleted "importing;text data bases" and copied 4 index entries from scalc/guide/csv_formula.xhpmw added "saving;" and "opening;" +

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

+ + +Choose 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 Filter box + + +Click 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. +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. + + +Click OK. + + +

To Save a Sheet as a Text CSV File

+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. + + +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 Filter 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. + + +
+ + +%PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View +Export text files +Import text files +
+ + -- cgit v1.2.3