How to use CSV files¶

• Table of contents
• How to use CSV files
  • Introduction
• A Clean Start
  • Tips To Avoid Breaking The Formatting
  • Getting The Data Back Into A Radio
  • Handling missing columns

Introduction¶

It is important to note that CSV stands for "Comma Separated Values" and is a method of encoding and not a strict file format. Any kind of record data can be stored in a CSV file, which is why spreadsheet applications such as Microsoft Excel and LibreOffice Calc support it. If you create a CSV file without a specific format, CHIRP will not be able to extract the needed data from it. Please NOTE: General-purpose spreadsheet programs do not know anything about the content of such a file and will be more than happy to let you enter data that does not follow the rules (like entering "abcd" in the Frequency field). CHIRP will, of course, reject that as bad data. Please consider why you want to use an external program to edit memory data instead of CHIRP itself. In almost all cases, people report bugs because they think using a spreadsheet will be easier, they break the format of the file, and cause themselves far more trouble than would have been involved if they just did their edits within CHIRP itself.

A Clean Start¶

If you want to get an empty CHIRP-compatible CSV file, the easiest way is to let CHIRP create one for you. Here are the approximate steps for creating an empty file, editing it in an external editor and opening it back up in CHIRP:

1. Start CHIRP
2. Go to File > New to create an empty CSV file
3. Add a memory to the first row, by entering a frequency such as 146.52
4. Go to File > Export to CSV to save the template file to something ending with a .csv extension
5. Open the file in your spreadsheet or external application of choice, make edits and save
6. Re-open the file in CHIRP to validate that the format is still correct, by going to File > Open and choosing your file
7. Optionally copy memories from that tab into the tab for another radio

Tips To Avoid Breaking The Formatting¶

CHIRP relies on the CSV file's formatting to be intact in order for it to read and understand the data inside the file. Observe the following rules to ensure that CHIRP can continue to read the file:

1. You must maintain the header row in its original format so that CHIRP knows which column corresponds to which value
2. You may re-order the columns as long as the header row matches. NOTE: The Location column must always be the first one.
3. You may delete columns for which there are sane defaults and CHIRP will assume those defaults upon opening the file (but you may not arbitrarily delete the contents of columns you think are irrelevant for a given memory, such as rtone, ctone, dtcs, etc)
4. You may place double quote marks (i.e. " not ' or '') around column values that contain spaces or commas
5. Field values must be in the original format and one of the accepted values for the column type. For example, the Duplex field may be either blank, an plus sign (+), a minus sign (-), or the word "split". The Tone (mode) field may be either blank, the words "Tone", "TSQL", "DTCS", or "Cross", and so on. If there is ever a question, use CHIRP to create a file with a given value and observe what it puts into the CSV file as a result.

Getting The Data Back Into A Radio¶

CSV files are generic, radio-independent text files. This means that you cannot upload them directly into a radio. In order to get the information into your device, you must copy memories into an image for that device:

1. Open your CSV file using File > Open and choosing your file.
2. Open a .img file of your radio, or download one from it using Radio > Download From Radio. Make sure that the resulting tab at the top says something like "Yaesu FT-7800" or "Icom IC-880" to indicate that you're operating on a radio-specific driver.
3. Select the tab containing your CSV file at the top, and select memories from the CSV file you want to copy over. You can select multiple rows by holding the Shift or Control keys while making your selections.
4. After selecting one or more memories, copy them to the clipboard by going to Edit > Copy.
5. Next, select the tab corresponding to your actual radio at the top
6. Select a spot in the radio's memory to paste the new memories and then go to Edit > Paste.
7. If you have a clone-mode radio, upload the changes back to your device using Radio > Upload To Radio. If you are using a live-mode radio, wait until all of the changes finish synchronizing back to the device by watching the status bar in the lower right corner of the main window.

Handling missing columns¶

Since the CSV files are generic your radio may need information that is not present in the CSV file. The most frequent example of this is the missing "Power" column. If your radio's "power" defaults to "low" then you probably want to change the setting to "high" for all channels.
After you open the spreadsheet in the CHIRP window for your radio, you will need to change setting in the "power" column for all rows. Fortunately, CHIRP has a shortcut that lets you change one or more columns in all rows:

1. Select relevant rows:
   1. Click on the first row
   2. Move to the last affected row and shift-click
2. Right-click to get the convenience popup, and click on "properties" to bring up the properties menu
3. Select the property ("column") checkbox to change and select the new value for it from its dropdown (e.g., select "power" and select "high").
4. Click OK.