Drupal - How can I create a bulk node creation interface?
The Multi Node Add module might provide what you need.
This is great... there is a D6 & D7 version http://drupal.org/project/slickgrid
Edit: I highly recommend trying this its the most awesome thing!! You even get your field widgets in popups when clicking on the cells.
A couple quick tips (D7) Be sure to also install http://drupal.org/project/title so you can reset the title (make it a field), Basically with this editor you can only edit actual fields, so same goes for location module, you'll need to use the field option rather than node option.