Line distribution spreadsheet template

Why export to a spreadsheet at all?

The on-page results card is built for quick reading and PNG sharing. Spreadsheets help when you want custom charts, side-by-side song comparisons, rehearsal notes in adjacent columns, or a durable archive outside the browser’s IndexedDB. CSV keeps timing rows and a summary table that match what the maker computed. JSON preserves a fuller project snapshot for backup.

Exporting also reduces fear of clearing site data. Autosave is convenient on one device, but a CSV in Drive or a JSON file in your documents folder survives browser resets. Creators who post weekly distribution graphics often keep a sheet per comeback cycle; this workflow feeds that habit without requiring you to retype clocks by hand.

This page does not claim third-party spreadsheet features beyond ordinary import. Excel and Google Sheets change menus over time; the steps below use stable ideas—File → Import, Data → From text, or simply Paste into A1—so you can adapt labels on your version.

Export CSV or JSON from the maker

Open the free tool on the home page. Add members, mark lines with timing pads or ranges until the results look right, then open Export. Choose CSV when you want rows for Excel or Sheets. Choose JSON when you want a portable project backup. Copy text remains available if a download is blocked on a locked-down phone browser.

CSV downloads use a plain download link rather than the Web Share sheet, which avoids false “success” states on some mobile browsers. Save the file somewhere you can find—Downloads, Files, or a cloud folder. No account on this site is required for those exports in the core tool.

If the project has no valid segments, the export controls prompt you instead of writing an empty broken file. Fix timing first, then export again. Filenames are simple; rename them with the demo song title if you keep many sheets.

CSV column meanings

The CSV has two tables separated by a blank line. The first table lists every valid segment. Columns are: member (display name), start (milliseconds), end (milliseconds), durationMs (end − start, integer milliseconds), startClock (readable clock), and endClock (readable clock). Clocks help humans; millisecond columns help spreadsheets compute without parsing 0:12.3 strings.

The second table is the summary: member, durationMs (union duration used for shares), share (ratio), sharePercent (percent formatting), and rank. Fairness itself is visible in the UI and PNG; if you need the index in a sheet, compute Jain from the summary durationMs column with the same formula described in the fairness guide, or copy the percentage from the results card into a notes cell.

Member names are escaped for spreadsheet safety. Names that look like formulas are neutralized so Excel does not execute them. Newlines inside names are flattened. That matters when fans paste decorative text into member fields.

Open the CSV in Excel

On desktop Excel, use File → Open and select the CSV, or Data → From Text/CSV if your build prefers Power Query. Confirm UTF-8 if non-ASCII member names appear. You should see the segment header row first. Scroll to the blank separator, then the summary header. Freeze the top row if you like, then select the summary durationMs values to insert a pie or bar chart.

To combine multiple songs, paste each summary block onto its own sheet tab named after the demo title. Keep millisecond columns as numbers—not text—so SUM and charts work. If Excel split columns incorrectly on a locale that expects semicolons, re-import with comma delimiter selected.

Windows and macOS menu names differ slightly, but the idea is identical: treat the file as delimited text, verify headers, chart the summary. You do not need macros or an add-in from this site.

Open the CSV in Google Sheets

In Google Drive, upload the CSV and open with Google Sheets, or from a blank sheet use File → Import → Upload. Choose “Replace current sheet” or “Insert new sheet.” Separators should detect as commas. After import, insert a chart from the summary sharePercent or durationMs columns.

Sharing a Sheet link is often easier for collab reviews than emailing PNGs alone. Remember that uploading the CSV to Drive is your choice; the maker itself did not upload your audio. Only the timing numbers you exported leave the browser when you save the file and move it.

Mobile Sheets can open the file too, though column width is tighter. Landscape helps when checking startClock and endClock side by side.

Copyable sample table (illustrative)

Paste the following text into a sheet if you want to practice charts before exporting a real project. Names and times are fictional demos only—not a real group.

member,start,end,durationMs,startClock,endClock
Aria,0,12000,12000,0:00,0:12
Bora,8000,18000,10000,0:08,0:18
Cleo,14000,20000,6000,0:14,0:20

member,durationMs,share,sharePercent,rank
Aria,12000,0.4286,42.9%,1
Bora,10000,0.3571,35.7%,2
Cleo,6000,0.2143,21.4%,3

This sample mirrors the overlap demo from the fairness guide: three positive members, unions 12s / 10s / 6s. After pasting, create a pie chart from the summary sharePercent column to simulate a results card inside Sheets.

JSON export notes

JSON is the fuller project backup: members, colors, segments, and related fields the maker needs to restore work. Spreadsheets do not read that tree as neatly as CSV. Use JSON when you might re-import into a future version of a compatible tool, or when you want a single file archive. Use CSV when your immediate goal is Excel or Google Sheets charts.

Do not email JSON that contains private rehearsal notes if your member names encode unreleased information you are not ready to share. The format is plain text and readable.

Practical tips

Export after you finish cleaning overlaps, not before. Rank and sharePercent will otherwise churn. Keep one CSV per song version (for example “demo-chorus-only” versus “demo-full-track”) so sheet tabs stay understandable. When comparing two versions, copy summary durationMs into adjacent columns and compute deltas with ordinary sheet formulas.

If a download seems blocked, use Copy and paste into a blank sheet, or share the PNG while you move to a desktop browser for CSV. Phone browsers vary; the maker’s download path is intentionally simple.

For the math behind summary durations and fairness, read the companion guide on calculating line distribution. For product shape versus one-shot generators, see the Perchance-style alternative page. All of those pages link back to the home tool anchor so you can start timing without hunting for a signup form.

Read how to calculate line distribution fairness