CONVERSION
Restructure a CSV
Rename columns, change delimiters, filter rows, and reformat fields in your CSV files using a simple AI prompt
Try for free →Why restructure a CSV?
CSV files from one application almost never match the format expected by another.
- ERP/CRM imports : Salesforce, HubSpot, SAP and NetSuite each require a specific layout
- Data consolidation : merging exports from multiple sources requires harmonized headers
- Regulatory compliance : tax filings and payroll mandate a defined column order and delimiter
- Partner exchanges : each business partner has its own CSV template to follow
Orchestria automates this transformation reliably and makes it reusable.
Common CSV restructuring problems
Modifying CSV structure seems simple, but many real-world cases cause headaches.
- Renaming columns :
Customer Nametocustomer_name, handling spaces and casing - Changing delimiter : semicolons to commas without breaking values
- Reformatting dates :
03/15/2024to2024-03-15(ISO 8601) - Reordering columns : rearranging fields to match the import template
- Filtering rows : removing blanks, duplicates or records that fail criteria
- Cleaning data : trimming whitespace, normalizing case, fixing encoding
In Excel, each operation is a separate step. Orchestria handles all of it in one go.
How Orchestria restructures your CSV
Orchestria uses artificial intelligence to generate a restructuring flow for your needs.
- Input/output examples : paste your current CSV and the restructured CSV you expect
- Natural language prompt : describe columns, delimiter, date format and filters
- Delimiter handling : switch between semicolons, commas or tabs safely
- Intelligent reformatting : dates, numbers and text adjusted to your instructions
- Reusable flow : call it via API for all your future files
No macros, no formulas, no scripts to maintain.
Restructuring example
BEFORE
Customer Name;Email Address;Revenue 2024;Region;Signup Date
John Smith;john.smith@example.com;45000;Northeast;03/15/2021
Jane Doe;jane.doe@example.com;62000;West Coast;11/22/2020
Bob Wilson;bob.wilson@example.com;38000;Southeast;06/07/2022AFTER
customer_name,email,revenue,region,signup_date
john smith,john.smith@example.com,45000,northeast,2021-03-15
jane doe,jane.doe@example.com,62000,west coast,2020-11-22
bob wilson,bob.wilson@example.com,38000,southeast,2022-06-07HOW IT WORKS
How it works
Provide an input and output example
Describe the transformation in a prompt
Execute and retrieve the result
The Excel equivalent
Traditional method
In Excel, renaming columns, removing rows, and changing the delimiter requires multiple manual steps, formulas, and a specific Save As operation. Each new file means repeating the same tedious process from scratch.
With Orchestria
With Orchestria, provide an input and output example, describe the transformation in a prompt, and get your restructured CSV in seconds. The flow is reusable for all your future files.