If the CSV file uses a text delimiter character that is not in the Text delimiter list, click in the box, and type the character.Right-click a column in the preview to set the format or to hide the column. You can preview the layout of the imported data at the bottom of the dialog.On the Text Import dialog (below), select the Separator options to divide the text in the file into columns.If the file has another extension (for example, *.txt), select the file otherwise select Text CSV in the File type box (scroll down into the spreadsheet section to find it) and then click Open.If the file has a *.csv extension, select the file and click Open.If you dont have OpenOffice installed on computers in your office, you can use Microsoft Excel 2010, part of the Microsoft Office 2010 software suite, to open the ODS files. Locate the CSV file that you want to open. Files that have an ODS extension are spreadsheet files created with OpenOffice, the open-source office software suite from Apache.The list displays the last 10 files that were opened in any of the OOo components. This list can be accessed from the File menu, directly below Open. You can also open a spreadsheet that has been recently worked on using the Recent Documents list.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |