Author Topic: Export IPTC into Excel  (Read 5253 times)

Offline agbob

  • Newcomer
  • *
  • Posts: 9
    • View Profile
Export IPTC into Excel
« on: January 11, 2019, 09:11:58 PM »
Hi

Want to bulk export IPTC data into Excel.

Have tried the steps given in earlier post as given in link below -
http://forums.camerabits.com/index.php?topic=1059.msg4848#msg4848

It all goes fine till entering variables with tabs - {caption}{tab}{copyright}{tab}{credit}{tab}{keywords}{tab}
But after that when you click on Export - Save as Type - doesn't show any options at all.
Ideally one should be able to choose CSV or any other format here.

What am I missing.

Could somebody help please.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 24730
    • View Profile
    • Camera Bits, Inc.
Re: Export IPTC into Excel
« Reply #1 on: January 11, 2019, 09:36:45 PM »
Hi

Want to bulk export IPTC data into Excel.

Have tried the steps given in earlier post as given in link below -
http://forums.camerabits.com/index.php?topic=1059.msg4848#msg4848

It all goes fine till entering variables with tabs - {caption}{tab}{copyright}{tab}{credit}{tab}{keywords}{tab}
But after that when you click on Export - Save as Type - doesn't show any options at all.
Ideally one should be able to choose CSV or any other format here.

What am I missing.

Could somebody help please.

Please post a screenshot of what you're seeing.  Use the 'Attachments and other options' link when you're composing your reply to this message and there you'll be able to upload your JPEG format screenshot.

Thanks,

-Kirk

Offline agbob

  • Newcomer
  • *
  • Posts: 9
    • View Profile
Re: Export IPTC into Excel
« Reply #2 on: January 11, 2019, 11:04:23 PM »
Thanks for the reply Kirk.

Screenshot attached. Save as Type in Blue doesn't give any option.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 24730
    • View Profile
    • Camera Bits, Inc.
Re: Export IPTC into Excel
« Reply #3 on: January 11, 2019, 11:51:52 PM »
I believe it is asking you to choose a folder to export into.  No need for a file extension on a folder.

-Kirk

Offline agbob

  • Newcomer
  • *
  • Posts: 9
    • View Profile
Re: Export IPTC into Excel
« Reply #4 on: January 18, 2019, 12:34:29 AM »
Thanks Kirk.

You're right. Once you select the folder a file gets saved.
Which you can then open in Word. (For some reason it doesn't open in Excel)
But then you can copy paste the data in Excel.