Skip to main content
hamburger menu
+ Create a topic
Solved

Create a timeline from Excel data including milestone title, end date, and status

  • March 2, 2026
  • 2 replies
  • 15 views
I
Forum|alt.badge.img

Hello, I have an Excel file containing the following columns:

  • Milestone Title

  • End Date

  • Status (e.g., On Track / Delayed / Complete)

I would like to know if there is a way in Lucidchart to automatically generate a timeline visual using this data.

Specifically:

  • Can I import the Excel file and map the “Milestone Title” and “End Date” columns to create a timeline?

  • Is it possible to use the “Status” column to automatically apply conditional formatting (e.g., color-coding) on the timeline?

  • Does this require Data Linking, Smart Containers, or a specific timeline template?

  • If supported, can the timeline stay dynamically linked to the Excel file for future updates?

Could you please advise on whether this can be achieved without manually recreating the timeline?

I am unable to add the Excel extension. 

Is there someone who has been through this and would be able to help me out? 

Best answer by alison cheney

Hi ​@Int-pmo,

Thanks for posting in the Lucid Community, and thank you ​@Humas1985 for providing such valuable insight.

Humas is absolutely right that Lucidchart can link to your data and use conditional formatting to handle your color-coding automatically.

 

To build on that and save you even more manual effort, I wanted to highlight a specific feature that addresses your goal of automatically generating the visual without having to manually attach every single row to a shape.

You can actually automate the creation of your milestones using Smart Containers. Since you can’t use the Excel extension, your best bet is to import your data via Google Sheets. Once you import your data, follow the steps below:

  • Access the Library: Click the Containers icon on the left toolbar and ensure "Smart containers" is enabled.
  • Import with a Dataset: Instead of dragging shapes first, click Import Data at the bottom of the Smart Containers library.
  • Map Your Columns: When prompted, set "Containers" to your Status column and "Shape title" to your Milestone Title.
  • Instant Generation: Lucid will automatically generate the containers and create a "tile" for every row in your spreadsheet. No manual drawing required!

As Humas pointed out, Conditional Formatting is your best friend here!

  • You can create a rule: IF Status is "Delayed", THEN Fill Color is Red.
  • Because this is synced to your Google Sheet, the moment you change a status in the spreadsheet, the tile in Lucidchart will automatically change color and even move to the correct "Status" container automatically.

Please let me know if you have any additional questions!

Comments

Humas1985
Lucid Legend Level 10
Forum|alt.badge.img+24
  • Humas1985Lucid Legend Level 10
  • Lucid Legend Level 10
  • March 2, 2026

Hi ​@Int-pmo 

Lucidchart can link to your Excel (or better, a Google Sheet) and use your Milestone Title, End Date, and Status columns as a data source.

  • It cannot fully auto-generate a timeline layout from that data, you still have to create the timeline axis and milestone shapes once and then bind each shape to a row.
  • After linking, you can set conditional formatting so Status drives color‑coding (e.g., On Track = green, Delayed = red).

If you store the data in Google Sheets, the diagram can update dynamically when the sheet changes; a static Excel upload would need re‑imports.

So you avoid retyping and future recreation, but the initial layout still requires some manual work.

To learn more - Import excel data into a product roadmap or timeline in Lucidchart | Community

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

Huma || Lucid Legend
    alison cheney
    Forum|alt.badge.img+4
    • alison cheney
    • Lucid community team
    • Answer
    • March 3, 2026

    Hi ​@Int-pmo,

    Thanks for posting in the Lucid Community, and thank you ​@Humas1985 for providing such valuable insight.

    Humas is absolutely right that Lucidchart can link to your data and use conditional formatting to handle your color-coding automatically.

     

    To build on that and save you even more manual effort, I wanted to highlight a specific feature that addresses your goal of automatically generating the visual without having to manually attach every single row to a shape.

    You can actually automate the creation of your milestones using Smart Containers. Since you can’t use the Excel extension, your best bet is to import your data via Google Sheets. Once you import your data, follow the steps below:

    • Access the Library: Click the Containers icon on the left toolbar and ensure "Smart containers" is enabled.
    • Import with a Dataset: Instead of dragging shapes first, click Import Data at the bottom of the Smart Containers library.
    • Map Your Columns: When prompted, set "Containers" to your Status column and "Shape title" to your Milestone Title.
    • Instant Generation: Lucid will automatically generate the containers and create a "tile" for every row in your spreadsheet. No manual drawing required!

    As Humas pointed out, Conditional Formatting is your best friend here!

    • You can create a rule: IF Status is "Delayed", THEN Fill Color is Red.
    • Because this is synced to your Google Sheet, the moment you change a status in the spreadsheet, the tile in Lucidchart will automatically change color and even move to the correct "Status" container automatically.

    Please let me know if you have any additional questions!

    Level up your skills & unlock exclusive perks!

    Join Lucid Legends
    Lucid Software Inc. Supplemental Community TermsAccessibility statement

    Get Started

    Products

    Solutions

    Company

    Resources

    Privacy Legal Cookie privacy choices Cookie policy Your privacy choices
    © 2026  Lucid Software Inc.