To upload an Excel spreadsheet into LON-CAPA, you must convert the
Excel spreadsheet into a Comma Separated Value file (or CSV file for short) as follows:
- Open the spreadsheet in Excel.
- Choose File and Save As....
- Select CSV (Comma delimited)(*.csv) from the Save as type: drop-down
menu, remembering where you save it.
- Click Save.
- Click Ok, or Yes for any windows that may appear in order to create the
You can then upload the CSV file generated, as described in
Other spreadsheet programs can also export CSV files. Many of them
follow procedures very similar to Excel. Consult your spreadsheet
program's documentation for more information.