search

GridMod / RTS-GMLC

Reliability Test System - Grid Modernization Lab Consortium
154 stars 82 forks source link

CSV error when opening branch.csv #57

Closed jennielu92 closed 7 years ago

jennielu92 commented 7 years ago

@claytonpbarrows @kdheepak Excel throws a weird error when you try to open RTS_Data\SourceData\branch.csv. This is a known issue in Excel when a CSV starts with "ID". For further reading, see here: http://www.alunr.com/excel-csv-import-returns-an-sylk-file-format-error/

Possible solutions include: renaming the first column ('SID' or 'id' work fine, for example), or put a different column first. We did not attempt to make any changes for fear of causing downstream errors.

claytonpbarrows commented 7 years ago

change column name to UID