When you're creating an import file to import data into your software, try using our Excel templates. They give tips for each column, with required fields in blue and optional fields in yellow.
NOTE: You can use our other guide if you need to import journals.
To access the templates:

Use our import templates and their format rules article for more information.