View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
 
Posts: 80
Default Sort isn't working correctly

When extracting the data with EXIFTOOL, I used the -csv parameter to output a comma-separated values (CSV) file. I then opened the CSV file in Excel and ticked "Delimited" and unticked the "tab" delimiter and ticked the "comma" delimiter. Apparently, that "corrupted" the filenames so Excel couldn't sort the data correctly.

I re-extracted the data with EXIFTOOL with the -csv parameter. When I opened the CSV file, I ticked "Delimited" and left the "tab" delimiter ticked. This time, the filenames did not become corrupted and Excel sorted the data correctly.