Function Repository Resource:

SpreadsheetEdit

Source Notebook

Edit two-dimensional List data using your system's default spreadsheet editor

Contributed by: Collin Marino

ResourceFunction["SpreadsheetEdit"][]

generates a temporary spreadsheet and opens it in your system's default spreadsheet editing program.

ResourceFunction["SpreadsheetEdit"][data]

generate a spreadsheet pre-filled with data.

Details

SpreadsheetEdit returns the final contents of the file after it has been saved and closed.

The temporary file created by ResourceFunction["SpreadsheetEdit"] is a CSV file with the same format as Export["MyFile.csv”, data] and is stored in $TemporaryDirectory.

When you finish editing the spreadsheet you must save the file in your spreadsheet editor and then click the "Done" button to transfer the data back into Mathematica.

Examples

Basic Examples (2)

Calling SpreadsheetEdit with no input creates an empty spreadsheet you can then input your own text into:

In[1]:=

Out[1]=

Passing existing data to SpreadsheetEdit allows you to make changes to that data in your system's default spreadsheet editor:

In[2]:=

Out[2]=

Scope (1)

Calling SpreadsheetEdit multiple times will open the spreadsheets one at a time:

In[3]:=

Out[3]=

Applications (1)

Easily import large amounts of data by copy-pasting it into the spreadsheet opened by SpreadsheetEdit and then store the data in the notebook using Iconize:

In[4]:=