How to inspect a large survey response file
Open a large survey CSV in your browser, check its columns, find missing or unusual answers, and review duplicates before making changes.
A survey export can contain thousands of rows, long answers, and columns you did not expect. Opening the whole file in a spreadsheet may be slow, and it is easy to miss an issue when you scroll through responses one by one.
Use the CSV Editor to open and inspect a large CSV in your browser. You can search, sort, edit, and remove duplicate rows, then decide what needs attention before you use the results.
Inspect the survey file
- Open the CSV Editor and choose your survey CSV file. It supports files with up to 10 million rows. Keep an untouched copy of the original before editing anything.
- Look across the column headers first. Check that each one describes the answers below it, and that the first row contains field names rather than a respondent's answers.
- Use search to find a specific response, ID, phrase, or value. Search for terms such as
prefer not to say, or look for a respondent ID you need to check. - Sort a useful column to bring similar values together. Review fields such as completion status, rating, date, location, or respondent ID, one at a time.
- Check suspicious rows against the survey form or export settings before changing them. If you use edit or remove duplicates, work from a copy so you can compare your changes with the source.
Large files can take longer to open and sort, especially on a computer with limited memory. If the browser slows down, close other tabs and applications, then reopen the file and inspect fewer columns or search for a smaller set of answers.
What the results mean
A column has a blank header
The export may include an unnamed field, or its header may be missing. Check the values in that column and the survey's question list before renaming or deleting it. It could contain an answer, a tracking value, or an empty field added during export.
Some answers are blank
A blank can mean that a person skipped an optional question, left the survey early, or that the export did not include the answer. Compare the blank rows with a completion-status column and the survey's rules. Do not replace blanks with zero unless zero is a valid answer for that question.
One answer appears in several forms
Values such as Yes, yes, and Yes may represent the same answer with different capitalization or extra spaces. They can also reflect a real difference, so inspect the original question and response choices before standardizing them.
Two or more rows look alike
They may be duplicate submissions, but they could also be separate responses from the same person or household. Compare the respondent ID, submission time, and answer fields. Remove rows only when your survey rules identify them as duplicates.
A value seems unusually high or low
An unusual number may be a typo, a valid edge case, or a value entered in a different unit. Check the question wording and allowed range first. A surprising answer is not automatically an error.
How to correct common problems
- Keep the original file unchanged. Make a copy before removing duplicates or editing answers. If a correction is questioned later, the original lets you verify what the survey export contained.
- Check the question and response rules. Confirm whether a field was optional, whether multiple answers were allowed, and what values were valid. Use those rules to distinguish an error from an unexpected but valid answer.
- Review duplicates before removing them. Compare more than one field, such as respondent ID and submission time. Two identical answers can still be separate submissions, while repeated IDs can happen for legitimate reasons.
- Standardize values consistently. If you confirm that several spellings or formats mean the same thing, apply the same correction to every matching answer. Keep the original values in your backup rather than relying on memory.
- Check the file again after changes. Search for the original problem values and review a few changed rows. Make sure the correction did not remove a valid response or shift information into the wrong column.
Protect respondents' information
Survey files may contain names, email addresses, free-text comments, or other details that identify a person. Keep the file on a device you trust, and do not include identifiable responses in screenshots or support requests. The CSV Editor opens files in your browser, and files stay on your device.
A CSV is a plain text format, so a response containing a comma may appear inside quotation marks. Those marks can be part of the file's formatting, not extra punctuation entered by the respondent. Review the answer in its full row before treating it as malformed.
