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:

Printable Multiplication Flash Cards spreadsheet

Today’s post is another extension of our very flexible Printable Flash Card Generator Spreadsheet. We plugged in the single digit multiplication combinations from 2-9 into the second sheet. To print the cards, print the first sheet two-sided, flip on the long edge, then cut the cards out.

Download the printable multiplication flashcard spreadsheet here:

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

Printable Math Facts flash cards for single digit addition and subtraction with carrying

As kids start to add and subtract bigger and bigger numbers, they will have to learn how to “carry” a 10 when adding two numbers that sum higher than 10, and “borrow” a 10 when subtracting a bigger number from a smaller number.

Today’s spreadsheet is an example case of our Printable Flash Cards Spreadsheet, where we put in all the addition and subtraction math facts that students will need to know quickly in order to do longer addition and subtraction problems that may need carrying and borrowing.

Check out the spreadsheet here: Printable Flash Cards

To print – print double sided, and flip on the long edge. There are two tabs (“cards1” and “cards2”) with 72 total flash cards to print. Wish we had some good advice for how to get your kids to actually practice with these…

A “Put the numbers in order” Math Worksheet Generator spreadsheet

This spreadsheet builds upon our previous similar math worksheets: Find the pattern and fill in the blanks and Use the input dice to get the target number.

In this printable math worksheet generator, the user/teacher would enter in two inputs: how many numbers to order and how large the numbers can be. Then, the spreadsheet does the rest and generates 7 problems for the student to practice ordering a series of numbers.

Download the spreadsheet here: Put the Numbers in Order!

A "Math Dice" inspired Printable Math Worksheet

Here’s another printable worksheet in our series of educational kids spreadsheets.  Today’s worksheet will revisit our “Math Dice” inspired spreadsheet game post that is now turned into a printable worksheet. We tend to like math activities in which kids are problem-solving and re-arranging numbers on the fly with many possible right answers, versus the standard computational “one right answer” spreadsheet.

The layout of this spreadsheet is similar to our original Pattern Recognition spreadsheet. Anyone can select up to 7 “dice” with the 8th number as the target. We’ll save you the gory details into how we used the rand() function and how we applied the formatting….and simply share the spreadsheet so you can start using it!

Try our Math Dice inspired printable worksheet.

A Custom Math Worksheet–arithmetic fill in the blanks

Today’s spreadsheet is a twist on our original Math Worksheet Generator Spreadsheet…..with a slightly more advanced variation!

Instead of (number) + (number) = fill in the answer, one of the addends or the answer itself will be randomly blank, and the student will have to fill in the missing value. 

We’ll spare you the gory details of how we adjusted our old spreadsheet to make this new spreadsheet (for each problem, we added in a random number 1-3, and then made the visible problem take either a blank or the actual number, and then added plenty of formatting).

Here’s the spreadsheet. Share your thoughts with us! 

The Bank for Kids – an educational bank ledger spreadsheet for parents

According to Scholastic, the recommended age to start giving kids an allowance is around 5-6 years. As parents of kids around that age, this makes sense: our kids are learning about coin values in school and starting to ask questions like “why can’t I buy a museum gift shop stuffed animal when you just spent four times that amount on groceries?”

With this newfound weekly cash flow, it’s a good time to introduce the concept of spending vs. saving, which is the cornerstone of many personal finance websites. When kids save, I suppose they could just keep the cash in a jar, but a more effective teaching tool would be to have them deposit it in the “Bank of Mom and Dad”, for not only safe-keeping, but also to earn an interest return on that saved money. The hope would be to illustrate the value of saving and for that savings to be “put to work” in generating even more money for them from interest.

Spreadsheet Inputs

We’ll use Google Sheets for today’s spreadsheet with the thought that we’d like our kids to view the spreadsheet (but of course not edit…).

We’ll set the spreadsheet up like one of the old “passbook accounts” that I had as a kid (and from which my subconscious is likely drawing this post from):

Passbook - Wikipedia

We’ll also have an input for the monthly interest rate. This is an interesting decision as real monthly interest rates are perhaps only 0.04% and may not actually entice your child to save any money to earn no interest. I’ll put in 3% in our example. If little Abby finds a way to borrow a million dollars at 1% and put it in our bank, we might go bankrupt (although that’ll be promising for her Wall Street career…).

Here’s how our spreadsheet looks so far:

Spreadsheet Logic and output

There’s not really much to the logic: the Date, Description, Deposit, and Withdrawal items will typically be manual inputs depending on what is happening (allowance, withdrawal to buy stuffed animal, gift from Grandma, etc.).

The balance will just be a formula (last balance + deposits – withdrawals).

For interest payments, the formula will go in the deposits. One complication is whether to pay a full month’s interest on money that was deposited during the month by just using the last balance for the interest payment. In the name of simplicity, I think that’s fine. If little Abby figures out a way to arbitrage you by putting a lot of money in on the 30th of the month and then taking it out on the 1st…her financial education would be complete.

Check out the spreadsheet here, The Family Bank. Save a copy by going to File – > Make a Copy

Create and print physical flash cards with this Microsoft Excel template

Today’s spreadsheet will allow users to create 36 flash cards on one page with two-sided printing. We first tackled the idea of spreadsheet flash cards with this post on virtual flash cards, and today’s spreadsheet will tackle physical, printable cards.

We’ll have a separate sheet for our questions, which will feed into a sheet with our flash cards:

Then we’ll make our flash cards. First, we hit the print function, in order to show the dotted page lines. Then we sized the cards into a 9×4 grid, merging and centering cells, and adjusting the box widths to fill in the page lines. Finally, we linked the cards to the question and answer cells from the ‘questions’ tab. This was a little tricky as when you print two-sided the answers need to be flipped across the middle in order for them to match up with the questions:

That’s pretty much it – download the spreadsheet and try it out for yourself! Flash Card Spreadsheet in Excel

To print the flash cards, you’ll have to use the print option: Print on Both Sides –> flip pages on long edge.

We added some ideas for various flashcards:

  • Single digit numbers that sum to double digits
  • US States, State Capitals, Population
  • African/European States/Capitals