Skip to main content
Back to Numbers generators

Numbers

Random Percentage Table Generator

Used by developers, writers, and creators worldwide.

A random percentage table generator creates values that sum to exactly 100%, spread across any category names you define. Designers, developers, and educators all reach for this kind of tool when real data isn't ready yet. Supply your labels — say, "Red, Blue, Green, Other" — pick a decimal precision, and the generator handles the math instantly. Convincing dummy data matters more than most people think. A pie chart showing 34.2%, 28.7%, 21.5%, and 15.6% looks like real research; four identical 25% slices screams placeholder. Use this generator to populate mockup dashboards, Figma prototypes, or training slides with distributions that actually look plausible — before a single real data point exists.

Loading usage…

Free forever — no account required

How to use

  1. Choose your options above
  2. Click Generate
  3. Copy your result

Detailed instructions

  1. Enter your category names in the Categories field, separated by commas, replacing or extending the defaults.
  2. Set the Decimal Places value to match the precision your target chart or report requires.
  3. Click Generate to produce a randomly distributed percentage table that sums to 100%.
  4. Review the table and click Generate again if the distribution looks too uneven for your use case.
  5. Copy the output and paste it directly into your spreadsheet, slide deck, or charting tool.

Use Cases

  • Populating a Figma pie chart with believable placeholder category breakdowns before real analytics are available
  • Seeding a Chart.js or D3 demo with varied percentage data to test label overflow and slice rendering
  • Generating unique survey-result distributions for each student in a data-literacy classroom exercise
  • Filling a PowerPoint market-share slide with mock competitor figures that look like genuine research
  • Creating sample budget allocations across departments for finance training workshops in Google Slides

Tips

  • Use 4 to 6 categories for pie charts — more than 7 produces slices so small they lose visual meaning.
  • Set decimals to 0 when preparing quiz questions; round numbers are easier for students to work with mentally.
  • If a mockup needs a clear dominant category, generate several times and keep the run where one value exceeds 40%.
  • Name categories after real-world segments — 'Direct', 'Organic Search', 'Paid', 'Social', 'Referral' — to make dashboard mockups instantly convincing to stakeholders.
  • Paste the table into a spreadsheet and use a SUM formula to verify the total — useful for teaching students to validate imported data.
  • For financial mockups, set decimals to 2 and rename categories to budget line items like 'Salaries', 'Marketing', 'Infrastructure' to match realistic report formatting.

FAQ

do the percentages always add up to exactly 100

Yes, every time. The generator normalises all values so the sum is precisely 100%, and any rounding remainder is absorbed by the last category. You can verify this by adding the column yourself — it will always check out.

what decimal places setting should i use for presentations vs reports

Use 0 for clean round-number teaching examples, 1 for typical slide deck charts, and 2 when mimicking analytics exports or financial breakdowns. Higher precision also reduces the chance of two categories sharing the same value, which makes a table look more realistic.

can i paste the output directly into excel or google sheets

Yes. Copy the generated table and paste it into your spreadsheet, then use Data › Text to Columns in Excel or split-text options in Sheets to separate category names from values. Alternatively, copy just the percentage column and paste it next to labels you've already typed.