Click that plus sign and select "Import."Ĭlick the upload box that reads "Select file from your computer," and locate the file entitled "Blog Editorial Calendar - Excel" that was included in the ZIP file you downloaded in Step 1 above. Using the same dropdown menu you used to create your editorial calendar, you'll now import the Excel file itself into Google Calendar. Import your XLS or CSV file from the same dropdown menu. When you're done filling in the details, click "Create calendar." This includes a brief description of your calendar, as shown below, to give people proper context when you invite them into this calendar. Fill out the details of your new calendar.įill out the fields that appear on the next screen. Then, in the dropdown menu that appears, select "Create new calendar." To do this, go into your Google Calendar and click the plus sign to the right of "Other Calendars," as shown in the screenshot below. Next, set up your Google Calendar to accommodate the information in your Excel spreadsheet.
Use the left hand dropdown menu to create a new calendar. Just make sure you're already logged into the Gmail account you want this calendar to give access to. Once you've downloaded (or created) a calendar that opens in Microsoft Excel, it's time to open Google Calendar.
Next we'll show you how to import the Excel calendar template you downloaded in the previous step into Google Calendar. Google Calendar makes it easy to load a calendar you might have pre-created in another program into Google. The publish dates on the templates you download will be stamped for a previous year.įeel free to change them to the current year in the spreadsheet itself - you can also drag them to the dates of your choosing after uploading the file into Google Calendar. Customize your template and prepare for import into Google Calendar. In this blog post, we'll be going over how to import the Excel template into Google Calendar. Download HubSpot's free editorial calendar templates.įirst thing's first: Download the calendar templates above (they're free.) By doing this, you'll have three editorial calendar templates on your computer to use at your leisure: one for Google Calendar, one for Excel, and one for Google Sheets. Share your editorial calendar with others.Select which calendar to add this file to.Import your XLS or CSV file from the same dropdown menu.Fill out the details of your new calendar.Use the left-hand dropdown menu to create a new calendar.Customize your template and prepare for import into Google Calendar.Download HubSpot's free editorial calendar templates.
0 kommentar(er)
