# Create Tables (Excel2R)

**Create Tables** – imports Microsoft Excel file with multiple spreadsheets as a selected view types (Legend or Drafting View)

<figure><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FC2dWb1rZZx7GPdv6vVZS%2F0.jpeg?alt=media" alt=""><figcaption></figcaption></figure>

### Configuration window settings

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FWfIvlKvUp1wAs5lzEJw7%2F1.jpeg?alt=media)

1. Select the Excel file from your computer to import.
2. **Available Sheets** - all the Sheets that exist in the selected file.

   ![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FwzHtl8ddNtpnBy26PM7A%2F2.jpeg?alt=media)

* Tick the checkboxes for the **Spreadsheets** that you want to link to the Revit project.
* Choose an existing **Drafting View**, **Legend View**, or create a **new Drafting View** for each spreadsheet.
* Existing **View Name** can be selected or a new **View Name** can be created here.

3. Select what Text and Line Styles you would like to use.&#x20;

* **Use the same Text and Line Styles as in MS Excel File** – Excel2R will create new **text** types with the same text fonts, sizes and styles as they are in the Excel file. Text type name will consist of “E2R”, text size, text font name, and text font style.

<figure><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FVYPGBgkc6oSojxXZDjf4%2F3.jpeg?alt=media" alt=""><figcaption></figcaption></figure>

Excel2R will create **line styles** in the Revit project according to line weights that are used in the Excel file.

<figure><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FQsRkukShT6imGDTCnd95%2F4.jpeg?alt=media" alt=""><figcaption></figcaption></figure>

* **Use Text Font from Revit Project** – a table from Excel will be created with text styles from the current Revit project.
* **Use Text and Line Styles from Revit Project** – will open the Line and Text Style Mapping window to map Excel line and text styles to Revit line and text styles.

<figure><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2F2npGKgNWidBMRWZRK59I%2F5.jpeg?alt=media" alt=""><figcaption></figcaption></figure>

4. **Import Cell Fill Colors from MS Excel** - this setting will create Filled Regions for cells that have a fill color in the Excel file.

To import selected Excel spreadsheets with predefined configurations into Revit, click **Draw Table**.

**The result** can be found in the selected (or newly-created) views:

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2Fi58o7i1OmoCbGOGt0tqt%2F8.jpeg?alt=media)

### Notes

* The tool will skip spreadsheets that begin with “@” symbol in the Excel file.

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FdjkHeRXvGbac9bcxICR7%2F6.jpeg?alt=media)

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FDLQ1H04up1F9JCuNWFMf%2F7.jpeg?alt=media)

* When importing cell fill colors, only these standard colors can be properly imported into Revit. If you're using other colors, they might look slightly different when imported to Revit.

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FBtmQirbTrDNYMq3EVnME%2F9.jpeg?alt=media)

### Tooltip On/Off

<figure><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2Fz4g1VktVNPfZOj4J8Y7G%2F0.jpeg?alt=media" alt=""><figcaption></figcaption></figure>

**Tooltip On** - shows the spreadsheet name and the file location when the cursor is over the active view.

**Tooltip Off** – turns off the tooltip visibility.

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FDZENbtq4TwP0cs85KLWX%2F1.jpeg?alt=media)