What are the best practices for importing data?

You can use Import Management and spreadsheet-based quick import macro files to import data. See these resources for more information: