How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.