Convert Excel Survey Export to JSON Lines

Turn Excel survey exports from tools like Google Forms and Typeform into a clean JSON Lines file, with one row per response and one column per question.

Drop your Excel 2007+ (.xlsx) file here (or click to browse).
(50 MB or less file)
0%
Uploading...
Loading...
Loading…
Sign-up to upload larger files
01

Normalize Survey Responses into Clean Rows

Convert raw survey exports into structured JSON Lines data with one row per response and every answer in its own field. Ratings stay numbers and ZIP codes keep their zeros.

AR
ana.ruiz@example.com Submitted 10/1/2026 9:14:02
Response 1 of 6
Which plan are you on?
StarterTeamBusiness
Overall, how satisfied are you with onboarding?
Very dissatisfiedDissatisfiedNeutralSatisfiedVery satisfied
How likely are you to recommend us to a colleague?
012345678910
Not likelyVery likely
Which features do you use?
ReportsExportsAPIDashboards
ZIP code
02139
What could we improve?
Faster exports. Also a dark mode 🙂
JSON Lines onboarding-survey.jsonl 6 responses · 8 columns
TimestampEmail AddressWhich plan are you on?Overall, how satisfied are you with onboarding?How likely are you to recommend us to a colleague?Which features do you use?ZIP codeWhat could we improve?
110/1/2026 9:14:02ana.ruiz@example.comTeamVery satisfied9Reports, Exports, API02139Faster exports. Also a dark mode 🙂
210/1/2026 11:40:51joao.lima@example.comStarterSatisfied7Reports10001Préférences d'e-mail en français, s'il vous plaît
310/2/2026 8:03:17li.wei@example.comBusinessDissatisfied3Exports, API02140Setup took "forever", honestly
410/2/2026 16:22:09sam.okafor@example.comTeamVery satisfied10Reports, API94107
510/3/2026 10:05:44ana.ruiz@example.comTeamVery satisfied9Reports, Exports, API02139Faster exports.
610/3/2026 13:30:12mette.koch@example.comStarterNeutral6Exports08002Größere Uploads, bitte
Checkbox answers stay in one field

The export keeps the choices together, so the commas between them don't split the answer across columns.

In the exportReports, Exports, APIIn the JSON Lines fileReports, Exports, API
02

Anonymize Responses and Remove Duplicates

Remove repeat submissions and drop identifying columns before sharing survey results across your team.

One response per person

Deduplicate on email to retain only the first response per participant.

Remove Duplicate Records
Drop personal columns

Strip email and ZIP code columns to share anonymous survey feedback.

Select/Arrange Columns

Deduplicate before dropping emails. Save as a template to automate recurring survey cleanups.

JSON Lines onboarding-survey.jsonlonboarding-survey-shared.jsonl 56 responses · 68 of 8 columns kept
Email AddressWhich plan are you on?Overall, how satisfied are you with onboarding?How likely are you to recommend us to a colleague?ZIP code
1ana.ruiz@example.comTeamVery satisfied902139
2joao.lima@example.comStarterSatisfied710001
3li.wei@example.comBusinessDissatisfied302140
4sam.okafor@example.comTeamVery satisfied1094107
5ana.ruiz@example.comTeamVery satisfied902139
6mette.koch@example.comStarterNeutral608002
1 repeat submission removed 2 personal columns dropped Ready to share with your team
AUTOMATED WORKFLOWS

Convert Survey Exports via API

Save transformation steps as a template, post new survey batches to the API, and receive cleaned JSON Lines outputs automatically.

Explore the API
convert-survey-exports.sh
curl -X POST "https://dataconverter.io/api/v1/convert/template" \  -H "Authorization: Bearer YOUR_TOKEN_HERE" \  -F "templateId=YOUR_TEMPLATE_ID" \  -F "file=@onboarding-survey.xlsx" \  --output onboarding-survey.jsonl✓ 200 OK · onboarding-survey.jsonl · 214 responses

Frequently asked questions

Which survey tools' exports work?

Any file with questions in the header row, including Google Forms, Typeform, and Jotform CSVs, or Microsoft Forms Excel files. For SurveyMonkey or Qualtrics, remove extra sub-header rows before upload.

Will long or multi-line answers break my rows?

No. Every answer stays in its own field, commas and quotes included. A line break inside an answer becomes a space.

Do ZIP codes and IDs keep their leading zeros?

Yes. Fields with leading zeros stay formatted as text, while rating columns convert to numbers ready for calculation and charting.

Can I combine several exports into one file?

Yes. Use Merge Data to stack responses by matching column headers. Use Rename Columns if question wording changed between surveys.