To get bill due dates into Google Calendar from a sheet, arrange columns named Subject, Start Date and Description, download the sheet as a CSV, and import that file from Calendar's settings into a calendar of your choice. It is a one-time load, so a bill that repeats every month needs a row for each month, or a recurring event set up in Calendar itself.
Which columns does Calendar need?
Google Calendar reads a CSV by its column names. The headers it recognises include Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description and Location. For bill reminders you need three, and one more makes it tidy.
| Column header | What to put | Example |
|---|---|---|
| Subject | The bill's name and the amount you expect | Electricity bill, about 2,400 |
| Start Date | The due date | 12/05/2026 |
| All Day Event | TRUE for a bill with no clock time | TRUE |
| Description | How to pay and a reference to look for | Pay by UPI; consumer number is on the paper bill |
Calendar's own sample file uses month/day/year, so 12/05/2026 means 5 December 2026. Download the sample from the import screen and compare it with your sheet before you go further. If your sheet uses day/month/year, convert the dates first.
How do I build the dates for the next twelve months?
Type the first due date as a real date in B2. In B3 use =EDATE(B2, 1), which moves one month ahead on the same day, and fill down. Then in a column called Start Date use =TEXT(B2, "mm/dd/yyyy") to write the text in the format Calendar expects. EDATE keeps the day number, but a bill due on the 31st will land on the last day of a shorter month, so look at those rows.
- Subject: =A2&" due" gives, for example, "Society maintenance due".
- Start Date: =TEXT(B2, "mm/dd/yyyy")
- All Day Event: type TRUE once and fill down.
- Description: a short line of text, the same on every row of that bill.
How do I export and import the file?
- Make a new tab with only the columns Calendar needs, headings in row 1, no blank rows.
- Choose File > Download > Comma-separated values (.csv) while that tab is open, since the download covers the current tab.
- In Google Calendar on a computer, open Settings, then Import & export, then Import.
- Pick the CSV and choose which calendar receives the events. Press Import.
- Open the month view and check that a few due dates are on the right day.
What about bills that repeat every month?
There are two ways, and both are fine.
- Rows for each month: good when the amount or due date changes, such as an electricity bill. You list them with EDATE and import once.
- A recurring event made in Calendar by hand: good for fixed items such as a loan EMI or a society charge. Open the event and set it to repeat monthly, and it keeps going with no new import.
An import does not look at what is already in Calendar, and it does not update events later. If a due date moves, change the event in Calendar, and change your sheet too, or the two will disagree.
How do I get the reminder itself?
The imported event is only an entry. The nudge comes from the notification settings of the calendar that holds it. Open the Bills calendar's settings and add a notification, for example a day before and again in the morning. Check that notifications are turned on for the Calendar app on your phone.
Before you trust it
- The first row of the CSV holds the exact headers, with no spelling changes.
- Dates are in the same pattern as the sample file.
- You imported into a separate Bills calendar.
- Two or three events opened correctly on the right day.
- Fixed bills are recurring events, not twelve separate rows.
A calendar tells you when something is due, not whether you have the money to cover it. If you also want bills next to budgets and savings goals, SpendixAI Pro includes bills, budgets and savings goals in one personal workspace.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


