Two Pilots™    Home  |  Navigation  |  Site map  |  Products  |  Download  |  Order  |  Support  |  Contact us  |  For Publishers  |  OEM

 

How to Create and Edit EXIF and IPTC Using Import from MS Excel

Exif Pilot | Exif Pilot Pro | Exif Pilot Lite | Exif Farm
FAQ | Exif tags | Command line | Tag values | Versions history | Write us!

Each tag in an MS Excel file is defined using the following descriptions:
  • Tag - name of tag
  • ValueOFTag - value of tag

Notice: You can use 2 export methods:

  • Batch export of EXIF and IPTC information for multiple images recorded in a single file.
  • 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 and import EXIF."

 

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

1.Open EXIF Pilot/EXIF Pilot Pro and choose the file to change.

2.Go to Exif Info/Export Exif to MS Exel.

 

You should see this message:

 

3. As instructed, open the MS Excel file

 

and change the value of the FNumber tag.

 

Important: Each cell in the ValueOfTag column must be formatted as text or prefixed with a single quotation mark; i.e., the sign (').

For example, the value 1/5 must be formatted as '1/5.

4. Save the MS Excel file.

5. Go to Exif Info/Import Exif from MS Exel.

 

5.Choose the file to import.

 

You should see this message:

 

6. The FNumber field has the value 2.6.

 

- Exif Pilot - Exif Pilot Lite - Exif Pilot Pro -

 

 

Page top