Linked Open Data for Spreadsheet Formats

A spreadsheet is an electronic document in which data arranged in grid-like rows and columns can be manipulated and be acted upon by formulae. Spreadsheet software may allow for multiple interacting sheets, AKA a workbook, and can display data as text, numerals, symbols, or in graphical form. Spreadsheet files may consist of not only the data, but also contain charts or visualizations based on the data and formulae. Each cell may contain either raw data or the results of formulas that automatically calculate and display a value based on the contents of other cells from the same or other pages/sheets, as well as external data sources.

The significant properties of spreadsheets are documented in a Spreadsheets Preservation Plan, which can be used as test criteria for tools and processes used in format transformations.

NARA makes its Linked Open Data available in the Resource Description Framework Terse RDF Triple Language, or RDF Turtle (.ttl files). These files can be opened in any text editor. The Digital Preservation Framework as Linked Open Data includes the same elements as are available in the version of the Preservation Plans on GitHub.

These Plans are not exhaustive nor universally applicable proposed actions and recommended or endorsed tools: these represent file formats and variant versions in NARA holdings, the current NARA risk assessment, processing capabilities, and tools in use at NARA.


Format Name Digital Preservation Framework Category/Categories NARA Format ID NARA Linked Open Data TTL
Lotus 1-2-3 Graph Spreadsheets NF00722
Lotus 1-2-3 Worksheet 1.0 and 1A Spreadsheets NF00228
Lotus 1-2-3 Worksheet 2.0 Spreadsheets NF00229
Lotus 1-2-3 Worksheet 3.0 Spreadsheets NF00230
Lotus 1-2-3 Worksheet 4.0/5.0 Spreadsheets NF00231
Microsoft Excel 2.x Spreadsheets NF00259
Microsoft Excel 2000-2003 Spreadsheets NF00260
Microsoft Excel 3.0 Spreadsheets NF00261
Microsoft Excel 4.0 Spreadsheets NF00262
Microsoft Excel 97 Spreadsheets NF00263
Microsoft Excel Backup Spreadsheets NF00264
Microsoft Excel for Macintosh 2001 Spreadsheets NF00265
Microsoft Excel for Macintosh 2002 Spreadsheets NF00266
Microsoft Excel for Macintosh 2004 Spreadsheets NF00267
Microsoft Excel for Macintosh 3.0 Spreadsheets NF00268
Microsoft Excel for Macintosh 4.0 Spreadsheets NF00269
Microsoft Excel for Macintosh 98 Spreadsheets NF00270
Microsoft Excel for Macintosh v.X Spreadsheets NF00271
Microsoft Excel Macro-enabled Spreadsheets NF00665
Microsoft Excel Office Open XML Spreadsheets NF00272
Microsoft Excel Template Spreadsheets NF00770
Microsoft Excel unspecified version Spreadsheets NF00656
Microsoft Excel Workspace Spreadsheets NF00273
Microsoft Multiplan 4.0 Spreadsheets NF00278
OpenDocument Spreadsheet 1.0 Spreadsheets NF00349
OpenDocument Spreadsheet 1.1 Spreadsheets NF00513
OpenDocument Spreadsheet 1.2 Spreadsheets NF00514
OpenDocument Spreadsheet 1.3 Spreadsheets NF00800
Quattro Pro Spreadsheet 7-8 Spreadsheets NF00527
Quattro Pro Spreadsheet 9-12, X3, X4 Spreadsheets NF00528
Quattro Pro Spreadsheet for DOS 1-4 Spreadsheets NF00390
Quattro Pro Spreadsheet for DOS 5.x Spreadsheets NF00526
Quattro Pro Spreadsheet for Windows 1-5 Spreadsheets NF00391
Quattro Pro Spreadsheet for Windows 6 Spreadsheets NF00529
VisiCalc Databases|Spreadsheets NF00435