Free Excel Templates

Welcome to the hub for free Excel templates that are simple to use and effective at solving needs in business and home. You would need Microsoft Excel to use these templates. Almost all templates are compatible with Excel 2010  (or above) for Windows and Excel 2011 (or above) for Mac.

Each template has detailed documentation with screenshots and video demos. You can easily get started and instantly benefit. If there are any questions, please post them as comments in the corresponding template page. Your feedback is invaluable and helps me improve the templates so that more people can benefit.

To find the template you are looking for, please see the free templates categorized under Small Business Management, Project Management, HR, Calendars, Data Visualization, Personal Finance and School.

If you find the templates useful, please  share with your friends. To get notified of new templates and updates of existing templates, please subscribe to our social channels (YouTubeFacebook ). I appreciate your support.

New Excel Templates

2020 Excel Calendar Template – 20 Calendar Designs – Free Download

Download this free Excel template and create your own personalized calendars in Excel. This calendar template contains 20 designs that can be used to create calendars for any year.

PTO (Paid Time Off) Balance Calculator for Hourly Employee

Download this free Excel template to track and calculate Employee’s PTO accrual balances based on hours worked by the employee. Automatically calculates current PTO balance and projected future balance.

Combinations Generator Excel Template

Download this free Excel template to create all combinations of 6 lists of values instantly. Enter your own lists of values and instantly view all combinations. This template can be used for up to 500 combinations. This sheet can be expanded.

Small Business Excel Templates

Inventory and Sales Manager 2020 (Free Excel Template) for Small Business

If you are running a small business, this template helps in managing inventory and sales of buying products from suppliers and selling to customers. (Retail/Wholesale).

Retail Inventory Tracker 2020 – Free Inventory (Stock) Management template

If you are running a retail business, download this free template to track where you plan to buy products from your suppliers and then sell them to customers.

Small Business Product Catalog in Excel – Free Template

Download this template, If you are looking for a product catalog to share your product info with your prospects and customers. This catalog is very handy and is available without payment processing.

Free Excel Inventory Template for Manufacturing Businesses

Download this free Excel template to automatically calculate the current raw material stock as well as determining how many units of each product you can make using the raw materials available.

Invoice Tracker Template for Small Businesses – Free Download

Download this free Excel template to keep track of all your sales invoices in one place. Enter payments made by customers and let the template calculate balance outstanding amounts.

Free Excel Inventory Template for Rental Businesses

Download this free Excel template to keep track of all your equipment or assets rented out to your customers. Also, determine the expected inventory in the future, based on future dated rental orders/contracts.

Sales Pipeline Tracker Template – Track sales leads in Excel

Download this free Excel template, to manage the data on your sales leads. Also, this template helps in determining the weak area of your sales funnel & identify bottlenecks in the sales process.

2020 Excel Invoice Template – Create Invoices for Small Businesses

Download this free Excel template, to create professional sales invoices for your small business instantly. This template handles tax rates and discounts at the product level.

Human Resources Excel Templates

2020 Leave Tracker & Vacation Tracker Free Excel Template

Download this free Excel template to calculate employee attendance, provides a calendar view of leave for multiple employees and also print an annual employee report. Track vacation of multiple employees including partial days of leave.

Employee PTO Tracker & Calculator 2020 – Free Excel Template

Download this free Excel template to calculate PTO balances where PTO is accrued based on tenure. This simple sheet associated with data validations can be used as a vacation tracker and also a PTO vacation accural calculator.

Employee Vacation Planner 2020 – Free Excel Template

Download this free Excel template to assess the coverage of team members’ availability during a month. This Excel template can be used every month to ensure that you are aware of exact coverage and plan the work accordingly.

Recruitment Tracker 2020 – Free HR Excel Template for Recruiters

Download this free Excel template to track status of the applicants (candidates) in an organized way. Get an instant view of how many applicants are in the recruitment pipeline and where in the funnel applicants are dropping off.

New Employee Checklist 2020 – Free Excel Template

Download this free Excel template to track the onboarding activities of a new employee. This template is extremely customizable and provides a printable checklist for each employee. Maintain data of all employees in one file.

Employee Timesheet 2020 – Excel Time card & Work Hours Calculator

Download this free Excel template to print weekly, Biweekly & monthly timesheets by just entering the time card entries like time in, time out & break time. Contains automated calculations
& reports on multiple timesheets.

PTO (Paid Time Off) Balance Calculator for Hourly Employee

Download this free Excel template to track and calculate Employee’s PTO accrual balances based on hours worked by the employee. Automatically calculates current PTO balance and projected future balance.

Project Management Excel Templates

Project Planner 2020 – Free Excel template for Project Planning

Download this free Excel template to make project planning simpler. This template will help in identifying opportunities, determining due dates and allocating resources based on skill matching.

Task Manager (Free Excel template)

Download this free Excel Template to assist in remembering tasks that need to be done. This template also provides a monthly calendar for reference and print sheet with pending tasks and upcoming tasks. This template handles 6 different tasks and supports updating them.

Project Pipeline Tracker 2020 – Free Excel Template

Download this free Excel template to track projects and calculate the effectiveness in completing them. Obtain information about all the projects that are on various stages of progress.

Earned Value Management – Free Excel Template

Download this free Excel template to measure the progress of a project with respect to cost. Calculate cost and performance to estimate the project completion values to understand the status of the project.

Data Visualization & Analytics Excel Templates

Geographic heat map – India (Excel template)

Download this free Excel template to generate geographic heat maps for India. The template has a hidden worksheet and conditional formatting is used to create the printable ready to use heat map. Use this template to showcase position of one state.

Social Media Dashboard – Free Excel Template to report social media metrics

Download this free Excel template to consolidate metrics across multiple Social networks and present it in a single-page dashboard.

Cricket World Cup 2015 – Free Excel Dashboard

Download this free Excel template to calculate all the stats based on raw match data and present it in a dashboard. There are three views available. Cup view, Team view & Match view. Change data to view corresponding metrics changes.

Sales Report Excel Template – Top 10 & Bottom 10 Products by Sales

Download this free Excel template to identify the best and worst-performing products easily. Automated reports with a lot of customization options. Compare sales data to attain clarity.

2016 Olympics Dashboard – Explore Rio Olympics data in Excel

Download this free Excel template to access and explore the results of the Rio Olympics. This dashboard template has an Olympic view, country view, and sports view. Accounts for unusual scenarios.

Tamil Nadu Heat Map by District – Free Excel Template

Download this free Excel template to create heat maps instantly. Data on each district can be entered in any order and color values can be customized. The generated heat maps are printable.

2016 U.S. Presidential Election Tracker – Excel Template

Download this free Excel template to view the results of the 2016 U.S presidential election. Simply enter data and view the results on the map. The data can be used for analyses of the election performances.

Kerala Heat Map by District – Free Excel Template for Data Visualisation

Download this free Excel template to enter your own data and create heat maps instantly. Enter data by district, choose a color range and create readily printable heat maps.

2014 Indian Lok Sabha Elections Results in Excel

Download this free Excel template that allows us to view 2009 and 2014 Election results, and gain insights through simple data visualization techniques. Also, find techniques that can be applied on other topics or datasets.

World Heat Map by Continent – Free Excel Template for Data Visualisation

Download this free Excel template to create heat maps of the world instantly. Enter your own data in the template, customize the features and options and print.

Activity Pattern Heat Maps – Free Excel Template

Download this free Excel Template to visualize activity patterns. By understanding the patterns this template uses you can make important decisions. This template uses simple formulas and conditional formatting.

Product Rating Report (5 Star Ratings) – Free Excel Template

Download this free Excel template to create a report on product rating (5 Star Ratings) data. By entering the product’s rating data in a simple table, the report is automatically generated for the product comparison.

Calendar Excel Templates

All-Purpose Calendar Maker (Free Excel Template)

Download the free Excel template to create readily printable calendars. Customizable weekends, contains 2 designs, start with any month, highlighted event dates & readily printable.

Excel Calendar Template – 17 Calendar Designs in Excel – Free Download

Download this free Excel template to create your own personalized calendars in Excel. This template contains 17 calendar designs. Customizable holidays and events. Readily printable, Exportable to PDF.

2019 Excel Calendar Template – 19 Calendar Designs – Free Download

Download this free Excel template to create calendars for any year. Choose from readily printable 19 different calendar designs, including annual (yearly), monthly, weekly and daily calendars.

2020 Excel Calendar Template – 20 Calendar Designs – Free Download

Download this free Excel template and create your own personalized calendars in Excel. This calendar template contains 20 designs that can be used to create calendars for any year.

2013 Tamil Calendar with Tamil dates and Tamil Nadu Holidays (Excel template)

Download this free Excel template to create your own personalized customizable tamil calendars. Add your personal events and print the calendars.

School/Education Excel Templates

Report Card – Basic (Free Excel Template)

Download this free Excel template to automate the creation of student report cards and provide meaningful academic performance information to teachers and instructors, with minimal effort. It contains Class view, Subject view & Student view.

School Attendance Register and Report v2 (Free Excel Template)

Download this free Excel template to use as an attendance register tool. This template can be used to create class attendance report, student attendance report. The reports are printable.

Quiz Master (Excel template) to conduct quizzes

Download this free Excel template to conduct a quiz. Customize your own questions and answers. The template is very suitable for multiple-choice questions. Automatic score board updates.

Personal Finance Excel Templates

Personal Finance Manager 2020 (Free Excel Budget template)

Download this free Excel template to manage your personal financial situation. Set budgets and see how you are performing against it. Verify your savings and expenses against a category.

Group Shared Expense Calculator – Free Travel Expense Sharing Template

Download this free Excel template to calculate each person’s share of expenses in a group. This template really helps to calculate how much each person owes and to whom.

Loan Comparison and EMI Payment Calculator (Excel template)

Download this Excel template to help in decision making on loans. Calculates EMI, Last payment month, Number of Payments. Print loan comparison. Compare loans from various banks with various interests.

322 thoughts on “Free Excel Templates

  1. Great work! Do you have one on room booking/rental with specified timings for small businesses? I saw the Rental inventory one but I am missing the specified timings like booking out a conference room on specified date.

    1. Thanks for using our template and sharing positive feedback.

      We will try to develop a template that can handle room bookings including meetings and conference rooms.

      Best wishes

  2. Hello
    Sir i need Fee Record kindly help in this regrads

    1. Thanks for your message

      We do not have a fee tracking template yet. We will try to add one to our portfolio soon.

      Best wishes

  3. do you have free template for Recruitment Manager

    1. Recruitment tracker template is free: https://indzara.com/2015/09/recruitment-tracker-free-excel-template/
      The Recruitment Manager template is available for purchase: https://indzara.com/product/recruitment-manager-excel-template/
      Best wishes.

  4. Ooh my goodness this is Amazing!

    1. Thanks!!!

  5. thanks i am checking y o u r Files, this is awesome thanks a lot,
    but im not found what i want
    i want Order management system by Google sheets and i don’t have money please help my thank you so much

    1. Thanks for your message.

      Due to the heavy workload, we are not accepting any customized project.

      Best wishes

      1. Hello,
        I have watched your videos about excel templates for students attendance register on YouTube and it is amazing. Good job.

        I would want to know you have a much simpler Free excel template attendance register to manage a group (not students) of about 150 to 200?
        Thank you.

        1. Thanks for your message.

          The Student Attendance Register, https://indzara.com/product/student-attendance-register-excel-template/, can handle up to 200 students.

          We are not accepting any customized projects due to a heavy workload.

          Best wishes

  6. hi sir
    thanks i am checking u r Files, this is awesome thanks a lot,
    but iam not found what i want
    actually iam looking for costing file for manufactiong item like(label printing)
    possible to share like file.

    1. Thanks for your message.

      Our premium template Manufacturing – Inventory and Sales Manager – Excel Template at https://indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ handles all aspects of the manufacturing process. Please review the same and we will be happy to answer your queries.

      Best wishes

  7. First of all I would like to congratulate you for the templates, they are really useful!!
    Also, regarding the Leave Tracker and Vacation tracker template, I would like to know if it is possible to have the view from quarters instead of months. Could you please help me how to configure it?

    Thank you

    1. Thanks for using our template and sharing your positive experience.

      The template is designed to report on a monthly basis. We will try to incorporate these features into the future release.

      Best wishes

      1. Thank you for your response!

        Kind regards

  8. Hello,

    Question to Resource Capacity Planner.
    I have resources from different countries in 1 team. I want to enter bank holidays according to their countries, that it will automatically decrease capacity only for person who is from Saudi Arabia or Germany. Not for all. Please reply, it’s important.
    Thanks

    1. Thanks for your interest. Holidays are applied to all employees. In this case, we have to enter them in vacation table for every employee individually.
      Please let me know if any questions.
      Best wishes.

      1. Does the tool couldn’t match f.e Resource1:Saudia Arabia?
        I want to have information, if resource is off due to bank holiday or his vacation. Please give me a tip how to resolve that.
        Thank you!

        1. Thanks for your message.

          The holidays/leaves entered in the settings will apply to all the employees.

          To overcome this, you can assign leaves to individual employees separately.

          Best wishes

  9. Can I able to publish my design in your website..?

    1. Thanks for your interest. We are currently not taking up external designs. However, we will be glad to review and provide feedback.
      Best wishes.

  10. Please, I need a template that can manage my store, control the price and keep records of the everyday or week sales

    1. Thanks for your message.

      Please review our premium template Retail Business Manager – Excel Template at https://indzara.com/product/retail-business-manager-excel-template/

      Best wishes

Leave a Reply

Your email address will not be published. Required fields are marked *