Importing and Exporting Comma and Tab Delimited Files

From NeoWiki

Revision as of 19:31, 20 April 2007 (edit) Jgd (Talk | contribs) ← Previous diff		Revision as of 19:57, 20 April 2007 (edit) (undo) Lorinda (Talk | contribs) m (just a little polish) Next diff →
Line 1:		Line 1:
	{{Fixme}}		{{Fixme}}
-	The file type Text CSV (Comma Separated Values) separates data fields by using delimiters such as commas, tabulations, etc. Using that format in NeoOffice allows you to import the data of a text file into a spreadsheet in order to use the document as a data base. Conversely, you can export the data of a spreadsheet into a text document.	+	The file type Text CSV (Comma Separated Values) separates data fields by using delimiters such as commas, tab, etc. Using the csv format in NeoOffice allows you to import the data of a text file into a spreadsheet (in order to use the document as a data base, for example). Conversely, you can export the data of a spreadsheet to a csv formatted file for use in a text document.
	==Importing a Text File into Calc==		==Importing a Text File into Calc==
Line 12:		Line 12:
	'''N.B''' If the file has the <tt>.csv</tt> extension, you simply double-click it to display the {{window|Text Import}} dialog.		'''N.B''' If the file has the <tt>.csv</tt> extension, you simply double-click it to display the {{window|Text Import}} dialog.
-	==Exporting a Spreadsheet into Text Format ==	+	==Exporting a Spreadsheet as a CSV File ==
	* In the spreadsheet you want to save as a Text CSV file, choose the {{menu|File}} menu, then the {{menu|Save as…}} submenu.		* In the spreadsheet you want to save as a Text CSV file, choose the {{menu|File}} menu, then the {{menu|Save as…}} submenu.
	* A dialog opens. In the {{section|File type}} drop-down menu choose {{prefName|Texte CSV (.csv)}}.		* A dialog opens. In the {{section|File type}} drop-down menu choose {{prefName|Texte CSV (.csv)}}.

---

Revision as of 19:57, 20 April 2007

The file type Text CSV (Comma Separated Values) separates data fields by using delimiters such as commas, tab, etc. Using the csv format in NeoOffice allows you to import the data of a text file into a spreadsheet (in order to use the document as a data base, for example). Conversely, you can export the data of a spreadsheet to a csv formatted file for use in a text document.

Importing a Text File into Calc

To import a file saved in .txt or .csv format, follow the steps below:

• In the File menu, choose Open….
• In the dialog which opens, in the File type drop-down menu, choose Text CSV.
• Select the file you want to import and click Open.
• In the Text Import dialog, select the row from which you want to import the text and the separator used in the file which you import, e. g. Tab.
• In the Fields section, choose the Column type for each column. You can hide some columns, they will not be imported.
• Click OK.

N.B If the file has the .csv extension, you simply double-click it to display the Text Import dialog.

Exporting a Spreadsheet as a CSV File

• In the spreadsheet you want to save as a Text CSV file, choose the File menu, then the Save as… submenu.
• A dialog opens. In the File type drop-down menu choose Texte CSV (.csv).
• Select Edit filter settings
• Give a name to your document and choose the location where you want save it. Click Save.
• In the window where you are asked for confirmation, click Yes to save the file in Text CSV format.
• In the Export of text files window, choose the Character set, e. g. Unicode (UTF-8) and the Field delimiter, e. g. {Tab} .
• Click OK.
• The file can be converted into .txt format by changing the extension in the Finder: select the file, then press Return or Enter and replace .csv with .txt.