Spreadsheetsolving.com’s compilation of free, customizable, printable math worksheet generator spreadsheets

With summer starting, we thought it would be helpful to put all of our math worksheet generator spreadsheet posts into one (somewhat) organized list. We’ve been creating these spreadsheets over the past three years to help supplement math learning for our own kids.

Note that all of these spreadsheet generators are done in Microsoft Excel. In order to use the free Google Sheets software, you can download and save the .xlsx file onto your computer, go to Google Sheets, and then hit File->Import-> Upload, and select the file. It might need some minor formatting/fitting to print.

Math Worksheets

General Math Worksheet generator – allows parent to set the maximum number size, and what operation, generates a random math worksheet: random math worksheet

Fill in the blank Math Worksheet generator – similar to the prior math worksheet, but instead of figuring out the sum in a standard (addend + addend = sum) problem, one of the three is randomly blank and the student fills in the blank: Math Worksheet generator

Division Math Worksheet generator – the logic and format for a division math worksheet generator was slightly different from the previous: Division Math Worksheet

Addition and Subtraction Math Facts speed spreadsheet – similar to the general purpose spreadsheet but designed to be a speed test of addition and subtraction math facts: Addition and Subtraction Math Facts Speed Worksheet

Number sequence pattern math worksheet generator – here you have a sequence of numbers and can choose spacing, number size, number of blanks for the student to fill out: Number Sequence Pattern Math Worksheet

Math Dice style worksheet – students try use math functions on the randomly generated input numbers to get to the answer number: Math Dice Worksheet

Practice with time math worksheet generator: Time Math Worksheet

Math word problem worksheet generator – this one is a bit crude, but perhaps someone could expand upon it: Math Word Problem Worksheet

Printable Flash Cards

General Purpose Flash Cards with user input and double sided printing: https://spreadsheetsolving.com/create-and-print-physical-flash-cards-with-this-microsoft-excel-template/

Addition and subtraction with math facts under 20 – Here we use our general purpose flash cards spreadsheet and enter in some math facts that students should have memorized: https://spreadsheetsolving.com/printable-math-facts-flash-cards-for-single-digit-addition-and-subtraction-with-carrying/

Multiplication Flash Cards: https://spreadsheetsolving.com/printable-multiplication-flash-cards-spreadsheet/

Division Flash Cards: https://spreadsheetsolving.com/printable-division-facts-flash-cards-spreadsheet/

Printable division facts flash cards spreadsheet

Today’s post is another extension of our series on flash cards. Since we made our multiplication flash cards last, the division flash cards were easy to make by reversing the multiplication answers:

We basically need double the flash cards since 20 divided by 5 and 20 divided by 4 are two different problems, whereas 4×5 and 5×4 are effectively the same.

Download the printable division flash cards spreadsheet here:

Printable Division Math Worksheet Generator Spreadsheet

Today we’ll build a dedicated division spreadsheet, where we set parameters for the problems and print an unlimited number of different division worksheets.

The inputs we’ll allow the user to enter are the maximum dividend (number to be divided) size, the maximum divisor, and whether or not we want to have the answers be able to have remainders.

So if the user selects yes or “y” for the remainder, the problem is relatively simple – we’ll have a random number for the answer between (1,100) for the dividend, and then a random number between (1,10) for the divisor.

If the user selects “n”, we’ll have a random number between (1,10) for the divisor, and then a random number between 1 and the max dividend/current divisor for the answer, then we’ll multiply the answer by the divisor to get the dividend.

Here’s how it looks like in full:

You can download the printable Microsoft Excel file here:

Printable time and clock math worksheet generator

Today’s printable math work sheet generator will center around the concept of time.

We’ll have two types of questions – one will ask the student to draw in the hands on a blank clock face for a random time. The other type of question will be a word problem that provides a start time and a time increment and asks the student to calculate the finish time. We would have loved to generate a random clock face time and ask what time it is but that turns out to be incredibly difficult in a spreadsheet.

To create the random times, we use the formula =RANDBETWEEN(1,12) for the hours, and then =RANDBETWEEN(0,59) for the minutes, then use the formula =TIME(hours, minutes, 0 seconds) for the time to display. We also added in some logic to allow for the times to round to 5’s if the user puts in a “y” in cell E2.

Check out the spreadsheet here:

Here’s how the final product looks:

Addition and Subtraction Math Facts Speed Worksheet

Today’s post will be another variation of our generic Math Worksheet Generator that we’ve posted before. This worksheet will give students the opportunity to practice their addition and subtraction math facts, so that eventually  things like 9+7 = 16 and 17-9 = 8 will come more quickly.

For the subtraction facts spreadsheet, we made the first number a random number between 11 and 18, and the second number a random number between the first number minus 9 and 9, in order to make the answer a single digit math fact.

For the addition spreadsheet, we made the answer a random number between 11 and 18, and then hid it, then filled in the two addends with one random number and then the answer minus the random number.

Check out the spreadsheet here. We’d also recommend using a stopwatch to help students try to increase speed: Addition and Subtraction Speed Worksheet

Create a customizable and printable check-off calendar spreadsheet

Now that are kids are getting older, we want to start getting them into good daily habits. This usually requires quite a bit of encouragement / threatening, but what might work best at the end of the day is bribery.

We created this customizable check off calendar that allows the user to pick their “tasks”, the number of days (up to 30), and the prize (we recently introduced our kids to Dave & Busters and they love it). The spreadsheet then lists the tasks with a check box for the number of days selected. The key logic here was the IF() Function.

The spreadsheet can be downloaded here. Enjoy! Habits Calendar Spreadsheet

Understand and estimate your taxes with this spreadsheet

Tax day is coming up, and like many other families we plug a bunch of numbers into our tax software and pay/receive whatever it tells us to do. While this is effective, it doesn’t allow for much understanding of what is going on behind the scenes of how the numbers are calculated.

Also, if a family has two earners, this spreadsheet could help explain why there was a refund/underpayment by breaking out the federal and state tax rate each person paid, and compares that to what the tax rates were overall for the couple.

We repurposed the spreadsheet used for our post Will the Tax Cuts and Jobs Act make you pay more or less in taxes?, so look there for more details on how it was built. Note that this spreadsheet only works for a married couple filing in California (feel free to tweak it for your own needs. Also of course this is highly simplified with no investment income, etc).

Here’s an example, we filled in $100k income for person 1, $20k federal withholding, and $5k state withholding from their W2.  We also filled in their spouse’s $50k income and withholding, along with 12k in mortgage interest, $6k in property tax and $500 in charitable contributions, along with 2 kids”:

They would have owed roughly $18.7k in federal tax and $5,322 in state tax, for a 12.5% federal rate and 3.5% state rate.  We can see both spouses over-withheld by 7.5% and 3.5% roughly in this fictional example.

Check out the spreadsheet here: Tax Estimator

How well mixed is your melting pot? Calculate a Diversity Index with a Spreadsheet

“If you can’t measure it, you can’t manage it” – supposedly Peter Drucker

A unique feature of the United States is its diverse population, tied together by shared values. Generally a commonly-embraced aspiration, diversity is promoted as a healthy feature of groups within society (usually, although the trend might appear otherwise). But can diversity be measured?

What if we could come up with an index that measures how well “mixed” a set of groups is, a so-called Diversity Score?  For instance, can we create an index such that a prison and its subset gangs falls on the less diverse/less well-mixed end and a Benetton commercial on the other? Once we have a method, we can apply it to other places like school districts, college fraternities and sororities, social groupings within a company, and many more. That’s the beauty of spreadsheets! Continue reading “How well mixed is your melting pot? Calculate a Diversity Index with a Spreadsheet”

Top 3 Spreadsheets You Need (but Never Knew!)

TechsmithWorAEA6.pngLook no further! Whether you are a traveler, student, teacher, parent, or coach, here are our top 3 spreadsheets that can benefit you. Select any choice below to access both our spreadsheet and video tutorial.

Continue reading “Top 3 Spreadsheets You Need (but Never Knew!)”

Date & Time Functions in Spreadsheets

TechsmithWorE224.pngSpreadsheets can generate date and time data, which are useful when tracking tasks, resolutions, or priorities; managing deadlines; and organizing calendar-based events. We’ll introduce a few of these functions and their applications in our post and video below!

Continue reading “Date & Time Functions in Spreadsheets”

The Ultimate Wedding Planning Spreadsheet

sa-laguna-beach-fairmont-hotel-wedding-photography-573
Photo: Pye Jirsa

Planning a wedding or a large party? A spreadsheet can be your guide as you navigate through this exciting, busy time! Whether it is keeping your guest list organized, creating a vendor comparison list, or developing a budget, you can rise above wedding planning stress with this reliable, easily accessible tool! Continue reading “The Ultimate Wedding Planning Spreadsheet”

Create & Automate Large Order Forms

TechsmithWor9460.pngAs a student leader of your club or sports team, you’ll benefit from an order form template! If you’re in charge of collecting info such as t-shirt orders or cookie sales, this spreadsheet template will make your life easier by tracking user-entered data and automating key data.

Continue reading “Create & Automate Large Order Forms”