The quickest way to move Snapchat Ads data into Excel is a 3-step process: export a report from Snapchat Ads Manager as a CSV file, open or import it in Excel, then check the data types. For recurring reporting, use the Snapchat Marketing API or a third-party connector instead of repeating manual downloads.
| Your requirement | Best method | Why |
|---|---|---|
| One-off campaign report | Snapchat Ads Manager export | Fastest option with no technical setup |
| Weekly or daily reporting | Snapchat Marketing API | Supports repeatable reporting and automation |
| Refreshable workbook connection | Excel connector | Reduces manual downloads, but may involve vendor costs and permissions |
| Large or highly detailed report | Snapchat Marketing API asynchronous report | Can return CSV or Excel files for broad reporting requests |
For most advertisers, start with the Ads Manager export. Move to Power Query when you are combining recurring files, and use the API when you need scheduled reporting.
Export Snapchat Ads data by downloading a CSV report from Ads Manager:
Snapchat documents this process as a CSV export containing the selected metrics, dates and reporting level. Excel can open the downloaded file directly, or you can import it through Power Query.
Import the CSV through Excel's From Text/CSV option:
Power Query can detect CSV delimiters, identify column headers and assign data types. It can load the result into an Excel table or PivotTable.
Use separate sheets for:
Keep the raw export unchanged. That gives you an audit copy and makes it easier to replace the source file when you download a new report.
Export the columns that match your campaign objective. Common Snapchat Ads fields include:
Snapchat's Ads API documentation includes metrics such as spend, impressions, swipe-ups, video views, landing page views and native leads. The available metrics depend on the ad format, objective and report configuration.
Export campaign, ad set and ad IDs whenever possible. Names can change in Ads Manager, while IDs provide a more stable way to match records across reports.
IDs are useful when you:
Use a folder of CSV files, the Snapchat Marketing API or a third-party connector, depending on how often you need updated data.
To combine recurring downloads in Excel:
Microsoft Power Query can import similarly structured files from a folder and combine them into one table.
This method still requires a download from Snapchat, but it removes the need to combine each file manually.
The Snapchat Marketing API provides campaign reporting at hourly, daily and total granularity. It suits agencies, brands and analysts that need scheduled data collection or a reporting database.
A typical workflow is:
Snapchat uses OAuth 2.0 access tokens. The returned data depends on the permissions associated with the authorized account.
For large reporting requests, Snapchat supports asynchronous reports. These reports can be generated in CSV or Excel format and downloaded after processing. Snapchat recommends asynchronous reporting for large or broad breakdown queries because standard requests may time out or hit size limits.
A third-party connector may work when you need a refreshable workbook but do not want to build and maintain an API integration.
Before choosing a connector, check:
For a small number of manual reports, a connector may add more setup than it removes. For a reporting team managing multiple accounts, it can reduce repeated downloads.
Snapchat's API documentation describes monetary values in micro-currency. If an API response returns spend in micro-currency, divide the value by 1,000,000 before presenting it as the local currency amount.
Do not apply this conversion to every native Ads Manager export. First check whether the downloaded file already displays normal currency values.
Two Snapchat reports can show different conversion results when they use different:
Use the same settings when comparing reports. Record them in a Notes sheet so another person can understand how the workbook was created.
Excel may import some values as text, particularly:
Use Power Query to set numeric, date and text types before building formulas or PivotTables. Microsoft recommends Transform Data when the imported CSV needs editing before it is loaded into Excel.
Opening a Snapchat export in Excel gives you a local copy of the report. It does not retrieve new Snapchat data automatically.
For refreshable reporting, you can:
Power Query can refresh connected data sources after the query has been created.
Set up the workbook in this order:
For most teams, this keeps the first report simple without preventing a later move to repeatable reporting.