« DCNUG Meeting This Thursday - The REAL Show-n-Tell | Main| New Blog on Migrating Notes to Sharepoint »

Free Tools for Importing Excel Data Into Notes


Excel to NotesI've been meaning to blog about the incredibly powerful if boringly named "Import" database/tool from the folks at AGE Computer Consultancy in Australia for, well, ages (sorry, couldn't help myself).  There is also a simpler "wizard" tool which was featured in Thierry Seunevel's March/April 2007 VIEW article Automatically import/export spreadsheet and other data with Notes wizards .  In fairness, I did mention these tools in my OpenNTF Blast presentation from ILUG earlier this year.  What finally caused me to break down and write this blog entry was this post from Giulio Campobassi lamenting the inability to save a Lotus Symphony spreadsheet in 1-2-3 format.  He goes on to complain:

...I will usually want to do it so I can simplify the import and export operations I come across. Especially in cases when configuring up client systems using an initial import of data from the excel spreadsheet the client has been using for the last 5 years.

Every time I read something like this I just want to yell "STOP, you don't have to suffer!" Now that I know you're reading this, I will no longer feel the need to yell, so thank you for reading.  You may take the cotton out of your ears.

By using either or both of these tools, you can completely avoid the need to use the native 1-2-3 import to Notes functions.  You also get several other capabilities, and both tools allow you to save and reuse import settings.

With the AGE Import tool you can:
  • Import spreadsheet data to update *existing* Notes documents
  • Use in lieu of LEI or Notrix when those tools are overkill but you don’t want to write a custom import agent
  • Define key matching, update behavior, field mapping, data transformations, et. al.
  • Schedule recurring import jobs to run automatically

With Thierry's import wizard you can:
  • Quickly import basic spreadsheet data into Notes
  • Map spreadsheet columns to form fields or view columns
  • Save import "profiles" for later reuse

And did I mention that both of these tools are completely free?


1 - I have used AGE Import for quite some time ago and love it. Definitely a great free tool

2 - thxz

3 - AGE Import tool is not free! Emoticon

4 - sir i want use Agent to import data from a view on the Web Application in a lotus Notes through browsing

5 - Emoticon Emoticon Emoticon Emoticon Emoticon Emoticon Emoticon

6 - It is not free anymore.
Have a look at the below.
{ Link }


7 - Message from AGECOM....
Due to the huge popularity of our Import Utility for Lotus Notes / Domino we are now investing more time in supporting and performing ongoing maintenance of the product. Hence we now charge a license fee for the product. We have, however, kept the price to a minimum - $79 (Australian).

For more details and to download the import utility click the following link:
{ Link }

8 - Anyone got a link to Thierry's Import Wizard?
Wouldn't like to subscribe to "The View" for that only.Emoticon

9 - There's a movement to radically change California government, by getting rid of career politicians and chopping their salaries in half. A group known as Citizens for California Reform wants to make the California legislature a part time time job, just like it was until 1966.


10 - By that I mean latching on to this or that latest, most innovative idea that some self styled money making guru has put out in the hope it’ll go viral and make them a lot of money off the backs of all the headless chickens who will follow them blindly down a blind alley. Its a shame but a truism nonetheless that people will follow where someone they see as an expert leads. Even if they lead them to certain disaster, which is what most of the gurus tend to do to their flocks.

11 - thank for this { Link }
{ Link }

12 - I found a direkt link to the database Emoticon
{ Link }

13 - Thanks for sharing us..

240 - We are Frontline Relocation Packers and Movers Vadodara is Trusted and Most reliable movers and packers service provider in Vadoadara-Gujarat.offers Household shifting, Warehouse and Insurance service, Car and Bike Moving Services. Call NOW @7359123442

241 - There are numerous Packers and Movers in Kolkata who provide relocation services, shifting of residential and commercial goods, office shifting at an affordable rate. Here is a list of reputed and reliable packers and movers in Kolkata.
**honest packers and movers Kolkata** is Trusted and Most reliable movers packers service provider in Kolkata. **Call NOW - 9674943995 **
**Honest ****Packers and Movers Kolkata ** ({ Link } has over 25+ years of experience packing and moving people in Kolkata and its all local areas. Our packers and movers kolkata team are fully qualified and punctual, and with our wide range of additional services, they can undertake any job.making us the top packers and movers in Kolkata.

We Have Branch Office's All Over India
Household Moving
Corporate Office Moving
On-Time Delivery Anywhere in India
Use Good Quality Packing Material
24x7 Great Customer Support

249 - ackers and Movers in Kolkata who provide relocation services

Post A Comment


Tools I Use

Idea Jam

Subscribe to This Blog

 Full Posts  Comments

netvibes Add to Netvibes


Hosted by



This site is in no way affiliated, endorsed, sanctioned, supported, nor blessed by Lotus Software nor IBM Corporation, nor any of my past or future clients (although they are welcome to do so). The opinions, theories, facts, etc. presented here are my own and in no way represent any official pronouncement by me on behalf of any other entity.

© 2005-2021 Kevin Pettitt - all rights reserved as listed below.

Creative Commons License
Unless otherwise labeled by its originating author, the content found on this site is made available under the terms of an Attribution / NonCommercial / ShareAlike