Advice 1: How to create a CSV file

CSVfiles are designed for storing tabular data in plain text files. To open such a file requires no special software to work with tables, any simple text editor. This format is often used different kinds of scripts to store small amounts of data.
How to create a CSV file
Instruction
1
Use a simple text editor (e.g. Notepad) for the "manual" creation of the CSV file. If you need a file that does not contain any data, then just save the blank document with the extension. csv for example, data.csv.
2
Separate the contents of adjacent columns of the table the decimal, if the file should be placed some tabular data. The name of this format (CSV - Comma Separated Values) is translated to English as "comma separated values". However, it is more convenient and therefore more frequently used is the division of values with a semicolon. It is connected with the factthat in most non-English speaking countries a comma is used as separator of the integer and fractional parts of real numbers.
3
Place in each row in the CSV file only one line of tabular data. That is a sign of the end of the string is the separator between the table rows contained in this file.
4
Use the table editor, if you don't want to create a CSV file yourself. Most programs for working with tables can read and save data in this format. For example, you can use office Excel 2007. Creating (or opening) in it the table you want to save to a CSV file, click the big round Office button in the upper left corner of the editor window. In the drop-down menu go to "Save as" and select the bottom item - "Other formats". This menu item assigned hot key is F12 - you can use it.
5
Expand the dropdown list "files of Type" and select "CSV (comma delimited)". Then in the "file Name" enter a name, select the storage location and click "Save".
6
The answer is in the affirmative (buttons "OK" and "Yes" to the questions Excel asks twice before saving the file. In this way the editor will warn you that the CSV format does not support formatting of the text, use "books" and "pages", formulas in cells of other options available in the native formats of the table editor.

Advice 2: Sozdati two text files

A text file is a computer file that contains any character in any encoding. In other words, in addition to plain text, many formats of text files can store special characters. Depending on the software in which you created the text file, it can include additional objects, such as images, tables, charts, links, and more.
Sozdati two text files
Instruction
1
Notepad – free text editor Windows that has only one purpose – the creation of text notes. It has no formatting, inserting media – only black text on a white background. To create a text file in Notepad, click "start", go to the folder "All programs", then "accessories" and find the program "Notepad". Start Notepad.
You will see a working box to enter the text of the new file. To save it, click the top menu "File" - "Save". In the window that appears, enter a name for the new file, select the location where this file should be saved and click "Save". The file will be saved in the format “.txt”.
2
Also WordPad is a free text app Windows, but unlike Notepad, it has some formatting and inserting objects. WordPad is where the Notepad: start – All programs – accessories – WordPad.
To save the file in WordPad, click "File" or the blue rectangular button in the upper left corner of the program (in Windows 7) and select Save. In the appeared window enter the desired name and click "Save". The text will be saved in the format “.rtf”.
3
And finally, one of the most powerful text editors – Microsoft Word program from Microsoft Office. Unlike Notepad and WordPad, MS Word is a paid program. In MS Office find Word, run it. To save the text file in the top menu select "File" - "Save". When you save a text file, you can choose any format from a huge number offered. The standard format is a Word “.doc” (2007).docx” (after 2007). Enter the desired name for the file and click Save.

Advice 3: How to open csv file

Because of its simplicity the CSV format is often used by applications to store data in tabular structures. The simplicity of the format and identifies its shortcomings - in the General case it is unknown which encoding is used to stored the data in that csv file, what are used delimiters of the columns, the constraints of the text. But what if you need to open csv file to view the data contained in it?
How to open csv file
You will need
  • - installed Microsoft Office Access.
Instruction
1
Create a new database in Microsoft Office Access, which will be placed in information from a CSV file for later viewing. Select the menu items "File" and "new" and click "New database..." in the appeared panel. Dialog appears "File new database". Select the target folder and file name database. Click "Create".
How to open csv file
2
Start the process of loading data from a file. In the menu select "get External data" and "Import...". In the drop-down list of "file Type" appeared dialogue "Import", select "Text files". Navigate to the directory with a CSV file, select it in the directory listing, click the "Import" button. Displays the wizard window "text Import".
How to open csv file
3
Define the format properties of the data imported from the CSV file. Click "Advanced". In the dialogue "...the import specification" specify the type of field format, field delimiter characters, the time, date, parts of decimal numbers and the format of the date, symbol, text qualifier, and encoding text. Press the OK button. Click "Next".
How to open csv file
4
Specify the rules of interpretation of the data of the first line of the file. On the second page of the wizard, select the check box "First row contains field names" if necessary. Focus on content-based list, which displays the first few lines of the file. Click "Next".
How to open csv file
5
Select "new table". Click "Next".
How to open csv file
6
Define the column names and format data contained therein, if necessary. On the fourth page of the wizard, click on the desired column list where you can preview the file content, type the new name in the text field "field name" and select a format from the drop-down list "data type". Click "Next".
How to open csv file
7
Select the option "do not generate key". Click "Next".
How to open csv file
8
Enter a convenient name in the "Import to table". Click "Next". Wait for the import process.
How to open csv file
9
Open data from a CSV file. Click on the tab "Tables". Double click on the list element with the name specified in the previous step. Review the details.
How to open csv file
Is the advice useful?
Search