Rons Place Blog - Home

Tag: Rons CSV Editor

To remove or replace text easily in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'View/Toolbox' menu to open the Toolbox.
  • Go to Find/Replace and Text on the left side menu.
  • Apply the appropriate settings:
    • Enter the text or character you want to be replaced or removed in 'Search For'.
    • Enter the text or character you want it to be replaced in 'Replace With', or leave this field blank if you want the text or character to be removed completely. Found matches are highlighted on the preview and can be navigated through by clicking on the arrows next to the Update button.
    • Click on 'Update'.
  • Save the file.

 

A CSV (or comma-separated value) file is a text file containing data formated as a table. Each line represents a row and contains a list of cell values separated by commas. The first row can optionally contain the list of column names.

An example is shown below:

 

FirstName,LastName,Company
Portia,Mcfann,Beachcomber Realty
Andrew,Fenstermacher,Shafer Commercial Seating Inc
Brady,Tatum,Cywinski Jackson Bohlin
Gracie,Riskalla,Richard A Esq Jessup
Helga,Rio,Pony Express

 

Which when handled correctly represents:

FirstName LastName Company
Portia Mcfann Beachcomber Realty
Andrew Fenstermacher Shafer Commercial Seating Inc
Brady Tatum ...

Rather immodestly we think Rons CSV Editor is the best CSV editor. However we are the ones who created it so we don't actually expect anyone to believe us. For this reason we provide an 100% free Lite version of our software, and a free trial of the Pro version, so that our customers can make up their own minds in their own time.

 

 

Our Goals

We have aimed to make the job of editing CSV files as easy as possible by keeping in mind throughout design and testing that the Rons CSV Editor is for editing data tables, and that fundamentally our product is a text editor. Our customers have also played a key role in the...

Let's be clear. Excel is state of the art spreadsheet software, and is excellent at doing what it was designed to do. However, over the years Excel's table structure has led it to be used in ways for which it was not originally designed. One of these is editing CSV files, for which it is capable, but far from perfect.

 

Some of the main problems encountered with CSV files in Excel

Problem Description Effect
Excel not recognizing the comma. For English installations of Excel the comma (,) is recognized and used correctly as a field/cell separator. However in European installations of Excel the comma is used as the decimal point character and Excel uses a semi colon (;) as the field/cell separator. Every field in a row in a CSV file is loaded into the first column as a single...

 Rons CSV Editor for e-Commerce

Increasingly over the last few years we have noticed that a large portion of our customers are made up of people running e-commerce websites. Usually these sites are a based on a commercially available e-commerce platforms such as one of those shown below.

 

To Split Rows in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Row/Split' menu.
  • Apply the appropriate settings:
    • Select the rows to be split or select All rows.
    • Select appropriate column.
    • Indicate where it must be split on the 'Split on' section.
    • Indicate if the new row must keep the source info or not.
  • Click on 'Split'.
  • Save the file.

 

To split Columns in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Column/Split' menu.
  • Apply the appropriate settings:
    • Select the Source...

To use templates to Edit CSV Files

Editing CSV files often turns out to be a repetitive job, for example updating product lists regularly in an ecommerce application. The use of templates can gain tremendous time and are very easy to set up. Templates can be used in Rons CSV Editor in diverse ways:

Templates can be used:

  • To create a new file, using the columns in the template.
  • Apply structural formatting to the columns in an existing CSV file (in the 'Edit Columns' window).
  • Apply visual formatting to the columns in an existing CSV file (in the 'Column Layout' window).

How to create a new template

  • Go to the 'Tools/Manage Template' menu.
    • Click on New.
    • Create a Name.
    • Select the Name and click on Edit.
    • Click on Add to create your template.
    • Enter the appropriate information in the section on the right.

To remove spaces in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'View/Toolbox' menu to open the Toolbox.
  • Go to Remove and Space on the left side menu.
  • Apply the appropriate settings:
    • Centre Action: Select 'Remove'.
    • Select either 'Whole Document' or 'Selected Cells'(after manual selection). Found matches are highlighted on the preview and can be navigated through by clicking on the arrows next to the Update button.
    • Click on 'Update'.
  • Save the file.

 

Next Page