‹ Back ✦ AI Chat
🧹▤

Clean Up Table Data

Trim spaces, drop empty rows/columns, unify number formats and header names.

    4
    Cells trimmed
    1
    Empty rows removed
    1
    Empty columns removed
    3
    Numbers converted
    0
    Duplicate rows removed
    NameCityAmountPhone
    Ana SilvaLisbon1234.50151 234
    Ben MüllerBerlin1200.75+49 30 1234
    Ben MüllerBerlin1200.75+49 30 1234

    Runs entirely in your browser. Nothing is sent anywhere.

    How it works

    1. 1Paste or type your text.
    2. 2Choose the options you need.
    3. 3Copy or download the result.

    About this tool

    Clean Up Table Data: Trim spaces, drop empty rows/columns, unify number formats and header names. Paste your text and the result appears immediately, ready to copy or download. Everything happens locally in your browser — nothing you paste is uploaded or stored.

    Example

    Input

    Name ,  City,Amount,,Phone
      Ana  Silva , Lisbon ,"1.234,50",,0151 234
    ,,,,
    Ben Müller,Berlin,"1,200.75",,+49 30 1234
    Ben Müller,Berlin,"1,200.75",,+49 30 1234

    Output

    Name,City,Amount,Phone
    Ana Silva,Lisbon,1234.5,0151 234
    Ben Müller,Berlin,1200.75,+49 30 1234
    Ben Müller,Berlin,1200.75,+49 30 1234
    How do I use the Clean Up Table Data?

    Paste or type your text. Choose the options you need. Copy or download the result.

    Is the Clean Up Table Data free?

    Yes. It is completely free with no sign-up, no usage limits and no watermark.

    Is my data sent to a server?

    No. Everything is calculated locally in your browser. Nothing you enter is uploaded, logged or stored.

    Does it work on my phone?

    Yes. It works in any modern browser on Android, iPhone, iPad, Windows, Mac and Linux — no app needed.