Shed — Jotform Data Splitter

Shed is a free tool that splits Jotform widget data — like Configurable Lists and Product Lists — into clean, separate columns. When you export from Jotform, these multi-value fields come bundled as comma-separated text in a single column. Shed parses that data, identifies each field, and splits it out. You can connect via file upload (Excel/CSV), Jotform API, or Google Sheets — and get your results as a downloadable Excel file or written directly back to your sheet.

Getting started is simple — pick whichever source suits you:

• File Upload: Export your Jotform submissions as Excel (.xlsx) or CSV, then drag and drop or upload the file
• Jotform API: Connect your Jotform account directly using your API key or by logging in with your Jotform credentials
• Google Sheets: Connect a Google Sheet that contains your Jotform data, and Shed will write the split results directly back to your sheet

After connecting, Shed auto-detects which columns contain splittable widget data. Select the ones you want, and Shed splits each into its own tab with dedicated columns.

Yes! Shed's on-demand splitting is completely free to use. Upload files, connect via Jotform API or Google Sheets, and split as many times as you need — no hidden fees or usage limits. We're also building Shed Pro, a paid version that adds webhook-based automatic splitting: every new Jotform submission gets split and delivered the moment it arrives. Shed Pro will start at €0.005 per submission (first 100 free), with early access pricing at €0.003 locked in for waitlist subscribers.

A Configurable List is a Jotform widget that allows respondents to enter multiple rows of data with custom columns. For example, you might use it to collect a list of team members with Name, Email, and Role columns. When exported, this data appears as comma-separated values like: Name: John, Email: john@example.com, Role: Developer. Shed parses this format and creates separate columns for Name, Email, and Role.

A Product List is a Jotform payment field that collects product selections with quantities and prices. When exported, it appears in a format like: Product Name (Amount: $25.00, Quantity: 2). Shed recognizes this format and splits it into separate columns for Product, Amount, and Quantity, making it much easier to analyze sales data or create reports.

Each splittable column you select gets its own dedicated tab in the output. Within that tab, every item row from the widget is expanded into its own row with separate columns for each field (e.g., Name, Email, Quantity). The original submission's other data is duplicated alongside each item so you can easily filter, pivot, or analyze by individual line items.

• File Upload & Jotform API: Results are downloaded as an Excel (.xlsx) file with a tab per split column
• Google Sheets: Results are written directly back to your sheet as new tabs — no download needed

Shed supports multiple input sources and formats:

• Excel (.xlsx): The default Jotform export format — fully supported including multi-sheet workbooks
• CSV (.csv): Plain text format, works with any spreadsheet software
• Jotform API: Pull submissions directly from your Jotform account
• Google Sheets: Connect a sheet and Shed writes results directly back as new tabs

For file uploads and API sources, the output is an Excel (.xlsx) file with a tab for each split column. For Google Sheets, results are written in-place.
Note: Legacy .xls files are not supported. Please save as .xlsx or .csv before uploading.

If Shed isn't automatically detecting your columns, try these steps:

• Verify the export: Re-export from Jotform and ensure you're selecting the "All Submissions" option
• Sample data: Make sure your export contains at least one submission with Configurable List data filled in

API key issues are usually easy to fix:

• Copy the full key: Make sure you've copied the entire API key from Jotform without any extra spaces
• Check key permissions: Your API key needs "Full Access" permissions. Generate a new key if needed
• Enterprise accounts: If you're on Jotform Enterprise, you may need to use the EU API region. Shed will auto-detect this.
• Try SDK login: If API key issues persist, use the "Login with Jotform" option instead

Yes, your data security is our priority. Here's how we protect your information:

• Temporary processing only: Uploaded files are held in server memory for up to 30 minutes to allow processing, then automatically deleted. Nothing is saved to disk
• Secure connections: All data transfers use HTTPS encryption
• Session-only tokens: API tokens and Google Sheets credentials are stored only for your active session and cleared when you close the browser
• No tracking: We don't track or analyze the content of your form data

No, we never store your credentials permanently. Here's how each connection method works:

• Jotform API key: Used only to fetch your submissions during the session, then discarded
• Jotform SDK login: Temporary tokens handled through Jotform's official OAuth flow — we never see your password
• Google Sheets: Shed uses a service account you share your sheet with. We don't access your Google account — only the specific sheet you grant access to
• All credentials and session data are cleared when your browser session ends