Designing for Data: How to Handle 100+ Columns

Submit your own design → forms.gle/GUHi...
Follow me on Twitter → / mds

[@joe3055]

From the condensed list item the user could then tap it to view a detail page which would show all of the data. That could be a new page or a side drawer.

[@user-id4yo5gb8k]

Invert the table: put the cars in the columns. That way you compare cars easily and it's OK to have lots of fields for each car. Users just need to filter down the number of cars instead of the fields.

[@aouri100]

You can also add an option for customizing the table, so the user can select which columns they want to display. Some references for that are webflow’s CMS itens table page and also airbnb’s host room announces table. In addition you can make the table as a summary and the complete info been show in a modal, side panel or new pagev

[@CalebSylvest]

Three ways to solve this problem: 1. Limit the number of columns on the table to the most important 2. Allow users to customize columns based on their use case 3. Provide a new detail view for each item that provides all 100+ pieces of information (not in a table)

[@islamocean1]

What a knowledge man, thanks, that's great video lesson

[@joshuacrane]

Since there likely are very different personas, I’d also give the user the ability to choose which columns they want to see. I’d also explore removing the color bubbles from the car color. I think they’re competing too much with the actual status tags and could be a bit confusing. If you still want to show color, maybe put it in a square swatch next to the color name. That way you still get the show the color but it doesn’t get confused with the status tags.

[@chiandet]

Great suggestion for the color column. To add to that, most car manufactures won't just be yellow, red, etc. You could have "alpine white" and "mineral white" for the same model car which is kind of a big deal. It just seems problematic from a dev perspective and probably not as useful for a buyer or seller as the specific color codes can drive the value of a vehicle.

[@MinimaLune]

I'd also ask the user what type of information they're looking for on that screen. Also, maybe a top grid-view showing certain car models would make the dashboard a bit more useful.