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 File Extension(s) Digital Preservation Framework Category/Categories NARA Format ID NARA Linked Open Data TTL
VisiCalc vc|vcs Databases|Spreadsheets NF00435
Lotus 1-2-3 Graph gph Spreadsheets NF00722
Lotus 1-2-3 Worksheet 1.0 and 1A wks|123 Spreadsheets NF00228
Lotus 1-2-3 Worksheet 2.0 wk1|wk2 Spreadsheets NF00229
Lotus 1-2-3 Worksheet 3.0 wk3 Spreadsheets NF00230
Lotus 1-2-3 Worksheet 4.0/5.0 wk4 Spreadsheets NF00231
Microsoft Excel 2.x xls Spreadsheets NF00259
Microsoft Excel 2000-2003 xls Spreadsheets NF00260
Microsoft Excel 3.0 xls Spreadsheets NF00261
Microsoft Excel 4.0 xls Spreadsheets NF00262
Microsoft Excel 97 xls Spreadsheets NF00263
Microsoft Excel Backup xlk Spreadsheets NF00264
Microsoft Excel for Macintosh 2001 xls Spreadsheets NF00265
Microsoft Excel for Macintosh 2002 xls Spreadsheets NF00266
Microsoft Excel for Macintosh 2004 xls Spreadsheets NF00267
Microsoft Excel for Macintosh 3.0 xls Spreadsheets NF00268
Microsoft Excel for Macintosh 4.0 xls Spreadsheets NF00269
Microsoft Excel for Macintosh 98 xls Spreadsheets NF00270
Microsoft Excel for Macintosh v.X xls Spreadsheets NF00271
Microsoft Excel Macro-enabled xlsm Spreadsheets NF00665
Microsoft Excel Office Open XML xlsx Spreadsheets NF00272
Microsoft Excel Template xlt Spreadsheets NF00770
Microsoft Excel unspecified version xls Spreadsheets NF00656
Microsoft Excel Workspace xlw Spreadsheets NF00273
Microsoft Multiplan 4.0 mod Spreadsheets NF00278
OpenDocument Spreadsheet 1.0 ods|fods|ots Spreadsheets NF00349
OpenDocument Spreadsheet 1.1 ods|fods|ots Spreadsheets NF00513
OpenDocument Spreadsheet 1.2 ods|fods|ots Spreadsheets NF00514
OpenDocument Spreadsheet 1.3 ods|fods|ots Spreadsheets NF00800
Quattro Pro Spreadsheet 7-8 wb3 Spreadsheets NF00527
Quattro Pro Spreadsheet 9-12, X3, X4 qpw Spreadsheets NF00528
Quattro Pro Spreadsheet for DOS 1-4 wq1 Spreadsheets NF00390
Quattro Pro Spreadsheet for DOS 5.x wq2 Spreadsheets NF00526
Quattro Pro Spreadsheet for Windows 1-5 wb1 Spreadsheets NF00391
Quattro Pro Spreadsheet for Windows 6 wb2 Spreadsheets NF00529