How To Open A Csv File

Table of contents:

How To Open A Csv File
How To Open A Csv File

Video: How To Open A Csv File

Video: How To Open A Csv File
Video: How to Open CSV File in Excel 2024, March
Anonim

Because of its simplicity, the CSV format is often used by applications to store data in a tabular structure. The simplicity of the format also determines its drawbacks - in general, it is not known in what encoding the data is stored in a particular csv file, what are the used column separators, text delimiters. But what if you need to open a csv file and view the data contained in it?

How to open a csv file
How to open a csv file

Necessary

installed Microsoft Office Access

Instructions

Step 1

Create a new database in Microsoft Office Access into which the information from the CSV file will be placed for later viewing. Select the menu items "File" and "New" and click on the link "New database …" in the panel that appears. The "New Database File" dialog will be displayed. Select the directory for saving and the name of the database file in it. Click the Create button.

How to open a csv file
How to open a csv file

Step 2

Begin the process of loading data from a file. In the menu, select the items "External data" and "Import …". In the drop-down list "Files of type" of the "Import" dialog that appears, select "Text files". Go to the directory with the CSV file, select it in the directory listing, click the "Import" button. The "Import Text" wizard appears.

How to open a csv file
How to open a csv file

Step 3

Define the format properties of the data to be imported from the CSV file. Click the Advanced button. In the "… - import specification" dialog specify the field format type, field separators, time, date, parts of decimal numbers, as well as the date format, text delimiter character and text encoding. Click OK. Click "Next".

How to open a csv file
How to open a csv file

Step 4

Specify the rules for interpreting the data on the first line of the file. On the second page of the wizard, select the "First line contains field names" check box if necessary. Navigate based on the contents of the list, which displays the first few lines of the file. Click "Next".

How to open a csv file
How to open a csv file

Step 5

Check the "in a new table" option. Click "Next".

How to open a csv file
How to open a csv file

Step 6

Determine the names of the columns and the format of the data they contain, if necessary. On the fourth page of the wizard, click on the required column of the list in which the file contents are previewed, enter its new name in the “field name” text box and select a format from the “data type” drop-down list. Click "Next".

How to open a csv file
How to open a csv file

Step 7

Select the option "do not create a key". Click "Next".

How to open a csv file
How to open a csv file

Step 8

Enter a convenient name in the "Import to Table" field. Click "Next". Wait for the import process to finish.

How to open a csv file
How to open a csv file

Step 9

Open the data from the CSV file. Click on the "Tables" tab. Double click on the list item with the name specified in the previous step. Review the data.

Recommended: