Skip to content
This page is also available in your language. Switch

Sync settings

Choose what your account keeps in step on every device where you are signed in.

  • My tools

    Always synced: the tools on your board, their order and size.

  • The windows open on your start page, including what you typed in them.

  • Every note in the notepad – on the notepad page, on your board and in windows.

  • Every list of website shortcuts – on the shortcuts page, on your board and in windows.

  • Every grid in the cover grid maker – on its page, on your board and in windows.

  • Every list of bookmarked organisations in the OIN lookup – on its page, on your board and in windows.

  • Keeps your pipeline and saved recipes on all your devices. Your files are never synced – only the steps and settings.

Turning something off removes it from your account straight away. Your devices keep their own copy.

Notifications

Tools that can tell you about something new while a Synsi tab is open, even when you are in another tab or app. Choose them for this browser.

This browser cannot show notifications from websites.
Notifications are blocked for this site. Allow them in your browser’s site settings (the icon left of the address), then switch them on here.

  • Says “New message” while a Synsi tab is open – never who wrote it or what.

Your choice is stored in this browser only. Notifications never show personal content such as a message or a number. They work while a Synsi tab is open; closed tabs get none.

Browse all tools →

Fix a broken CSV file online

Drop the file in. The studio shows how it was read, lists the problems it found and cleans blank rows and stray spaces. Nothing is uploaded.

My tools →
Open full app
Open full app
Runs in your browser – your data stays on your device unless you turn on syncing

How to use the Fix a CSV File

  1. 1 Drop your CSV file on the studio, or try the example.
  2. 2 Read the notes under Source: wrong delimiter, rows with too many or too few fields, an unclosed quote, garbled characters.
  3. 3 Change the delimiter or encoding under Source if the preview still looks wrong.
  4. 4 Keep the clean-up steps, adjust them, and download the repaired file.

What “broken” usually means

A CSV file is plain text, so it is rarely corrupted in the sense of being unreadable. It usually breaks in one of a few ways: the delimiter is not what the program expects, a quote is never closed and swallows the rest of the file, some rows have more or fewer fields than the header, the text was saved in a different encoding than it is read in, or there are blank lines and stray spaces from an export.

The studio reads the file with a forgiving parser and reports each of these instead of failing. An unclosed quote is treated as an ordinary character and its line number is shown. Rows that are too short are padded with empty fields; rows that are too long get extra columns, so no data is lost – you can also choose to join the extras into the last column or drop them.

Fixing it

The example pipeline removes completely blank rows and columns and trims spaces and invisible characters from every value. Add steps for the rest: remove duplicate rows, change the delimiter or the encoding, or restore leading zeros.

Limits

The parser follows RFC 4180, the closest thing CSV has to a standard, but real files vary, so the repairs are heuristics: check the preview. A file over 25 MB, or with more than 4 million cells, is refused rather than risking your browser.

Frequently asked questions

Why does my CSV look fine in Notepad but wrong in Excel?

Excel splits columns with the list separator of your regional settings and assumes an encoding when it opens the file. A semicolon-separated file in a region that expects commas, or UTF-8 without a byte-order mark, shows wrongly. Fix the delimiter or export UTF-8 with a BOM.

Is any data changed when it repairs rows?

Missing fields become empty and extra fields become extra columns. Nothing is discarded unless you choose to drop extra fields.

Can it repair a file with a mix of delimiters?

It picks the delimiter that splits most rows the same way and warns when that is a guess. If a file really mixes them, choose the main one under Source and fix the rest with a split step.

Last updated: