Current location - Loan Platform Complete Network - Big data management - How to change the header of project sheet
How to change the header of project sheet
1. CSV import Google Calendar

The official tutorial is as follows:

Here I would like to say that with google sheet is really super good! There is no one!

Can be used to record any project or habit formation time log, but also not subject to platform limitations at any time to synchronize, and finally imported directly into Google Calendar can be!

I've used it to record the time I spent memorizing vocabulary according to Ebbinghaus' forgetting curve

First, create a new form in Google Sheets, and then fill in the header according to the following chart

"Project" is my own addition, there is no official requirement to add it, and it doesn't affect the import

Then, both the Start date and the End date can be saved with the shortcut command. End Date can use the shortcut command+; to fill in the current date directly

Start time and End Time can also use command+shift+; to fill in the current time

Super convenient! You can keep track of the time of completion on the fly, and you don't have to click on the schedule in Google Calendar to fill in the blanks one by one. Then you can export the Google sheet to CSV format

Download as .csv

And then import it into Google Calendar!

It should be noted that: Google sheet settings need to change the default settings of the language for the English language, the default format of the Chinese Date google calendar There is no way to recognize

Language area to English

I have imported a lot of times are displayed All day Event, and later found that this is the problem

2.

2. Pomotodo

Pomotodo This is its official website

Then I found this question in Zhihuohu: How to use Pomotodo?

Simply put, you can synchronize your tomato time to Google Calendar

I think it works really well. It's useful for people like me who need tomato time to remind themselves to take a break, who are OCD about keeping track of all their work hours in Google Calendar, and who don't want to take the time to create their own schedules == Very useful.

Of course, synchronizing to Google Calendar is a premium feature, so if you don't want to pay for it, you can use the method above to build a project form, record tasks at any time, and then directly import it is also very convenient!

Synchronizing to Google Calendar is an advanced feature.