Help! Cannot upload Excel data to Timetable column

Platform discussions
, ,
1

Hello.

I’m trying to import date and time data (2 Excel columns) into a single Timeline column. According to this Feature request, this is now possible since May 2025.

However, when I import the Excel file, the options to map the start and end date are not showing up on the column assosiation prompt. Do I have to modify a setting somewhere? Here’s a screenshot (in Spanish) but I expalin further right below.

image

image519×472 34.2 KB

The highlighted columns are the start and end date, but the dropdown menu won’t show the Timeline column.

In Excel, both columns have date format. I’ve tried several changes with no success.

Am I missing a setting?

Please help.

1 Like
2

Hi @mdelrio, Welcome to the community!!

Even if Excel shows the columns as “Date” format, monday may not recognize them properly if:

  • They include time values (e.g., 01/06/2025 08:00)

  • There’s a locale mismatch (DD/MM/YYYY vs MM/DD/YYYY)

  • The cells contain formulas instead of plain values

What I’d recommend:

  • Format both columns as Short Date

  • Remove any time component

  • Copy → Paste as Values only

That usually resolves the mapping issue during import.

1 Like
3

Hi @mdelrio,

If the formatting suggestions above don’t resolve it, I’ve been building a dedicated Excel/Sheets importer that gives more control over column mapping — including combining separate start/end date columns into a Timeline column.

If you’d like, feel free to share a small sample file (you can anonymize it), and I’m happy to test whether it imports correctly.

— Janré

4

Hello @mdelrio
You’re not missing anything. Timeline columns don’t appear in the Excel column mapping because imports only support basic column types like Date, Text, Status, etc.

What to do instead
Import your two Excel columns as separate Date columns first
Then add a Timeline column and populate it afterward

If you’d like hands-on help or want us to walk through this live, you can book a 1:1 paid 60-minute strategy session with our team here:
:backhand_index_pointing_right: Calendly

5

Hello!

Accordint to this thread Excel Upload for Timeline - Feature requests - monday Community Forum mapping date colums into timeline columns is now possible. There is something else I’m missing.

Monday team member statement:

image
image880×400 44.5 KB

A user’s testimony:

image
image904×567 41.3 KB

6

Hello, Yogesh!

THANK YOU! I knew I was missing something.

It worked.

Hugs.

Misael

1 Like