How to export your WhatsApp clicks to CSV and open them in a spreadsheet

Why export your WhatsApp clicks to CSV?

The dashboard already answers most questions: how many clicks, which page, which button, which day. So why would you want a file? Because sometimes you need to do something the dashboard does not do for you. You may want to send numbers to an accountant, mix them with your own sales notes, build a chart for a client or keep a monthly archive.

A CSV file is just plain text with values separated by commas, one row per line. Every spreadsheet program can open it, and so can many other tools. It is the most universal way to move data from one place to another.

How to export the data from the dashboard

The exact position of buttons can change, but the idea is always the same: choose what you want to see, then export.

1. Log in to your WhatsClicks account and open the Summary tab.
2. Choose the period at the top. Options go from Today and Yesterday to the last 7, 30 and 90 days, 12 months, and 2 or 3 years.
3. If you want only one link, use the link filter. If you leave it empty, you get all links together.
4. Find the export option and choose CSV. The file is downloaded to your device.
5. Save it somewhere you can find again, with a name that includes the period, for example clicks-2025-march.csv.

The export follows the period and filter you chose. If the file looks too small, check that you did not leave the filter on Today.

How to open a CSV file in a spreadsheet without a mess

Sometimes a CSV opens with everything squeezed into one column, or accents look strange. This is not a problem with your data. It is about how the spreadsheet reads the file.

The safest way is to avoid double-clicking the file. Instead, open your spreadsheet program first and use its import option for text or CSV files. There you can pick the separator (comma or semicolon, depending on your computer's regional settings) and the character encoding. If letters with accents look wrong, try UTF-8.

• Everything in a single column: change the separator in the import window.
• Strange characters: choose UTF-8 as the encoding.
• Dates that look odd: format the column as date after importing.

The names of the menus vary by program and version, so look for words like Import, Text or CSV.

Simple things to do with the exported clicks

Here is an example with made-up numbers. Suppose the file shows 120 clicks in a month, and 70 of them have the tag src=top and 50 have src=footer. You can immediately say that the top button gets more than half of the clicks, and test moving the footer button higher.

• Count clicks per day with a pivot table or a simple filter, and make a line chart for a client report.
• Sort by date to find the busiest days and compare them with your own calendar of posts, ads or promotions.
• Filter by the page or button tags you added to the link, such as ?p=/pricing or &src=top, to see which spot works best.
• Keep one file per month in a folder. After a year you have your own history, independent of any dashboard.

Export for agencies and freelancers

If you manage links for clients, the CSV is handy for monthly reports. Create a link per client or per campaign, export the period, and paste the numbers into your own template. You can also give each client their own login so they can look at their dashboard directly.

In the Compare area of the dashboard, you can also place two links side by side before exporting, which helps when you want to explain a result in a meeting.

What the file will not contain

The file reflects what WhatsClicks stores: date and time, page and button (when tagged), the domain of the site where the button was, device type, browser and system, and an anonymous visitor code. It does not contain the IP address, name, phone number or e-mail of the person who clicked, because the service does not keep them.

Also remember that the file counts clicks on the button. It does not show whether the person wrote to you, bought something or stayed in the conversation. For that, you still need your own notes.