Export Super Chat Transactions for Bookkeeping

Updated 14 November 2026 · Standard formula, shown below

This guide walks you through exporting your YouTube Super Chat and Super Sticker transactions so you can hand them to your accountant or import them into your bookkeeping software. You’ll need a Google account with access to the YouTube channel that received the Super Chats, and you’ll be downloading a CSV file from Google Takeout.

What You’ll Need

A web browser (Chrome, Firefox, Safari, or Edge).
The Google account credentials for the channel that received the Super Chats.
Access to the email inbox associated with that Google account (for the download link).
Basic spreadsheet software (Excel, Google Sheets, or similar) to open the CSV file.

Step-by-Step

Go to Google Takeout. Open takeout.google.com in your browser. If you’re not already signed in, sign in with the Google account that owns the YouTube channel.
Deselect all services. On the main Takeout page, click the Deselect all button at the top of the list. This prevents you from downloading your entire Google data, which can be huge.
Select YouTube. Scroll down and find the YouTube entry. Check the box next to it. (Note: there’s also a separate “YouTube and YouTube Music” entry – you want the one that just says “YouTube”.)
Choose specific data. Click the All YouTube data included text (or the down arrow) to expand the options. Uncheck everything except Super Chat and Super Stickers. This is the file that contains the transaction history.
Set the export format. Scroll to the bottom and click Next step. Choose your delivery method – Send download link via email is the simplest. Choose the export frequency (once) and file type (.zip is fine).
Create the export. Click Create export. Google will start preparing your file. This can take a few minutes to a few hours, depending on how much data you have.
Wait for the email. You’ll receive an email from Google with the subject “Your Google data archive is ready”. Click the Download your files button in the email, or go back to takeout.google.com and click Manage exports to find the download link.
Download and extract the ZIP. Download the .zip file to your computer. Right-click it and choose Extract All (Windows) or double-click it (Mac) to unzip it.
Locate the CSV file. Inside the extracted folder, navigate to Takeout/YouTube/ (or Takeout/YouTube and YouTube Music/). You’ll see a file named super-chat-and-super-stickers.csv.
Open and review the CSV. Open the CSV file with a spreadsheet program. You’ll see columns like Timestamp, Channel Name, Commenter Name, Amount (in USD), Currency, and Message. Review it for completeness.
Convert to your bookkeeping format. If you use accounting software, you may need to clean up the CSV (e.g., remove the message column, format the date) and then import it. Otherwise, you can simply keep the CSV as a record and share it with your accountant.

Common Mistakes

Downloading the wrong YouTube data. Make sure you select only “Super Chat and Super Stickers” – otherwise you’ll get a massive file with all your YouTube activity (comments, likes, history) that’s hard to work with.
Using the wrong Google account. If you have multiple Google accounts, double-check you’re signed into the one that owns the channel. Otherwise, the export will be empty or contain data from the wrong channel.
Ignoring the currency column. Super Chats can be paid in different currencies. Always keep the currency column in your records; don’t assume everything is in your local currency.
Not checking for missing data. Google Takeout sometimes lags behind by a few days. If you need today’s transactions, wait a day or two before exporting.
Deleting the email. The download link expires after a few days. If you delete the email, you’ll have to start the export again.

Tips

Export regularly. Set a monthly reminder to export your Super Chat data. This keeps your bookkeeping current and avoids a huge backload.
Rename the file. Rename the CSV to something like superchat-2025-01.csv so you can easily identify it later.
Keep the original. Always keep the original CSV file untouched. Make a copy before you edit or reformat it for your accounting software.
Use a dedicated folder. Create a folder on your computer or cloud drive specifically for YouTube revenue files. This makes it easy to find everything at tax time.
Check for fees. Remember that the amount shown is what you received before YouTube’s revenue share (typically 30%) and before any payment processing fees. Your bookkeeping should reflect the net amount you actually received, which may be different. Your YouTube Analytics or AdSense reports can help reconcile.

Troubleshooting

No email from Google. Check your spam folder. If it’s not there, go back to takeout.google.com and click Manage exports – you’ll see a list of your exports and the download link there.
The CSV file is empty or missing. Make sure you selected the correct YouTube service and that the channel actually has Super Chat data. If you’ve never received a Super Chat, the file may be empty or not exist. Also, try exporting again after a few days.
The download link is expired. Google links expire after about a week. If yours is expired, go to Manage exports and click Create new export – you’ll have to redo the steps, but it’s quick.
CSV won’t open in Excel. The file might be too large or contain special characters. Try opening it with Google Sheets (upload it to Google Drive and open with Sheets) or use a text editor like Notepad++ to check the raw data.
Dates are in UTC. The timestamp column is in UTC (Coordinated Universal Time). If you need local time, you’ll have to convert it in your spreadsheet (e.g., using a formula like =A2+TIME(5,0,0) for EST).

Frequently Asked Questions

How far back does the export go?

Google Takeout exports all available data for the selected service, so it should go back to the very first Super Chat you received on that channel.

Can I export Super Chat data from the YouTube Studio app?

No, the YouTube Studio app doesn’t have a direct export feature for Super Chats. You must use Google Takeout on a web browser.

Is the export in my local currency?

The CSV includes a Currency column, so you’ll see the original currency of each transaction. It does not convert to your local currency.

Do I need to pay taxes on Super Chats?

Super Chats are generally considered taxable income. You should report them to your tax authority, but the exact treatment depends on your jurisdiction and circumstances. Consult a tax professional.

Can I import this CSV directly into QuickBooks or Xero?

You can usually import a CSV into these programs, but you may need to reformat the columns to match the required template. It’s often easier to use a spreadsheet to clean the data first.

What if I have multiple channels?

You’ll need to export separately for each channel, using the Google account that owns each channel. The CSV will only contain data for the channel associated with the account you’re signed in as.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.