Here at Swivel, we're big users of Microsoft Excel. Excel is the world's most popular spreadsheet software; it is also the de facto standard application for desktop data manipulation. Many Swivel data sets originated in Excel spreadsheets, and Excel is a great tool for editing and cleaning up data.
Today we are launching the Swivel Toolbar for Excel, an "add-in" that enhances Excel to make it an even better tool for getting data into Swivel. The toolbar includes formatting buttons that help deal with some of the more devilish issues in getting spreadsheet data formatted cleanly. And (of course!) it includes a button for one-touch upload of spreadsheet selections to Swivel.
To get the toolbar, visit the Swivel Confectionary. And go ahead and watch the screencast video for a quickstart.
Swivel Home
Is incremental uploads possible? Or is it only overwrites?
Posted by: Joseph KIm | September 01, 2007 at 11:29 PM
The current toolbar only supports one-touch upload as a new dataset. To update a data set with new data (i.e. an "incremental upload"), use the "Save as CSV" button to save your final, transformed worksheet to a CSV file. Then use the website (via the "Update Data" link on a http://www.swivel.com/xxxxxx page) to update the data set with additional data from that CSV file.
Joe
Posted by: Joe Hellerstein | September 02, 2007 at 10:48 PM
Hi,
I am using Excel 2003 SP2 German Version. When using "copy selected cells to scratch workbook" a get the error '438': Object does not support property or method (free translation from german) and the debugger stops in Sub SB_CopyValsToNewWkbk() in line
ActiveSheet.Range("A1").Paste
Any ideas? The rest is working very fine. Thx!
Posted by: Heiko | September 13, 2007 at 02:23 AM
Heiko, sorry to hear about the trouble. Please contact feedback@swivel.com so we can try and work with you to deal with the issue you're seeing.
As it happens, we recently ironed out a different internationalization bug in the toolbar that was affecting the Upload to Swivel and Save as CSV buttons. The current version of the toolbar on the website (v1.0.2) fixes these. You can find out the version of toolbar you're using the Control Panel for "Add or Remove Programs...", click on "Swivel Toolbar for Excel", and then press the "Change" button.
Posted by: Joe | September 17, 2007 at 11:57 PM