Poster for "Excel Archival Tool: Automating the Spreadsheet Conversion Process"
2015
Loading...
View/Download File
Persistent link to this item
Statistics
View StatisticsJournal Title
Journal ISSN
Volume Title
Title
Poster for "Excel Archival Tool: Automating the Spreadsheet Conversion Process"
Authors
Published Date
2015
Publisher
Type
Presentation
Abstract
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.
Description
Presented at the 2015 Research Data Access and Preservation Summit held April 23, 2015 in Minneapolis, MN.
Replaces
License
Series/Report Number
Funding information
Isbn identifier
Doi identifier
Previously Published Citation
Other identifiers
Suggested citation
McGrory, John. (2015). Poster for "Excel Archival Tool: Automating the Spreadsheet Conversion Process". Retrieved from the University Digital Conservancy, https://hdl.handle.net/11299/171966.
Content distributed via the University Digital Conservancy may be subject to additional license and use restrictions applied by the depositor. By using these files, users agree to the Terms of Use. Materials in the UDC may contain content that is disturbing and/or harmful. For more information, please see our statement on harmful content in digital repositories.