While Wufoo does a great job helping people collect new information over the Internet, it can be a bit tricky to get existing data into our application. Aside from physically entering the data by hand into your forms, the only other alternative is to dive into our Submit API and write some code to programmatically enter it into Wufoo.
Well, Tim Morgan, web developer and creator of OneBody, decided he had had enough after his wife asked him to write yet another one-off script to import data into Wufoo. Using James Edward Gray’s FasterCSV, Sinatra, and his own WufooParty library, he created CSV2Wufoo.com, a web service that can take your CSV (comma separated value) files and import them into your Wufoo forms.
Now, you can take all that data locked inside your spreadsheets and databases and get them into Wufoo quickly and painlessly. The service does a great job walking you through the process step by step and you can even assign columns in your CSV file to specific fields in your forms so your data goes in right where you want it.
Before you dive in, here’s some things to keep in mind about using CSV2Wufoo:
The service requires your account name and API key to do the import. Once the import is complete, the API key is deleted immediately by CSV2Wufoo (even if the service encounters an error).
Imported data that is over 3 days old is automatically deleted from the server. The reason CSV2Wufoo keeps around imported data temporarily on their servers is to help debug errors and improve the application.
Currently, the service is limited to 5,000 request to the Wufoo API per day, which maps roughly to the number of records being imported. So please don’t test with a large file, so there’ll be some left for others to use.
Please note that imported entries are counted the same as new submissions through your forms and will count against your monthly entry limit.
Best of all, Tim is able to make CSV2Wufoo FREE thanks to the sponsoring support of OneBody, an online directory and social network for churches. Definitely check them out. OneBody is a really intuitive tool for people and groups to manage the basic functions of a church community. Thanks again Tim and OneBody! We love the new service.