McGrory, John2015-04-282015-04-282015https://hdl.handle.net/11299/171966Presented at the 2015 Research Data Access and Preservation Summit held April 23, 2015 in Minneapolis, MN.This poster presents the Excel Archival Tool, a script that was created to programmatically convert Microsoft Excel files into open source formats suitable for long-term archival. This is accomplished by using Visual Basic Script to convert Excel workbooks (.xls and .xlsx) into comma-separated value files (.csv), while also extracting charts/figures (in .png images), cell formulas (in .txt files), and formatting/styling information (in HTML snapshots). This tool is most useful for large Excel data sets that would otherwise require large amounts of tedious work to convert manually.enExcelExcel Archival ToolSpreadsheetVisual BasicHTML for ApplicationsPresentation