Klaviyo to Excel
Opens, clicks and conversions from Klaviyo, by campaign or flow, in a worksheet in your own OneDrive.
- Each report writes to a worksheet you choose, in a workbook in your OneDrive.
- Refreshes every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
- Up to 1,000 rows a report.
Your first scheduled report starts 30 days of Plus, free. No card needed.
Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.
How to connect Klaviyo to Excel
To export Klaviyo data to Excel you need a work or school Microsoft account with OneDrive, and a Klaviyo account you can create a private API key in.
- 01In Klaviyo, create a private API key with read access. On the Sources page, choose Add key on the Klaviyo card, paste it and choose Check and save.
- 02In Fresh Sheets, go to Destinations, choose Connect Microsoft Excel and sign in with your work or school Microsoft account.
- 03Choose New report, pick Klaviyo and the account, then the report type, fields and date range.
- 04Under Destination, pick the workbook and worksheet. Under Schedule, pick how often. Then Save and run.
Columns Klaviyo writes to Microsoft Excel
Row one holds the column names. Money shows its currency symbol when a report has only one currency.
| Column | Format | Available at |
|---|---|---|
| Campaign | Text | Campaign performance |
| Campaign ID | Text | Campaign performance |
| Channel | Text | Every level |
| Tag | Text | Campaign performance |
| Flow | Text | Flow performance |
| Message | Text | Flow performance |
| Flow ID | Text | Flow performance |
| Recipients | Whole number | Every level |
| Delivered | Whole number | Every level |
| Delivery rate | Percentage | Every level |
| Opens | Whole number | Every level |
| Open rate | Percentage | Every level |
| Clicks | Whole number | Every level |
| Click rate | Percentage | Every level |
| Click to open rate | Percentage | Every level |
| Conversions | Whole number | Every level |
| Conversion rate | Percentage | Every level |
| Bounce rate | Percentage | Every level |
| Unsubscribe rate | Percentage | Every level |
| Spam complaint rate | Percentage | Every level |
Each report counts conversions against the event you choose.
An example
Insert a PivotTable on a separate worksheet that reads from the Campaign performance worksheet, with Campaign in Rows and Conversions in Values.
Scheduling and refresh
How often depends on your plan: every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
Each run that succeeds counts once towards your plan, wherever it sends.
Each run replaces the worksheet with the latest figures.
Other ways to do it
Klaviyo can export campaign and flow analytics as a CSV file.
Source: Klaviyo Help: Export campaign analytics; Klaviyo Help: Export flow analytics
Fresh Sheets gets Klaviyo to Excel without a CSV, straight into your worksheet.
Only the worksheets your reports use
While you choose where a report goes, Fresh Sheets reads the names of the files and folders in your OneDrive and shows you only folders and workbooks. When a report refreshes, it reads and replaces that report's own worksheet. It creates a new workbook only when you ask it to, and doesn't change or delete anything else in your OneDrive.
Questions
How do I export Klaviyo data?
Add a Klaviyo private API key with read access on the Sources page, then build a campaign or flow performance report that writes to your worksheet. It refreshes on your schedule, so there's no file to download.
Other sources to Microsoft Excel
Analytics
Advertising
Last checked 22 October 2026
Get your Klaviyo results into Excel
Excel is on every plan, Free included. Sign in on the web with Google or a work or school Microsoft account, connect Microsoft Excel and build your first report.
Your first scheduled report starts 30 days of Plus, free. No card needed.
Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.
Paid plans from £12 a month, billed annually. After 30 days, choose a plan or stay free: one report keeps refreshing weekly, the rest pause, and nothing is deleted.