Monday.com board to dashboard
One Monday.com board, one dashboard.
Export a board from Monday.com and drop the CSV here. The export covers one board rather than the whole workspace, so the dashboard is scoped accordingly. Status labels lose their colors and arrive as plain text, which is fine once you stop expecting order from them. Timeline columns come through as separate start and end dates, and a blank status is treated as genuinely blank.
Prefer the full explorer? Open the app, or start from the generic dashboard builder.
A board is not a workspace, and a color is not a value
The first thing to get straight about a Monday.com export is its scope. You export one board. A workspace with a board per client or per quarter gives you a folder of files, none of which knows about the others, and none of which carries a column naming its own board. Add that column yourself before merging or the combined file will be an anonymous pile of items. It is a small step that turns a set of exports into something a portfolio view can actually use.
The second is that the interface communicates through color and the CSV cannot. A status of Stuck is red on screen and the eye reads urgency instantly. In the file it is the word Stuck, alphabetically between Done and Working on it, with no inherent ordering and no severity. Any chart you build has to define that order itself. This page treats status as a categorical dimension you can reorder rather than pretending a default alphabetical sort means something.
How to export from Monday.com
- Open the board you want Sign in and navigate to the specific board. There is no workspace-wide export, so if the data you need spans several boards you will be doing this once per board.
- Expand any subitems you need Subitems are a separate layer and are not included by default. Expand the groups that contain them, or export the subitem board separately, because otherwise the parent items carry rollups with nothing behind them.
- Use the board menu to export The three dot menu at the top right of the board has Export board to Excel. Save or convert the result to CSV. The export follows the board, including its groups, rather than any dashboard widget on top of it.
- Check the person and status columns Person columns export as display names, and a multi-person cell joins them. Status columns export as their label text with no color and no position index.
- Drop the file here Group becomes the first breakdown, Status becomes a reorderable dimension, and Budget and Effort become the two metrics behind every panel.
Formula columns export as their calculated result, and mirror columns pulling from a connected board export the mirrored text rather than a link. Both make the file a snapshot of the moment you exported it.
Try with sample Monday.com data (the same columns, 86 rows, no upload needed).
What the dashboard shows
Every panel below is built from a column that is actually in the export, named the way Monday.com names it.
- Items by status. Counted and valued, with the order under your control rather than alphabetical, which is what makes a status chart readable.
- Group breakdown. Monday groups are usually sprints, quarters or clients, so the Group column is often the most meaningful dimension in the file.
- Budget against effort. Two numeric columns plotted together, which is where the items that cost a lot and deliver little become obvious.
- Timeline durations. Timeline Start to Timeline End as a span per item, so overruns show as length rather than as a date you have to reason about.
- Person workload. Items and budget per assignee, with unassigned items kept visible instead of quietly dropped.
- Recent activity. Last updated as a recency view, which is the fastest way to find the items nobody has touched in a month.
Item ID,Name,Group,Person,Status,Priority,Date,Timeline Start,Timeline End,Budget,Effort (hrs),Last updatedMonday.com export behavior
- You export a board, not a workspace. Nothing in the file names the board it came from. Merge several without adding that column and the combined file loses the only context that mattered.
- Subitems are excluded by default. They live in their own hidden board. Parent items can show rolled up numbers that have no supporting rows anywhere in the export you just took.
- Status colors do not survive. Only the label text does. There is no severity, no ordering and no index, so any chart needs an order you define yourself.
- Blank status is legitimate. An item with no status set exports an empty cell. That is a real state in Monday, not missing data, and folding it into Done or Stuck is wrong.
- Timeline is two columns. Start and end arrive separately, so a duration needs subtracting, and an item with only one of the two set is a half-configured timeline rather than an error.
- Person columns hold display names. Multiple assignees join into one cell, and two people with the same name are indistinguishable. There is no user id to join on.
Label the board, decide the status order before you chart it, and be honest about whether the subitems are in the file. Do that and a Monday board becomes a perfectly good operational dashboard.
Frequently asked questions
Can I export my whole Monday.com workspace at once?
Not from the board menu. Export runs per board, so a workspace organized as a board per client or per quarter produces one file each. Merge them afterwards, but add a column naming the board before you do, because nothing in the export identifies its origin and a combined file without it is a list of items belonging to nobody in particular.
Where did my subitems go?
Subitems live on their own linked board and are not included in a parent board export unless you expand them first. This bites hardest when parent items carry rollup columns summing subitem values, because the totals appear in the file with no rows behind them. Either expand before exporting, or export the subitem board separately and treat it as a second file.
Why do my status values have no order?
Because the export writes the label text and nothing else. In the interface a status carries a color and a position that convey urgency and progress at a glance, and neither is representable in CSV. Sorted alphabetically, Done comes before Working on it, which reverses the actual workflow. Set the order explicitly on the chart, which this page lets you do.
What does an empty Status cell mean?
That no status has been set on the item, which is a real and common state in Monday rather than a data quality problem. New items often sit there for a while. Counting blanks as a category of their own is usually the right call, since a growing pile of unset items is itself a signal about how the board is being maintained.
How do I calculate how long an item took?
Subtract Timeline Start from Timeline End. Monday splits the timeline column into two fields on export, so there is no range string to parse, which is the pleasant version of this problem. Watch for items with only one of the two dates set, since those are partially configured rather than instantaneous, and a naive subtraction turns them into zero-day items.
Is my board data uploaded to a server?
No. The file is read in your browser and the charts are drawn from memory. A Monday board export can include budgets, assignees and client names, and there is no reason a charting tool needs a copy of that on someone else's machine. This page has no backend, requires no account, and forgets everything when the tab closes.
Related tools
See a Monday.com board as a dashboard
86 items across four groups with plain text statuses, some deliberately blank, split timeline columns and a budget and effort pair to plot against each other.
Open the sample Monday.com dashboard