OpenToolDesk.
English
Study

Survey spreadsheet cleaner

Convert multi-select survey answers from Google Forms or Microsoft Forms CSV exports into separate yes/no columns without duplicating respondents.

Survey spreadsheet cleaner settings

Upload a file

Drag and drop files here

CSV · TSV

One file · 5 MB per file

Use a direct public file link up to 20 MB, or the smaller limit shown above. The download service retrieves the file; sign-in links are not supported.

    Download an example file

    or

    Paste text or upload a file. If you select a file, it takes priority.

    Selected files are processed in your browser. URL imports use the download service.

    Survey spreadsheet cleaner

    Survey exports often store several checkbox choices in one cell. Splitting those cells into rows can count a respondent more than once. This cleaner keeps every original row and adds one column per choice, ready for filters and pivot tables. For example, Excel;Word becomes yes in both answer columns; an unanswered question stays blank.

    How to use this tool

    1. Choose a file, drag it into the upload area, import a public file URL, or paste your text below the upload options.
    2. Review the settings and create your result.
    3. Download and check the output before using it.

    Supported input formats

    • CSV
    • TSV

    Available settings

    • Multi-answer columns
    • Answer separator

    Output and limitations

    Convert multi-select survey answers from Google Forms or Microsoft Forms CSV exports into separate yes/no columns without duplicating respondents.

    Export your spreadsheet as CSV or TSV. Enter comma-separated column names and the separator used between answers. Blank responses remain blank.

    What should I check before using the result?

    Export your spreadsheet as CSV or TSV. Enter comma-separated column names and the separator used between answers. Blank responses remain blank.

    Where are my files processed?

    Selected files are processed in your browser. Importing a URL uses the download service to retrieve the remote file.

    What if processing fails?

    Check the supported formats and file limits, then try a smaller file. Keep an original copy. A clear error message will explain an unsupported input or an unavailable processing service.