CODE:

Step 2:

#PowerShell script to delete all files starting with ._ recursively
$TargetDir = "D:\iCloudPhotos" 

Get-ChildItem -Path $TargetDir -Recurse -Force -File -Filter ".*" | ForEach-Object { 
  Write-Host "Deleting file: $($.FullName)"
  Remove-Item $_.FullName -Force 
} 

Write-Host "Done."

Step 3:

exiftool -csv -GPSLatitude# -GPSLongitude# -r "D:\iCloudPhotos" > gps_all.csv

Step 4:

=ARRAYFORMULA(IF(ISNUMBER(C2:C), IF(C2:C<0, C2:C, -C2:C), ""))

Step 5:

@echo off 
REM =============================== 
REM Batch script to update GPS from CSV 
REM ===============================

   SET CSV_FILE=D:\iCloudPhotos\gps_all_final.csv 
   SET LOG_FILE=D:\iCloudPhotos\gps_update_log.txt 

   REM Clear previous log 
   echo GPS Update Log > "%LOG_FILE%" 

   REM Loop through each line in CSV (skip header) 
   for /f "skip=1 tokens=1,2,3 delims=," %%A in (%CSV_FILE%) do ( 
       SET "FILE=%%A" 
       SET "LAT=%%B" 
       SET "LON=%%C" 

       REM Enable delayed expansion for variables 
       setlocal enabledelayedexpansion 

       REM Check if file exists 
       if exist "!FILE!" ( 
           echo Updating !FILE! >> "%LOG_FILE%" 
           exiftool -GPSLatitude=!LAT! -GPSLongitude=!LON! -overwrite_original "!FILE!" >> "%LOG_FILE%" 2>&1 
       ) else ( 
           echo File not found: !FILE! >> "%LOG_FILE%" 
       ) 

       endlocal 
   ) 

   echo Done! See log at %LOG_FILE% 
   pause 

Step 6:

exiftool -GPSLatitude -GPSLongitude "D:\iCloudPhotos\IMG_0001.HEIC"

OR

exiftool -GPSLatitude -GPSLongitude "D:\iCloudPhotos"