Marketers move data between tools constantly: a CRM export needs to become an ad-platform upload, a webinar list needs reformatting for the ESP, and a report needs to land as clean JSON for a dashboard. Big CSVs choke spreadsheet apps and hide delimiter and encoding gotchas that break imports.
This workflow covers the CSV transformations marketers hit most: converting between formats, fixing delimiters, and reshaping columns so every platform accepts the file on the first try.
The workflow
1
Fix the delimiter
Convert between comma, semicolon, and tab delimiters so European exports and US tools stop clashing.
2
Convert to the target format
Turn CSV into JSON for dashboards or reshape it for an ad-platform upload template.
3
Extract the fields you need
Pull just the email column or required fields to match the import schema.
4
Validate before upload
Check the output structure so the import doesn't silently drop rows.
'/%3e%3ccircle%20cx='100'%20cy='100'%20r='84'%20fill='%23093e47'/%3e%3ccircle%20cx='100'%20cy='100'%20r='79'%20fill='url(%23teal)'/%3e%3cg%20transform='translate(55,55)'%20stroke='url(%23cmd)'%20stroke-width='11'%20fill='none'%20stroke-linecap='round'%20stroke-linejoin='round'%3e%3crect%20x='27'%20y='27'%20width='36'%20height='36'%20rx='5'/%3e%3ccircle%20cx='13.5'%20cy='13.5'%20r='13.5'/%3e%3ccircle%20cx='76.5'%20cy='13.5'%20r='13.5'/%3e%3ccircle%20cx='13.5'%20cy='76.5'%20r='13.5'/%3e%3ccircle%20cx='76.5'%20cy='76.5'%20r='13.5'/%3e%3c/g%3e%3c/svg%3e)