Import a content calendar (.xlsx or .csv)

2 min readApplies to: Owners, admins and editors · web app

Upload a filled-in calendar and each row becomes a draft on your calendar.

Already keep a content calendar in a spreadsheet? Upload it, and each row lands on your calendar as a draft post.

Open Calendar in Wallflower

1. Open the importer #

   Open Content, then Calendar, and click Import Calendar. The Import content calendar dialog opens. You can also get there from Fill My Week with Import content calendar.

   

2. Download the template #

   In the dialog, click Download template. It's an .xlsx file with the right columns already set up.

   

3. Fill in the columns #

   Each row needs:

   • Date: when the post should go out.
   • Time: what time it should go out.
   • Platform: which connected platform it's for.
   • Content Type: the kind of post it is.
   • Caption/Idea: what the post says. The optional Notes/Prompt column keeps a note for yourself on the post.

   Don't leave the caption blank. Wallflower doesn't write captions for imported rows, and a row without one won't import.

   

4. Upload and check the preview #

   Drop the filled-in file on the dialog or click Choose file. It can be an .xlsx or .csv, up to 5 MB and 500 rows. Before anything is created, you'll see a preview. Rows that need a date, time or column fixed are flagged. Match any columns Wallflower didn't recognise, set the Date format if needed, and skip rows you don't want.

   A row with a blank caption is marked Needs attention. Type a caption in Fix caption, or skip the row.

   i

   NoteIf the whole file can't be read, you'll see "File could not be imported." Fix the file and click Upload a different file.

   

5. Import #

   When the preview looks right, click Import (it shows the number of rows, like "Import 12 rows"). Each accepted row is saved as a draft on its date.

   You'll find them on your Calendar, and in the Content Library under the Draft filter. Drafts don't show in Approvals. Click one on the Calendar to open it, check it, and schedule it.