How to merge JSON and Google Takeout Photos to get the right dates back?

Question

I just got thousands of photos out of Google takeout but I can't seem to import them elsewhere in the right chronological order. I've also found some tutorials using exiftool but I can't get the different timezones right? Any idea how to retrieve the time with the correct timezone? The timezone isn't in the JSON either.

Answer 1

There are now many scripts and tools available that can extract the metadata from JSON files and apply it to the photos and videos:

• https://github.com/mattwilson1024/google-photos-exif
• ExifTool (there's a tutorial here)

However, those scripts have limitations with regards to timezones, and to some pictures with a name that differs slightly from the name of the JSON file, e.g. PHOTO_NAME(1).jpg being confused with PHOTO_NAME.jpg(1).json. QuickTime- and PNG-specific tags aren't updated either.

If you're happy with those limitations,

• Install ExifTool
• Replace the directory to process and run the command exiftool -r -d %s -tagsfromfile "%d/%F.json" "-GPSAltitude<GeoDataAltitude" "-GPSLatitude<GeoDataLatitude" "-GPSLatitudeRef<GeoDataLatitude" "-GPSLongitude<GeoDataLongitude" "-GPSLongitudeRef<GeoDataLongitude" "-Keywords<Tags" "-Subject<Tags" "-Caption-Abstract<Description" "-ImageDescription<Description" "-DateTimeOriginal<PhotoTakenTimeTimestamp" -ext "*" -overwrite_original -progress --ext json <DirToProcess>

Otherwise, consider using a paid automated tool like https://metadatafixer.com/

Answer 2

I did something like this for my QNAP NAS device. Uses simple text extraction and touches files with the oldest date found in the .json.

EDIT: Just adjust the touch spell so it matches your time format.

find . -name '*.json' | while read filename; do

    imgfile="$(echo "${filename}" | sed 's/\.json$//')" ;
    ts="$(cat "${filename}" | grep timestamp | awk -F'"' '{ print $4}' | sort | head -n 1)" ;
    ts="$(date -d "@${ts}" +"%Y-%m-%d %T")" ;

    if [ -f "${imgfile}" ];then
            echo Touching ${imgfile} ${ts}
            touch -t "${ts}" "${imgfile}"
    fi
done

As stated in the comments, on some Linux versions, touch expects [[CC]YY]MMDDhhmm[.ss] format, so replace the date line with:

ts="$(date -d "@${ts}" +"%Y%m%d%H%M.%S")" 

Answer 3

Here is a tested and very useful free tool for merging the metadata(.JSON) and photos. https://alamantus.github.io/GooglePhotosExportOrganizer/

This program will

1. Extract and merge your Google Photos export from Google Takeout.

2. Organize your photos into folders by year and month.

3. Optionally rename your photos to a year-month-day hour:minute:second number.extension naming convention

4. Fix all file created and modified dates as they are organized.

5. Optionally copy all available metadata provided by Google Takeout in .json files back into the image/video files.

6. Remind you to clean up after processing.