Didn't Apple buy a company from canada who specialise in producing importers, such as for Office.
Numbers seems a bit of a strange name. Going with the kynote or pages name, you'd expect something like ledger, sheets or even cells. A spread sheet app is certainly needed though, and basing it on improv would seem a good idea with it having big links to OpenStep and Steve Jobs. I rarely use spreetsheets however, prefering databases (i don't really have much use for charts). It would be nice to see a app that combines a spreadsheet with the power of a database, instead of a traditional excel type app.
Otherwise i'd like to see a database app for home use, with a few high quality Apple designed templates. For instance you could have things like recipe, cd, video collections, simple employee lists (for small businesses and for those that run clubs or the like). They could interact with existing apps such as iTunes for cataloguing your record collection, and address book for the person/employee list. It would probably be just a front end to SQLite and Core Data to make them easy to use and expose them for none developers. It could produce nice looking front-ends, like pages does for documents, or produce web page/db integration if you subscribe to .mac. I think it would be better basing it on Core Data over a diluted filemaker because the functionality is already in Tiger, which would make it lighter weight, and SQL is a common standard, which would make it easier to import/export data and use skills already picked up by users that use other databases (even Access uses SQL, if in a extended none standard way). I dunno what they would call it..tables or data maybe.
Other than that, iWork needs something like a drawing package to replace the likes of Appleworks. I'm not sure if a drawing/paint package should be in iWork or iLife, as it is kinda a cross over product, done for either fun or to add to your work such as to illustrate your presentations or reports. I guess adding it to iwork makes sense to attract more people to buy it. iPhoto can do photo editing, so i think it sohuld be more based on drawing than photo manipulation, so more an illustrator light than a photoshop light. Using W3C's SVG format would probably be best for this kind of application, giving the format a shot in the arm i the process (and also allowing the images to be added to the likes of Quicktime, flash and even browsers in the future -- i don't think gecko has support yet, but neither does webkit). Allowing animation in a easy to use basic manor would also be interesting (i think svg supports this?) It could possibly use Core Image, and also integrate with iwork apps, iPhoto and .mac. It would also have to be able to import and export illustrator files. It could possibly be called paint, draw, canvas (if using the pages naming scheme), painting/drawing (if using keynote naming) or strokes (using numbers naming)
The only other app i can think of would be a person finance app, but features for the home user could be added to a spreadsheet or database template.
