Program for editing csv 2.0 contacts. Proper editing of CSV files in Calc. Create an Excel file and save it as a CSV

Many applications use the CSV format when working with data. The convenience of CSV files is that all data is stored as plain text, and fields are separated using a delimiter character (usually a semicolon ";", but can be any other character of the user's choice). However, with a large number of entries in the data table, processing a CSV file in a standard text editor becomes difficult and inconvenient. CSVed is designed to make editing CSV files easier. This program performs both all standard functions (adding, inserting, deleting, moving and changing data in table cells), as well as a whole set of specialized functions that make editing a CSV file much easier.

So, open any text file in CSV or TXT format in CSVed. The text from the file is displayed in the table in line-by-line mode if the program could not determine the separator character.

Double clicking on any entry opens a separate editor window that displays the text of the selected entry. The window provides tools for moving through the records - to the first, previous, last or next. Here you can also correct the text and save the changes by pressing the button. .

As you can see in the first screenshot, by default CSVed displays all data line by line, without splitting by columns. To change the display mode of the CSV file records, select the delimiter character in the list (tab Start and Item Edit), in our example it is " ; ". Right there in the field Set Start Row, you can specify from which row to start displaying data in the table. As a result, the data will be reformatted into a table view, that is, each fragment of the line between the separators will be displayed in a separate cell.

After switching to the normal mode of displaying data by cells, taking into account the separators, the editing window looks more convenient:

In chapter Edit Item There are four buttons designed to perform basic standard operations:
– editing the selected entry;
– inserting a new record before the selected line;
– adding a new entry to the end of the list;
– deleting the selected entry.

You can edit the contents of a cell not only in a separate window of the CSVed editor, but also next to the table. To do this, turn on the mode Tools-Cell Edit, after which a row appears above the table with the value in the selected cell. Now just click in the cell and change its value in the row and confirm by pressing the key Enter . And by checking the box Enable Direct Editing, we will be able to make changes in the edit line, which will simultaneously be displayed in the table cell.

CSVed provides many more useful features that reduce the time it takes to edit a CSV file:
- work with data columns, you can copy from one column to another, move them, delete or add (tab Column Edit); there are also functions for adding line numbering (random or in order), as well as global changes in values ​​in the selected column.

tab Join and Split contains tools for combining or splitting data. So, here you can combine the selected columns of the table ( Join Columns). We can also split one column into several ( Split Column), including indicating the position of the text from which to start the division. There is also an additional option to split into two CSV files starting from the selected column (Split File).

In the tab Leading Zeros collected tools for removing leading zeros in data. For example, if there are records where numbers start with zeros, CSVed will help you quickly find them and delete them with one click ( Delete Leading Zeros). There is also a function that is inverse to the result - adding leading zeros to those fields where they are missing ( Add Leading Zeros). As a result, the number of digits in all numbers of the selected column becomes the same due to the added zeros.

tab Modify provides functionality to add a prefix or suffix to all data fields in a selected column ( Add Value). Here you can also add the entered characters to each cell after the specified character number.

Data filtering options are configured in the tab Filter and Dups. Here in the field Filter Text enter the search text and select the column. As a result, all records containing the search phrase will be highlighted in red. Selected records can be deleted or written to a separate CSV file ( Save Filtered Items). In addition, CSVed can find duplicate records and remove them ( Remove Duplicates).

We also note such features of the CSVed editor as sorting alphabetically, saving a selected part of the data to a separate file, and searching in a table. The program is able to check the correctness of the data structure and, if there are errors, correct them. The program also has a built-in text mini-editor that allows you to edit the CSV file in plain text mode. Linux users may find it useful to save the file in UNIX format ( File – Save in UNIX Format). The program supports skins, there are a dozen and a half to choose from.

The program's export capabilities are impressive. CSVed can save data in XML, HTML, XLS (Excel), DOC (Word), RTF, MS Access, Open Office, various versions of DBF (Fox Pro), Lotus 1-2-3, Quattro Pro, Adobe PDF.

Finally, we note that if the text contains Cyrillic characters and they are displayed incorrectly, go to the menu View-Font and in the list Character set choose Cyrillic.

Characteristics:
Interface language: English
OS: Windows 2000, XP, Vista
File size: 1.8 MB
License: free

Actual for version 2.9

The "Data Exchange" module provides the ability to export and import data in CSV text format.

If we open the resulting file in a text editor, we will see a set of data enclosed in double quotes and separated by a semicolon:

"25";"Akai AP-A206C";"116";"1";"2";"9";"Akai AP-A206C";"Akai AP-A206C";168;"/images/cms/data/akai_ap-a206c.jpg";"4.9";"Black";"5";"DVD"; "0";"1";"";"";""

If there is a lot of data, it will be very difficult to understand them. The best way to edit such files is to use the LibreOffice Calc spreadsheet (free product).

Consider working with a CSV file in LibreOffice Calc.

1. Having launched the program, open our file with the command File>Open
2. The program, recognizing that we are opening a text file, offers a window with import settings. Here it is important to pay attention to the encoding (Windows-1251), separator (semicolon) and text separator (double quotes):

3. Having finished working with the file. Select all table cells by pressing the key combination Ctrl+A. Let's give a command Format>Cells. Select a category in the dialog box that opens. Text and press the OK button.


4. Let's give a command File>Save As... In the window that opens, make sure that the file type is correct (.csv) and be sure to enable the " Changing filter settings".


5. After clicking save, the program will open a window with text export settings. Here, as an encoding, we choose Windows-1251, as a field separator - semicolon symbol, as text separator - double quote character, and enable the " Quoted text values", press OK.

As a result, we got valid a file that can be used when importing data from CSV format into the UMI.CMS database.

It is not recommended to use the Microsoft Office Excel program to work with the CSV format, since after saving the data is not enclosed in double quotes, which may cause a data parsing error when importing such a file into UMI.CMS.

CSV (Comma-Separated Values) is a text format file that is designed to display tabular data. The columns are separated by commas and semicolons. We will find out with what applications you can open this format.

As a rule, spreadsheets are used to correctly view CSV content, and text editors can also be used to edit them. Let's take a closer look at the algorithm of actions when opening this type of file with various programs.

Method 1: Microsoft Excel

Consider how to run CSV in the popular word processor Excel, which is included in the Microsoft Office package.

There is another way to go to "Master of Texts".

1. Move to section "Data". Click on an object "From the text" placed in the block "Getting External Data".



2. Tool appears "Import Text File". Same as window "Opening Document", here you need to go to the area where the object is located and mark it. You do not need to select formats, as objects containing text will be displayed when using this tool. click "Import".



3. is running "Master of Texts". In the first window "Specify Data Format" put the radio button in position "With separators". In area "File format" parameter should be "Unicode (UTF-8)". Click "Further".



4. Now it is necessary to perform a very important step, on which the correctness of the data display will depend. You need to specify what exactly is considered a separator: a semicolon (;) or a comma (,). The fact is that in different countries different standards are applied in this regard. So, for English-language texts, a comma is more often used, and for Russian-language texts, a semicolon. But there are exceptions when delimiters are used the other way around. In addition, in very rare cases, other characters are used as delimiters, such as a wavy line (~).

   Therefore, the user must determine whether in this case a particular character serves as a separator or is a regular punctuation mark. This he can do by looking at the text that is displayed in the area. "Sample Data Parsing" and based on logic.

   

   After the user determines which character is the separator, in the group "The separator character is" check the box next to "Semicolon" or "Comma". All other items should be unchecked. Then press "Further".



5. After that, a window opens in which, by highlighting a specific column in the area "Sample Data Parsing", you can assign a format to it for the correct display of information in the block "Column Data Format" by toggling the radio button between the following positions:
   • skip column;
   • text;
   • date of;
   • general.

   After performing the manipulations, press "Ready".



6. A window appears asking where exactly to place the imported data on the sheet. By switching the radio button, you can do this on a new or existing sheet. In the latter case, you can also specify the exact location coordinates in the corresponding field. In order not to enter them manually, it is enough to put the cursor in this field, and then select the cell on the sheet that will become the upper left element of the array where the data will be added. After setting the coordinates, press OK.



7. The contents of the object will be displayed on the Excel sheet.

Method 2: LibreOffice Calc

Another spreadsheet processor, Calc, included in the LibreOffice assembly, can also run CSV.

1. Launch LibreOffice. click "Open file" or use Ctrl+O.

   

   You can also navigate through the menu by pressing "File" And "Open…".

   

   In addition, the opening window can also be accessed directly through the Calc interface. To do this, while in LibreOffice Calc, click on the folder icon or type Ctrl+O.

   

   Another option provides for a sequential transition through the points "File" And "Open…".



2. Using any of the many listed options will result in a window "Open". Move in it to the location of the CSV, mark it and click "Open".

   

   But you can even do without launching a window "Open". To do this, drag the CSV from "Explorer" at LibreOffice.



3. Tool appears "Text Import", which is analogous to "Masters of Texts" in Excel. The advantage is that in this case you do not have to navigate between different windows when making import settings, since all the necessary parameters are located in one window.

   Go directly to the settings group "Import". In area "Encoding" choose value "Unicode (UTF-8)", if it displays otherwise. In area "Language" select the text language. In area "From the Line" you need to specify from which line you should start importing content. In most cases, this setting does not need to be changed.

   Next we move on to the group. "Delimiter Options". First of all, you need to set the radio button to the position "Delimiter". Further, according to the same principle that was considered when using Excel, you need to specify by checking the box next to a certain item what exactly will play the role of a separator: a semicolon or a comma.

   "More Options" leave it unchanged.

   You can preview how the imported information looks like when you change certain settings in the lower part of the window. After entering all the necessary parameters, press OK.



4. The content will be displayed through the LibreOffice Calc interface.

Method 3: OpenOffice Calc

You can view CSV using another spreadsheet - OpenOffice Calc.

1. Launch OpenOffice. In the main window, click "Open…" or use Ctrl+O.

   

   You can also use the menu. To do this, go to the points "File" And "Open…".

   

   As with the method used with the previous program, you can get to the object opening window directly through the Calc interface. In this case, you need to click on the icon in the folder image or apply all the same Ctrl+O.

   

   You can also use the menu by going through the positions in it "File" And "Open…".



2. In the opening window that appears, go to the CSV placement area, select this object and click "Open".

   

   You can do without launching this window by simply dragging the CSV from "Explorer" at OpenOffice.



3. Any of the many described actions will activate the window "Text Import", which is very similar both in appearance and functionality to the tool with the same name in LibreOffice. Accordingly, perform exactly the same actions. In the fields "Encoding" And "Language" expose "Unicode (UTF-8)" and the language of the current document, respectively.

   In the block "Delimiter Options" put a radio button next to the item "Delimiter", then check the box next to ( "Semicolon" or "Comma") that matches the separator type in the document.

   After performing the above steps, if the data in the preview form displayed at the bottom of the window is displayed correctly, click OK.



4. The data will be successfully displayed through the OpenOffice Calc interface.

Method 4: Notepad

You can use normal Notepad for editing.

Method 5: Notepad++

You can also open it with a more advanced text editor - Notepad ++.

Method 6: Safari

You can view the content in text form without the possibility of editing it in the Safari browser. Most other popular browsers do not provide this feature.

Method 7: Microsoft Outlook

Some CSV objects are emails exported from an email client. They can be viewed using the Microsoft Outlook program by performing the import procedure.

1. Launch Outlook. After opening the program, go to the tab "File". Then click "Open" in the side menu. Next click "Import".



2. is running "Import and Export Wizard". Choose from the list below "Import from another program or file". Click "Further".



3. In the next window, select the type of object to import. If we are going to import CSV, then we need to select a position "Comma Separated Values ​​(Windows)". Click "Further".



4. In the next window, click "Review…".



5. A window appears "Review". In it, you should go to the place where the letter in CSV format is located. Select this element and click OK.



6. Returns to the window "Import and Export Wizard". As you can see, in the area "File to import" an address has been added to the location of the CSV object. In the block "Options" settings can be left as default. Click "Further".



7. Then you need to mark the folder in the mailbox where you want to place the imported correspondence.



8. The next window will display the name of the action to be performed by the program. Just click here "Ready".



9. After that, to view the imported data, move to the tab "Sending and Receiving". In the side area of ​​the program interface, select the folder where the letter was imported. Then, in the central part of the program, a list of letters in this folder will appear. It is enough to double-click on the desired letter with the left mouse button.



10. The letter imported from the CSV object will be opened in Outlook.

However, it is worth noting that not all CSV format objects can be launched in this way, but only letters whose structure meets a certain standard, namely, containing fields: subject, text, sender's address, recipient's address, etc.

As you can see, there are quite a few programs for opening CSV format objects. As a rule, it is best to view the contents of such files in spreadsheets. Editing can be done as text in text editors. In addition, there are separate CSVs with a specific structure that specialized programs, such as email clients, work with.

CSV (Comma Separated Data) files are a special type of file that can be created and edited in Excel. CSV files store data not in columns, but separated by commas. Text and numbers saved in a CSV file can be easily transferred from one program to another. For example, you can export contacts from Google to a CSV file and then import them into Outlook.

For information on how to import a list of calendar entries into Outlook, see Import and export email, contacts, and Outlook calendar.

Create a .csv file from another program or email service provider

When exporting contacts from another program, such as Gmail, you can usually choose from several formats. Gmail offers a choice of Google CSV file, Outlook CSV file, and vCard files. When you export data from an Outlook profile, you can select a .csv file or an Outlook data file (.pst) for later import into another profile.

Download and open a sample CSV file to import contacts into Outlook

You can create a CSV file manually in one of two ways.

Create an Excel file and save it as a CSV

If contact information is stored in a program from which it cannot be exported, you can enter it manually.

Download the CSV template

If you'd like to start with an empty CSV file, you can download the sample below.

There are a few things to keep in mind when working with this CSV file.

Editing the CSV file with contacts to be imported into Outlook

Let's say you want to edit a CSV file that was exported from Outlook and then import it again into that application or another email service. You can easily do this with Excel.

When modifying a CSV file, keep the following points in mind.

The column headings must remain on the first row.

When you save a file in Excel, you will be prompted several times like this: "Are you sure you want to save the file in CSV format?" Always choose the answer "Yes". If you select No, the file will be saved in native Excel (XLSX) format and cannot be used for import into Outlook.

Issue: All data is displayed in the first column

This could happen for several reasons, so there are several solutions that you can try.