MS Lists vs Airtable

%3CLINGO-SUB%20id%3D%22lingo-sub-1672315%22%20slang%3D%22en-US%22%3EMS%20Lists%20vs%20Airtable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672315%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20not%20find%20any%20discussion%20on%20Lists%20missing%20features%20or%20feature%20requests%20so%20far%2C%20so%20I%20thought%20I'd%20create%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20an%20avid%20Airtable%20Pro%20user%20and%20privately%20I%20use%20it%20for%20everything%20from%20my%20ToDos%2C%20to%20my%20personal%20finances%20and%20real%20estate%20management.%20So%20naturally%20I%20have%20been%20missing%20this%20functionality%20in%20our%20Microsoft%20dominated%20company.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20playing%20with%20MS%20Lists%20for%20a%20while%2C%20I%20can%20say%20I'm%20at%20the%20same%20time%20impressed%20and%20dissapointed.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20tool%20could%20really%20be%20Microsoft's%20answer%20to%20Airtable%20and%20with%20a%20good%20cross%20tool%20integration%20it%20could%20even%20make%20me%20drop%20Airtable%20all%20together%2C%20but%20to%20do%20so%2C%20there%20is%20a%20lot%20of%20features%20still%20needed.%20Here%20are%20a%20few%20for%20starters%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Group%20by%20%22Title%22%20and%20make%20title%20a%20field%20that%20can%20have%20all%20field%20types.%3C%2FP%3E%3CP%3E2.%20Multi-Group%3A%20Sometimes%20I%20want%20to%20group%20something%20by%20multiple%20columns%2C%20e.g.%20group%20a%20customer%20contact%20list%20first%20by%20company%20and%20then%20by%20city.%3C%2FP%3E%3CP%3E3.%20Two%20way%20Excel%20integration.%20I%20use%20a%20lot%20of%20reports%20where%20online%20data%20is%20loaded%20into%20Excel%2C%20so%20a%20connected%20list%20that%20automatically%20updates%20with%20Excel%20would%20be%20great%20(I%20know%20it's%20there%20from%20Lists%20to%20Excel%2C%20but%20the%20other%20way%20round%20is%20more%20important%20IMO)%3C%2FP%3E%3CP%3E4.%20Create%20options%20on%20the%20fly.%20If%20I%20have%20a%20selection%20field%20I%20wanna%20have%20the%20option%20to%20type%20in%20the%20field%20and%20just%20add%20that%20as%20a%20new%20option.%3C%2FP%3E%3CP%3E5.%20Great%20in%20line%20editing.%20Please%20MS%20try%20to%20import%20some%20of%20the%20same%20lists%20in%20Airtable%20and%20edit%20them%20there%20vs.%20in%20Lists%20and%20you'll%20know%20what%20I%20mean.%3CBR%20%2F%3E6.%20Cross%20List%20linking.%20Seeing%20lists%20as%20databases%20is%20the%20great%20UVP%20of%20Airtable%20that%20currently%20no%20other%20software%20has.%20Lists%20is%20basically%20the%20same%20thing%2C%20but%20it%20does%20not%20yet%20make%20use%20of%20this%20thoughts.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2C%3C%2FP%3E%3CP%3EMichael%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1672315%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

 

I could not find any discussion on Lists missing features or feature requests so far, so I thought I'd create one.

 

I am an avid Airtable Pro user and privately I use it for everything from my ToDos, to my personal finances and real estate management. So naturally I have been missing this functionality in our Microsoft dominated company.

 

After playing with MS Lists for a while, I can say I'm at the same time impressed and dissapointed.

This tool could really be Microsoft's answer to Airtable and with a good cross tool integration it could even make me drop Airtable all together, but to do so, there is a lot of features still needed. Here are a few for starters:

 

1. Group by "Title" and make title a field that can have all field types.

2. Multi-Group: Sometimes I want to group something by multiple columns, e.g. group a customer contact list first by company and then by city.

3. Two way Excel integration. I use a lot of reports where online data is loaded into Excel, so a connected list that automatically updates with Excel would be great (I know it's there from Lists to Excel, but the other way round is more important IMO)

4. Create options on the fly. If I have a selection field I wanna have the option to type in the field and just add that as a new option.

5. Great in line editing. Please MS try to import some of the same lists in Airtable and edit them there vs. in Lists and you'll know what I mean.
6. Cross List linking. Seeing lists as databases is the great UVP of Airtable that currently no other software has. Lists is basically the same thing, but it does not yet make use of this thoughts.


Kind regards,

Michael

6 Replies

@michaelafischer Does List don't have filter and group by list name option?

and what about attachment. Can we attach docs to a record?

(Asking you as I'm also coming from Airtable.)

I does, but way less advanced. You can only group by one item for example and you can’t group by the first column
thanks for replying.
I can’t believe how lacking Lists is. I have entered some company data. It feels like it is now stuck in there.

No option to export as a pdf
Very limited reporting
Buggy (the option to display say 10 entries at a time does not work and has been a know issue for 3+ years)

It’s awful. Wish I could use airtable. So much better.
I'm an avid Airtable user as well. It's just tremendously more powerful than Lists. I'm wondering if MS made a mistake in basing Lists on SharePoint as SharePoint is pretty old and so there is probably a lot of technical debt.

I would actually love to switch to Lists, as my company otherwise uses MS 365 but I currently have a project management system built in Airtable and there's no way I can replicate it in Lists.

I'd like to add a few features that Lists could use:

- Better forms. Airtable currently has the ability to share a form that will populate a table based on set parameters. I can't seem to share Lists forms externally, and MS Forms doesn't populate list choice fields very well.
- The ability to use a calculated field as a Lookup. This is major for me, as having a consistent naming convention for deliverables and tasks is key to our workflow.
- I would love if Lookups worked two-way rather than just one-way as well.
Airtable is quite simply better. I hope MS takes a long hard look at improving MS lists ASAP. One example I can think of is date/ time difference calculations:
1. Much easier to do / input in AirTable
2. No need to create a flow to add a “helper” column to can accurate reference to “today’s date” consistently.
3. Much faster. Input is clean and fast on AirTable vs inputting items in MS lists which seems to just be laggy in many situations.

4. More export options in AirTable vs MS lists.

5. Overall good idea with a lack of execution from MS on the lists app.