Where to find the template csv file to import events

Ask the Community General Questions
1

Hey Max - I’m about to do my first CSV upload into a event calendar widget - I can’t find anywhere the template I should follow to create a CSV that will upload neatly. I need the calender users to be able to filter by tags/event types.

If there a template to make sure the CSV fits with the widget? Thanks!

1 Like
Sync events to Google sheet
2

Hi Vanessa

What I did was manually make 2 sample events and then download the csv. This showed me what it needed for the upload.

Chris

3 Likes
4

Hey there, friends :waving_hand:

@Chris_Rhodes, your workaround is great, thanks a lot for helping Vanessa!

I just wanted to let you know that the Template file can be downloaded right in the editor :wink:

image
image508×497 13.5 KB
image
image315×760 13.3 KB

5

Thanks for this - what format should the start date and time and end date and time be added to the cell in whatever spreadsheet tool we are using, before exporting to csv, thanks

1 Like
6

Hi @Vanessa_Lovatt :waving_hand:

Here is a correct date and time format for your files:

image
image519×304 6.88 KB

Note: No need to specify the seconds in the time, hours and minutes would be enough :slightly_smiling_face:

7

Thanks - this is proving tricky - it’s working in some lines when I format like that but not all

Please confirm:

Month/date/year hours:mins:seconds AM/PM

Am I missing anything?

8

would you recommend excel or googlesheets? any nuances between the two? I’m going in circles!

9

the example you have screen shot isn’t clear if it’s day of the month or the month first (in europe we put day of the month first) and 12:00 doesn’t make it clear if we should or shouldn’t use 24 hour clock?

image

the top line works, but the lower line doesn’t - even though I type it into the cell in exactly the same way, google sheets insists on correcting some cells and not others. Same in excel.

10

Can you confirm:

  • Is this MM/DD/YYYY (US format), not UK DD/MM/YYYY?

  • Does Elfsight require the AM / PM marker (not 24-hour time)?

  • Does Elfsight expect these values to be:

    • true date-time values, or

    • plain text strings that just look like dates?

11

Just can’t work out what’s invalid about these?

image

12

image
image186×289 1.11 KB

image
image311×480 6.94 KB

I’m sure I’m being daft, but any guidance on what’s wrong with the format would be really appreciated. Thank you.

1 Like
13

Hi there, @Vanessa_Lovatt :waving_hand:

Please let me consult with the devs. I’ll get back to you as soon as I have more news :slightly_smiling_face:

14

Hi @Vanessa_Lovatt :waving_hand:

There are 4 possible formats:

  • DD/MM/YY HH:MM or DD.MM.YY HH:MM (both without a.m/p.m for the time). Time without a.m/p.m must include a leading zero. For example - 02:00.

  • MM.DD.YY HH:MM AM/PM or MM/DD/YY HH:MM AM/PM. The time in these formats must be used without leading zeros - 2:00 AM.

Let me know if this explains things or if you have any questions left :wink: