---

This article provides step-by-step instructions on modifying the header of a CSV file and updating its content using Rons Data Edit, a powerful CSV editor. If you'd like to follow along, you can download the free version here: Download.

To open your CSV file, use the 'Open Document' option from the File menu, or click the 'Open Document' link on the application's Start Page.

Convert a Row into the File Header

Rons Data Edit offers two different menu layouts. Follow the instructions below based on the menu style you are using.

Using the Ribbon Menu

1. Click on the Rows tab in the ribbon at the top of the window.
2. On the right side of the ribbon, you will see two options: Make Row Header and Make Header Row.
3. To convert a row into the file header:
   • Select the row you wish to designate as the header.
   • Then, either click on Make Row Header or right-click the row header and choose Make Row Header from the context menu.

Using the Traditional Menu (List Menu)

1. Select the row you want to convert into the header.
2. In the top menu, click on Rows.
3. From the dropdown list, choose Make Row Header.

Convert the File Header into a Data Row

When you need to revert the file header back into a regular data row, follow the steps for your menu layout.

Using the Ribbon Menu

1. Click on the Rows tab in the ribbon at the top of the window.
2. On the right side of the ribbon, you'll see two options: Make Row Header and Make Header Row.
3. To convert the header into a data row (placing it as the first row):
   • Click Make Header Row, or Right-click the column header and select Make Header Row from the context menu.

Using the Traditional Menu (List Menu)

1. In the top menu, click on Rows.
2. From the dropdown list, choose Make Header Row.
3. The column names will be reset to default values (e.g., Column 01, Column 02, Column 03, etc.).

Update the Header information

To modify header information, follow these steps:

• Using the Ribbon Menu: Click on the Column section in the top ribbon menu.
• Using the Traditional Menu: Navigate to the Column menu.

Columns can be renamed individually by selecting the desired column and clicking Rename Column. This will open the header cell, allowing you to edit its content.

Alternatively, you can update header information via the Edit Schema window, located under the Column section (Ribbon Menu) or menu (Traditional Menu).

Editing in the Edit Document Schema Window:

1. Open the Edit Document Schema window.
2. Select a column from the list on the left.
3. Update its title in the Edit Data Column area on the right.
4. Define the column type (Text, Time, Date, etc.).
5. When satisfied with the changes, save and close the Edit Document Schema window to apply them.

Let us hear from you

Do you have a question, or some feedback? We'd love to hear from you! Send us, Rons Place Software, a message using our Contact Form and we will get back to you shortly.