User Guide > Spreadsheet files > Raw CSV file view explained

Companion

[Raw] [Data file view] [CSV file view] from the Main window opens a "Raw CSV file view" window.

It is used to view spreadsheet files as they are stored on disk.

This window makes no reference to any of the entries in the project and every cell is treated as text.

This window has facilities to:

•Change individual cells

•Add new rows and delete rows

•Rename the headers

•Sort the order of the rows

•Change the order of the columns

•Extract (copy) part of the data to view or save

Locking and Archiving

Once any changes (edits) have been made to the file it is locked; other users cannot open it until it has been saved.

If two people already have the file open and one of them has changed the file (and locked it), then the other user is not allowed to alter the contents.

When a file is saved, the previous version of the file is copied to the Archive sub-folder. If you make a lot of changes to a project you may want to clear out some of the older copies of the data files.