Importing Worksheets

Data from a wide variety of worksheet formats can be imported into a file, including worksheet data from other programs and worksheets from other Vectorworks files.

Importing Worksheet Data from Another Program

Command

Path

Import Worksheet

File (worksheet menu)

During import, the spreadsheet data is imported, but the formulas (logic) are not.

To import worksheet data into a Vectorworks file:

  1. Select the command.

  2. Select the worksheet file to be imported. The worksheet must be in one of the following formats:

  3.         Tab delimited text (.txt)

            Comma delimited text (.csv)

            DIF (.dif)

            SYLK (.slk)

  4. Click Open. The worksheet is imported as a new worksheet in the Vectorworks file.

Importing Worksheets from Another Vectorworks File

To import a Vectorworks worksheet from another Vectorworks file:

  1. From the Resource Manager, right-click on the resource, and select Import.

  2. Alternatively, drag the worksheet resource into the desired Vectorworks file to insert it as a drawing object; see Placing a Worksheet on the Drawing.

The selected worksheet is imported into the current file.

Importing a Table from Microsoft Word

The following procedure is an example of how to import a table from Microsoft Word into a Vectorworks worksheet.

To import a Word table into a worksheet:

  1. In Word, select the entire table to be imported.

  2. Select the Table Tools > Layout > Convert to Text.

  3. The Convert Table to Text dialog box opens.

  4. In the dialog box, click Tabs for the separation identifier.

  5. Click OK.

  6. Save the table.

  7. If the file consists of only the table, select File > Save As. In the Save As dialog box that opens, select Text Only from the Save as type list.

    If the table is part of a larger file, copy the table to the Clipboard. Select File > New, and paste the table text into a new document. Save the file as a text file.

  8. Return to the Vectorworks file and import the table as described in Importing Worksheet Data from Another Program.

 

Was this page helpful?