How to Export File Metadata from Dropbox

Local Sync + OS File Listing

find ~/Dropbox -type f -exec stat -f '%N,%z,%m,%Sc' {} \; > dropbox_files.csv
# Creates: full path, size in bytes, modification timestamp, status change time

Get-ChildItem -Path "C:\Users\You\Dropbox" -Recurse -File |
    Select-Object FullName, Length, LastWriteTime, CreationTime, Extension |
    Export-Csv -Path "dropbox_files.csv" -NoTypeInformation

Python + Dropbox SDK

import dropbox
import csv

dbx = dropbox.Dropbox("YOUR_ACCESS_TOKEN")

def list_all_files(path=""):
    """List all files recursively, handling pagination."""
    result = dbx.files_list_folder(path, recursive=True)
    entries = result.entries
    while result.has_more:
        result = dbx.files_list_folder_continue(result.cursor)
        entries.extend(result.entries)
    return entries

entries = list_all_files()

with open("dropbox_metadata.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "Name", "Path", "Size (bytes)", "Client Modified",
        "Server Modified", "Content Hash", "File ID", "Revision"
    ])
    for entry in entries:
        if isinstance(entry, dropbox.files.FileMetadata):
            writer.writerow([
                entry.name,
                entry.path_display,
                entry.size,
                entry.client_modified,
                entry.server_modified,
                entry.content_hash,
                entry.id,
                entry.rev,
            ])

print(f"Exported {sum(1 for e in entries if isinstance(e, dropbox.files.FileMetadata))} files")

Rclone CLI

# List all files as JSON
rclone lsjson dropbox: --recursive > dropbox_files.json

# Convert to CSV
python3 -c "
import json, csv, sys
with open('dropbox_files.json') as f:
    data = json.load(f)
w = csv.DictWriter(sys.stdout,
    fieldnames=['Path','Name','Size','MimeType','ModTime','IsDir'])
w.writeheader()
for item in data:
    w.writerow(item)
" > dropbox_metadata.csv