FormatIA

Clean a messy CSV

A CSV exported from another system often arrives with semicolons instead of commas, empty rows, extra columns or unclosed quotes, and Excel opens it all in a single column. FormatIA detects the separator, tidies the rows and gives you a clean table you can edit before downloading.

What you pasted

Input

0 of 6,000 characters

3 free AI uses today

We do not store your text. Simple chats and CSV files are processed in your browser; with AI, the text goes to Groq only to produce your answer.

Result

Your table will show up here

Paste some text on the left or try an example.

 

You reached today’s free limit

Your AI uses reset at midnight (UTC). WhatsApp chats and simple CSV files stay unlimited. If you want unlimited AI, leave your email and we will tell you when Premium opens.

How it works

  1. 1

    Paste the CSV contents, or upload the .csv file.

  2. 2

    FormatIA detects the separator and fixes rows and columns in your browser.

  3. 3

    Correct any cell and download the CSV with accents and special characters encoded properly.

Frequently asked questions

Is my file uploaded to a server?

No. Normal cleaning happens in your browser and the file never leaves your device.

Why do accents look wrong in Excel?

Excel needs a special marker (BOM) to read UTF-8. The CSV you download here includes it, so accents and non-Latin scripts display correctly.

What if the file is too broken?

If no clear structure is detected, use AI with the “Messy CSV” type and it will try to rebuild the columns.