How to Import Tabular Content into Adobe Dreamweaver CS6 - dummies

How to Import Tabular Content into Adobe Dreamweaver CS6

By Jennifer Smith, Christopher Smith, Fred Gerantabee

Adding content to a table in Adobe Dreamweaver CS6 is easy: You can type or insert content within table cells just as you would within the page itself. (You can even include other tables!) You can also cut, copy, and paste content from documents and other web pages directly into table cells.

If you already have spreadsheet-style data in text form, you don’t have to retype it into a Dreamweaver table. Dreamweaver has an incredibly useful feature you can use to bring in tabular data as a formatted table: Import Tabular Data.

CSV (comma-separated values) and tab-delimited files are plain text files that can be generated from a number of popular programs, such as Microsoft Excel. You can use these files to save spreadsheet data in a way that lets it be exchanged with other applications such as Dreamweaver.

In CSV files, columns are noted by commas between values, and each line return indicates a new row. In tab-delimited files, a tab between values indicates a new column and a line return forces a new row.

To import tabular data, follow these steps:

  1. Using Microsoft Excel or a similar program, create a spreadsheet of data, and save it as .csv (comma-separated values).

    You can save this wherever you’d like, as long as you can easily locate it.

  2. Return to Dreamweaver and open a page where you’d like to add a table.

  3. Put the cursor on the page where you want the table to be created.

  4. Choose File→Import→Tabular Data.

    The Import Tabular Data dialog box appears.

  5. Use the Browse button to browse to the location of a CSV (.csv) file or a tab-delimited (.txt) plain-text file.

  6. Verify or select the delimiter that your file uses.

    Typically, the delimiter (where a new column will be created) is a comma or tab; however, you can also instruct Dreamweaver to create a new column from other delimiters, such as Comma, Semicolon, Colon, or other options, by using the Delimited drop-down list.

  7. Determine the table width.

    You can choose to have the table automatically sized to fit the data by leaving the Fit to Data radio button selected, or you can enter a number in the Set To text box to set a percentage or pixel value.

  8. Enter numbers in the Padding, Spacing, and Border text boxes and specify top-row formatting in the Format Top Row drop-down list at the bottom of the dialog box.

  9. When you’re finished with these settings, click OK.

    Your table is created!

You can export table data from Dreamweaver just as easily as you can import it, by selecting a table and choosing File→Export→Table. When the Export Table dialog box appears, choose an element to be the delimiter and choose the type of line break. Click Export, determine where you want to save the file, and click Save.

If you select every cell in a row, you also have the opportunity to change the alignment of an entire row. In the Property inspector, you find a horizontal alignment drop-down list that changes the alignment of an entire row or selected cell. Choose from Left (default), Center, or Right. Note that any changes you make in the individual cell alignment override the row alignment.

You can also change the vertical alignment in the Property inspector when you have a row selected. Click the Vert drop-down list and select Default, Top, Middle, Bottom, or Baseline.

To select an entire row at once, position the cursor on the left side of the row you want to select. When the black arrow appears, simply click. You can also use this method of selecting an entire column by positioning the cursor on top of the column you want to select until the black arrow appears.