Between Dec 19, 2024 and Jan 2, 2025, datasets can be submitted to DRUM but will not be processed until after the break. Staff will not be available to answer email during this period, and will not be able to provide DOIs until after Jan 2. If you are in need of a DOI during this period, consider Dryad or OpenICPSR. Submission responses to the UDC may also be delayed during this time.
 

Poster for "Excel Archival Tool: Automating the Spreadsheet Conversion Process"

McGrory, John
2015
Thumbnail Image

View/Download File

PDF of Excel Archival Tool poster (2.18 MB)

Persistent link to this item

https://hdl.handle.net/11299/171966
Statistics
View Statistics

Journal 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.

Keywords

Description

Presented at the 2015 Research Data Access and Preservation Summit held April 23, 2015 in Minneapolis, MN.

Related to

Excel Archival Tool Software (Github download)
 http://z.umn.edu/exceltool

Replaces

License

Collections

Faculty and Staff Papers and Presentations, University Libraries

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.