Meta Ads and Google Ads Data to Parquet
Teams that keep ad data in a warehouse or analyse it in a notebook often prefer Parquet: it is smaller than CSV and keeps column types.
Clean the export first in Data Transformation. Remove duplicate rows, trim spaces so campaign names match, and rename columns to simple names such as campaign_name, spend and clicks. Run the Data Profiler to count blanks.
Types matter more in Parquet than in CSV, because the file keeps the type you give it. Use the data type step to turn text such as 1,250.50 into a number, and the date step to put every date in one format. Keep campaign and ad set ids as text, since long ids can be rounded if they are read as numbers.
Then choose Parquet when you download. BigQuery, Snowflake, DuckDB, pandas and Spark can all load it. Compare the row count and total spend with the ad platform to be sure nothing was 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, remove duplicates and fix types.
- Rename columns to simple names.
- Download Parquet and compare totals with the platform.
When to use the Data Transformation
- Load ad data into a warehouse
- Analyse campaigns in a notebook
- Shrink a large ads archive
- Keep spend and dates as real types
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: Keep ids as text. Parquet stores the type you set, and a rounded id cannot be recovered.