Kpiloom

How to use your Kpiloom dashboard

Every Kpiloom dashboard is a ready-made file with sample data, a Settings sheet and live formulas. Setup takes about 15 minutes. Pick how you want to use it:

On your computer with Excel

You need Excel 2016 or later, or Microsoft 365, on Windows or Mac. It works offline, and nothing needs installing.

  1. Download the file. Right after payment the .xlsx file downloads in your browser, and the same link is emailed to you (it works for 7 days). Save it somewhere you will find it again, such as Documents or your desktop.
  2. Open it in Excel. Double-click the file. It opens in Excel 2016 or later, or Microsoft 365, on Windows or Mac. If a yellow Protected View bar appears, click Enable Editing. There are no macros and nothing to install.
  3. Try it with the sample data. The Dashboard sheet opens first and is already filled with 2 years of sample data for a made-up business. Change the month and filters at the top to see every card and chart update.
  4. Add your own data. Open the grey data sheets. Select the sample rows under the headings, right-click and choose Delete Table Rows, then paste your data under the same headings. Keep dates as real dates and type numbers without currency symbols. The table grows by itself as you add rows.
  5. Set your details. On the Settings sheet, change the yellow cells: company name, currency, the month your financial year starts and the alert levels that turn a KPI red.
  6. Read your dashboard. Go back to the Dashboard sheet and pick a month, period and filter. Every number is a live formula. If something looks stale, press F9 on Windows or Formulas > Calculate Now on a Mac.
  7. Save, share and print. Save with Ctrl+S (Cmd+S on a Mac). To send a copy as a report, use File > Save As > PDF; the Dashboard is set up to print on landscape pages.

In Google Sheets (any browser)

You need a free Google account. It works in any browser, on phone and desktop. Your team sees the same live numbers.

  1. Download the file. Right after payment the file downloads in your browser, and the same link is emailed to you (it works for 7 days). Keep it on your computer for the next step.
  2. Upload it to Google Drive. Go to drive.google.com, sign in with any free Google account, click New > File upload and choose the file.
  3. Open it as a Google Sheet. Double-click the file in Drive so it opens in Google Sheets, then click File > Save as Google Sheets. Work in that new copy: drop-down filters and formulas work fully there.
  4. Try it with the sample data. The Dashboard tab is already filled with 2 years of sample data for a made-up business. Change the month and filters at the top to see every card and chart update.
  5. Add your own data. Open the data tabs, delete the sample rows under the headings, and paste your data under the same headings (Ctrl+Shift+V pastes values only). Keep dates as real dates and numbers without currency symbols.
  6. Set your details. In the Settings tab, change the yellow cells: company name, currency, the month your financial year starts and the alert levels that turn a KPI red.
  7. Share it with your team. Click Share, add your team's email addresses and give them Viewer access (Editor only for the person who updates the data). Everyone sees the same live numbers, on desktop or in the Google Sheets phone app. File > Download > PDF makes a printable copy.

Custom Builder dashboards

A dashboard you design yourself in the Custom Builder is used the same way as a ready-made one.

  1. Design it in the builder. Open the Custom Builder on the homepage, pick your industry, department, platform, theme, charts and features, and check the live preview.
  2. Pay and wait about 5 minutes. After payment your dashboard is built from your exact choices. The download button on the confirmation screen waits until the file is ready, and the link is emailed to you too.
  3. Open it like any Kpiloom file. A custom file opens exactly like a ready-made one: follow the Excel steps below to use it on your computer, or the Google Sheets steps to use it online.
  4. Check the How to use sheet. Inside the file, the How to use sheet lists the charts and features you chose, so anyone on your team can see how it was built.

Quick fixes

Excel says Protected View or the file is blocked

Click Enable Editing in the yellow bar. On Windows, if Excel still won't open it, right-click the file, choose Properties and tick Unblock.

Numbers show #VALUE! or a filter shows nothing

Usually a date or number was pasted as text. Make sure dates are real dates (they line up on the right of the cell) and numbers have no currency symbols or spaces.

Drop-down filters don't work in Google Sheets

You are probably viewing the uploaded file directly. In Google Sheets click File > Save as Google Sheets and use the new copy.

Charts stopped at the old sample dates

Delete all sample rows before pasting your data, so the data table holds only your rows, then pick a month that is inside your data.

My download link expired

Links work for 7 days. Email [email protected] with your order number (KL-…) and we will send a fresh one.

Still stuck?

Email [email protected] with your order number (it starts with KL-) and a screenshot. We reply within one working day. You can also browse the dashboards or read the delivery policy.