Be sure the Save as type option selected is CSV (Comma delimited).Choose a location to store the file on your computer.Click the File tab in Excel and select Save.Click the OK button on next pop-up window to populate the data into the spreadsheet.In the Column data format section, select Text.In the Data preview section, make sure all columns are highlighted by scrolling to the right most column and holding the Shift key while selecting the final column.In the Delimiters section, make sure Comma is the only box checked.In the File origin drop down, select 65001 : Unicode (UTF-8).Modify the CSV files in any plain text editor (Notepad, etc.) to remove the offending lines. Simply treat a row with empty fields as empty. In the Text Import Wizard window, be sure Delimited is selected as your file type. Change your code to work with Excels representation and thus follow the standards that have been established for CSV.Find your CSV file stored on your computer, and click Open.Click the Data tab, and select From Text.Open Microsoft Excel and click the Blank Workbook option if prompted.Within the file, each row contains a record, and each field in that record is separated by a comma, tab, or some other character. CSV is an informally-defined file format that stores tabular data (think spreadsheets) in plain text. If you double-click the file on your computer, Excel will try and auto-format the data in the CSV file, which can cause issues when importing your data back into Asset Essentials. Comma-separated values (CSV), and its close relatives (e.g., Tab-separated values) play a very important role in open access science.

We recommend following these instructions any time you need to open your CSV file to make edits. We highly recommend following the instructions on this page to avoid auto formatting issues when working with CSV files in Microsoft Excel.

Edit csv file