Meta Ads and Google Ads Data to JSON
Dashboards and scripts often take JSON. An ads export needs a little cleaning first so the fields come out right.
Clean the export in Data Transformation: remove duplicate rows, trim spaces, rename columns to simple names such as campaign_name and spend, and fix dates and numbers with the date and data type steps.
JSON is a list of records, each with named fields. Numbers and true/false stay as such when type detection is on, but ids and codes with leading zeros should stay text. Choose pretty JSON to read it, or compact JSON to save space.
Keep campaign and ad set ids as text, because long ids can be rounded if they are read as numbers. Compare the record count and total spend with the platform before you use the file.
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.
- Clean and rename in Data Transformation.
- Download JSON.
- Compare totals with the platform.
When to use the Data Transformation
- Feed ad data to a dashboard
- Test a reporting script
- Share a campaign extract
- Keep a structured archive
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. A rounded id cannot be recovered.