Page Icon

How To change the header in a CSV file - Rons Data Edit


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

When you want to convert a row into the file header, follow the steps for your menu layout.

  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.

Window 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.

  1. In the top menu, click on Rows.
  2. From the dropdown list, choose Make Header Row (See above picture.)
  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 and rename columns individually, select a column, then go to Column/Rename Column. This will open the header cell, allowing you to edit its content.

Window Rename Column

Alternatively, you can update all the columns in the header by going to Column/Edit Schema.

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.

Window Edit Schema

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.