Backup Export: Viewing Image Information in Excel

Get the Excel and sample directory Zip

https://1drv.ms/f/s!AmV8bnLUdf4vzftCvYSuuvgSyWUeig?e=eCKOP3
 

Prepare Your JSON Files

Copy the images folder from your Export to a location (example on your desktop)
 

Excel

  1. Open Excel.
  2. Go to Query tab and click Edit.
  3. Go to the Home tab.
  4. Select Data source settings.
  5. Click Change Source…
  6. Browse to your folder with the images.
  7. Close.
  8. On Home tab, click Close & Load.
Note: you may have to click refresh, but give it few seconds first.

Comments

Please Login in order to comment!