Creating and Editing EXIF and IPTC using import from CSV File

CSV is a text file that uses a comma to separate values; it stores numbers and text in plain text (read more about CSV format on Wikipedia).

EXIF metadata can be stored in CSV format as well. This page explains how to export EXIF metadata to text (CSV format) using Exif Pilot software, and how to import EXIF metadata back to digital photos after editing CSV-file.
 

Tags in an CSV File

Each tag in a text file is defined using the following descriptions: “Name of Tag”, “Value of Tag”.
 

Export methods

You can use two export methods:

  1. Batch export of EXIF and IPTC information for multiple images recorded in a single file.
  2. Batch export of EXIF and IPTC information for multiple images each recorded in separate files.

You can choose which of the two types of export/import to use. Select the main menu item “Tools”->”Options” tab, then go to “Settings” and select the option under “Export/Import to/from single File”.

Export and Import EXIF
 

How to export EXIF metadata to text and import changed metadata back to digital photos

For example, to change the FNumber field on number 2.6:

1. Open Exif Pilot and choose the file to change.

2. Go to “Import/Export”->”Export Exif/Iptc to Csv”.

Export Exif to CSV format

3. As instructed, open the text file:

Open Text File in CSV Format

and change the value of the FNumber tag.

Edit EXIF value

4. Save the text file.

5. Go to “Impor/Export”->”Import Exif/Iptc from Csv”.

Import Exif from CSV format

6. Choose the file to import.

7. The FNumber field has the value 2.6.

Edited EXIF data

To avoid undesirable change of metadata, please make backup copies of files before editing.

Note that the batch editing is available in Exif Pilot only with Batch Editing Plug-in.

 

– Exif Pilot main page –