关于从Amazon SES导出抑制列表至Excel或CSV格式的技术咨询

Hey there! I’ve been in your shoes before—spending ages digging for this exact solution, so I’m glad you asked. Here are two reliable ways to get your Amazon SES suppression list into Excel or CSV:

方法一：使用AWS CLI（最快捷高效） #

If you already have AWS CLI set up with proper SES permissions, this is the fastest route:

• First, export the suppression list as raw JSON data:
  aws sesv2 list-suppressed-destinations --output json > suppressed-list.json
• Next, use jq (a lightweight JSON processing tool) to convert the JSON to CSV. If you don’t have jq installed, it’s easy to grab via package managers like Homebrew or apt:
  jq -r '.SuppressedDestinations[] | [.EmailAddress, .Reason, .LastUpdateTime] | @csv' suppressed-list.json > suppressed-list.csv
• That’s it! The resulting suppressed-list.csv file can be opened directly in Excel—no extra formatting needed.

方法二：AWS控制台+Excel导入（适合不熟悉CLI的朋友） #

If you prefer using the web console, here’s how to make it work:

• Log into your AWS Console, navigate to Amazon SES, and find the Suppression List page.
• Look for the Export button (usually in the top-right action menu on newer console versions). Note: The default export format here is JSON, not CSV.
• Download the JSON file to your local machine, then use Excel’s built-in data import tool to convert it:
  • Open Excel, go to the Data tab, click Get Data > From File > From JSON.
  • Select your downloaded JSON file, Excel will automatically parse the structure. You can tweak column order or filters if needed, then save the file as either Excel (.xlsx) or CSV.

小提醒 #

• Make sure your AWS credentials (whether CLI or console user) have the sesv2:ListSuppressedDestinations permission—otherwise you’ll hit access errors.
• The exported list will include all key details: email address, suppression reason (e.g., hard bounce, complaint), and last update time—all of which play nicely with Excel.

备注：内容来源于stack exchange，提问作者FAYSS