Meta Ads and Google Ads Data to CSV for Reporting
Ad platforms export in their own layouts. A tidy CSV is what BigQuery, Looker Studio and most dashboards load without fuss.
Start by profiling the export in the Data Profiler. It counts blank cells and duplicate rows, which often come from combining several date ranges. Remove duplicates in Data Transformation, then trim spaces so campaign names match across files.
Dates and money need one format. Use the date step to give every date the same layout, and the data type step to turn text such as 1,250.50 into a number. Keep campaign and ad set ids as text, because long ids can be rounded if they are read as numbers.
Rename columns to simple names without spaces, for example campaign_name, spend and clicks, so a loader does not reject them. Then download CSV. Compare the row count and total spend with the platform before you load the file, since a total that does not match means rows were lost or counted twice.
Everything runs in your browser and nothing is uploaded.
Related tool pages
- Delete Columns from a CSV File: Remove one or more columns from a CSV or Excel file and download the result. Free, in your browser, and your file is never uploaded.
- Reorder Columns in a CSV File: Drag columns into a new order, or send a column to the start or the end, in a CSV or Excel file. Free, in your browser, nothing is uploaded.
- Remove Empty Rows and Columns from CSV: Remove rows with empty cells, rows that are completely empty, or columns with no values from a CSV or Excel file. Free, in your browser.
- Find and Replace in a CSV File: Find and replace text in a column of a CSV or Excel file, then download the result. Free, in your browser, and nothing is uploaded.
- Change Date Format in a CSV File: Change the date format of a column in a CSV or Excel file, for example 09/03/2026 to 2026-03-09, or get only the year or month. Free, in your browser.
- Convert Excel Date Numbers to Dates: Turn Excel date numbers such as 46090 and unix timestamps into readable dates in a CSV or Excel file. Free, and your file stays in your browser.
How to use the Data Transformation: step by step
- Profile the export for blanks and duplicates.
- Open Data Transformation and remove duplicates, trim and fix types.
- Rename columns to simple names.
- Download CSV and compare totals with the platform.
When to use the Data Transformation
- Load ad data into BigQuery or a dashboard
- Combine monthly exports into one file
- Fix dates and currency before reporting
- Keep a clean archive of a campaign
Example
Input: plans.csv + customers.csv, key = id
Output: id, first_name, plan, amount
Frequently asked questions
Which transformations are available?
Join with a second file (inner, left, right, full), trim spaces, concatenate columns, change case, find and replace, split a column, rename, remove columns, reorder columns, remove empty rows or columns, filter rows, remove duplicates, sort and fill empty cells.
Can I run several steps?
Yes. Steps run from top to bottom and each one sees the result of the one before. You can reorder or remove them.
Can I join two files or combine columns?
Yes. Data Transformation lets you join two CSV or Excel files on a key (inner, left, right or full), and trim spaces, concatenate columns, change case, find and replace, split, rename, filter, sort, remove duplicates and fill empty cells. You choose the steps, check the result and download it. Your files stay in your browser.
Can I change the date format of a column?
Yes. Add a Change date format step, pick the column and the new format, such as 2026-03-09, 09/03/2026 or March 9, 2026. It reads many layouts, Excel date numbers and unix timestamps, and can also give only the year, month, weekday or quarter. If 03/04/2026 is unclear, you choose day first or month first.
Tip: Check total spend against the ad platform. A mismatch means rows were lost or doubled.