To Create a General Table using an .xls or .csv File

Import table data from an existing spreadsheet.

Create a table using an .xls or .xlsx file as the data source

1. On the ribbon, click Annotate tab Table panel General.

2. In the Table dialog box, click Browse to locate a Microsoft Excel (.xls or .xlsx) file to use as a data source.

   Note: Make sure that the Excel sheet is in the current project. Change the Files of type to Microsoft Office Excel Workbook (.xls, .xlsx).

3. In the Data Start Cell field, specify the cell from which to start referencing data for the table.

4. Specify the column header row.

5. Click OK to place the table on the drawing sheet.

   Unless you specify a different name within the Table style, the table inherits the name of the selected source file. Column names are derived from the source row indicated by the Column Header Row.

Create a table using a .csv file as the data source

1. On the ribbon, click Annotate tab Table panel General .

2. In the Table dialog box, click Browse to locate a .csv file to use as a data source.

3. If appropriate, clear the Use First Row for Column Headers check box.

4. Click OK to place the table on the drawing sheet.