To bring an Excel table into OpenRoads Designer, use the Place Table command, choose Excel as the source, select the workbook and cell range, then place the table in the design file. This creates a drafting table from spreadsheet cells; it does not automatically turn spreadsheet coordinates or quantities into OpenRoads geometry. The exact dialog labels can vary by OpenRoads Designer release, so check the options in your installed version.
What You’ll Need
- OpenRoads Designer with a design file open. The steps below apply to the CONNECT Edition interface; ribbon names can differ slightly between releases.
- An Excel workbook, preferably saved as an .xlsx file, with the table arranged in a clear rectangular range.
- A suitable model and view in which to place the table, plus a saved copy of the DGN if you are working in a project file.
- If you want the drawing table to reflect later spreadsheet edits, check whether your version offers an Excel link option. Linking behavior and available update commands depend on the installed version.
Step-by-Step
- Prepare the spreadsheet. Open the workbook in Excel and make a clean table with one header row and consistent columns. Remove blank rows and columns inside the data, merged cells, notes, and decorative elements that should not appear in the drawing. Make sure column headings are short enough to fit at the intended drawing scale. Set number formats, decimal places, dates, and units in Excel before importing; formatting that looks right on a worksheet may still need adjusting in a CAD drawing. Save the workbook, and note the sheet name and cell range you want, such as the table on Sheet1 from A1 to F18. If practical, close Excel after saving so you can tell that you are importing the latest saved version rather than unsaved edits.
- Open the right design file and model. In OpenRoads Designer, open the DGN and select the model where the table belongs. Choose a 2D drawing or sheet model for a report-style table unless your project workflow specifically calls for another model. Check the active model, view, and working units before placement. An imported table is a graphical element in the design file; it will not automatically inherit a spreadsheet’s page layout or know what scale is appropriate for your sheet.
- Find Place Table. On the ribbon, look under Drawing > Annotate > Tables > Place Table. In some releases or customized workspaces, the tool may be located differently; use the ribbon’s command search, if available, and search for Place Table. Confirm that you are opening the table placement tool rather than a tool for placing text or importing survey data.
- Choose Excel as the source. In the Place Table dialog, select the Excel or From Excel source option. Use the browse control to find and select the saved workbook. If the dialog asks for a worksheet, choose the sheet containing the data. Select the required cell range if the dialog provides a range field or range selection control. Some versions may let you select the range from the workbook; follow the dialog’s prompts and verify the range before continuing. If only the whole worksheet can be selected, clean up the sheet first so unrelated cells are not included.
- Review import and link settings. Check the preview, if one is shown, for missing columns, extra blank rows, and unexpected formatting. If the dialog offers a choice between a static import and a link to the Excel file, choose based on how the table will be maintained. A static import is a snapshot and will not reflect spreadsheet changes automatically. A linked table can be updated from its source in versions that support the link workflow, but it depends on the workbook remaining accessible at the saved path. Read the dialog’s options for cell formatting, row and column sizing, and any available table style, then use the settings appropriate for the sheet. Do not assume every Excel feature, such as conditional formatting or formulas, will be reproduced exactly as it appears in Excel.
- Set the table appearance and scale. Where the tool provides controls, review text height, row height, column width, margins, borders, and text style. Check the active annotation scale or drawing scale if your workflow uses one. A table that is legible in Excel can become too small or too large when placed in a DGN. If the dialog has no useful preview or sizing controls, place the table in an open area first and inspect it before moving it to its final position. Prefer changing the table settings or the source range over repeatedly scaling text by eye.
- Place the table in the model. Accept the dialog settings and follow the on-screen prompt to define the insertion point. Move the pointer to a clear area and click to place the table. Use the view’s orientation and sheet layout as a guide: leave room for titles, notes, and other drawing content, and avoid placing the table over design geometry. If the placement prompt offers a rotation or a second point, use it only when needed to align the table with the drawing layout.
- Inspect the result in the DGN. Fit or zoom to the table and review the headings, text, borders, alignment, and overall size. Compare important values with the Excel source, including decimal places, dates, units, and any leading zeros in identifiers. Confirm that all intended rows and columns are present and that no blank spreadsheet area produced unwanted cells. If the table is correct, save the DGN. If it is not, use Undo promptly or delete the misplaced table, correct the source or settings, and place it again.
- Plan how updates will be handled. For a static import, changes in Excel require you to import the revised data and replace or revise the drawing table; editing the workbook alone does not refresh it. For a linked table, keep the workbook in a stable project location and use the update or link-management command provided by your OpenRoads Designer version when source values change. After updating, inspect the table again because longer text or new rows may alter its size. If a DGN is shared with others, make sure the workbook path is available to them or provide the source file according to the project file-management rules.
Common Mistakes
- Selecting the wrong range. Importing a whole worksheet can include blank rows, notes, or unrelated cells. Identify the exact rectangular range in Excel before starting and verify the selection in the import dialog.
- Expecting engineering objects. A table imported from Excel is normally drawing content, not a set of OpenRoads features. For example, a column of station values and another of offsets will not automatically create a corridor, alignment, or points just because they came from a spreadsheet. Use the appropriate civil geometry or data-import workflow when the goal is to create model objects.
- Assuming a static table will update. A snapshot stays as it was at import. If values change later, you must import or update the table using the supported workflow. Choose a link option only when it is available and your file-management process can preserve access to the workbook.
- Ignoring units and formatting. Excel may display rounded values while storing more precision, or show dates and identifiers in formats that do not transfer as expected. Check critical values in the placed table rather than relying only on the worksheet appearance.
- Placing at an unsuitable size or location. A table can cover design content or be illegible on a plotted sheet. Check the model, active scale, and final sheet context, then inspect the actual placed result.
- Moving or renaming a linked workbook. If a link depends on a file path, changing the workbook’s location or name can break the connection. Coordinate the source-file location with the project team before relying on linked updates.
Tips
- Use a dedicated worksheet or a named, neatly bounded data area for the drawing table. Keeping notes and calculations elsewhere makes selecting the correct range easier.
- Use concise column headings and consistent units. If the units need explanation, put them in the heading, such as Elevation (m), instead of relying on a note in a distant cell.
- Check whether leading zeros matter for identifiers. Excel can interpret values such as 0042 as numbers and display them as 42 unless the source cells are formatted or stored appropriately.
- Keep a record of the source workbook, worksheet, range, and import date when the table supports a project deliverable. This helps another person confirm which data was used.
- For a large table, consider splitting it into logical sections or placing it in a sheet model. Dense text can be difficult to read when scaled to fit a plan sheet.
- Before final plotting, review the table in the sheet’s plotted or print preview context, not just at a close zoom in the design model. Verify text size, line weights, and page fit.
Troubleshooting
The Excel source option is missing. Check that you are using the Place Table command and not another annotation tool. Ribbon organization can vary by release and workspace, so search for Place Table or consult the installed version’s help. If the command or Excel source is genuinely unavailable, check your product version and installation capabilities with your CAD administrator; do not substitute a different import method without confirming it suits the task.
The workbook or worksheet is not listed. Save the workbook in a supported Excel format, confirm that the file is not in a restricted location, and browse to it again. If the workbook has unsaved changes, save them in Excel first. Try a simple test workbook with one worksheet and a small rectangular range to determine whether the issue is caused by the source file or the project setup.
The table appears blank or only partly populated. Reopen the source in Excel and confirm that the cells contain values, not just formatting or formulas that have not recalculated. Check the selected sheet and range, remove merged cells or blank separators, save, and import again. If formulas are involved, verify that the workbook displays the expected calculated results before importing; the drawing may not behave like a live Excel calculation grid.
Text is clipped, crowded, or too small. Increase the relevant column width or row height in the source or in the table settings, shorten long headings, and review text height and scale in OpenRoads Designer. Re-import or update after making changes, then check the result at the intended sheet scale. Avoid fixing one column by stretching the entire table if that makes other columns unreadable.
A linked table does not show spreadsheet edits. Save the workbook, confirm the link still points to the correct file, and use the version’s table or link update command. If the source file was moved, restore it to the expected location or repair the link using the available link-management tools. If updates are unreliable or the workbook will not be shared, use a static table and establish a controlled re-import process instead.
The command behaves differently from these steps. OpenRoads Designer releases and company workspaces can change ribbon locations, dialog choices, and link behavior. Check the product version shown in the application and use the corresponding Bentley documentation or your organization’s CAD standards. The essential workflow remains to choose the Excel source, select the intended data, place the table, and verify the result in the DGN.
Frequently Asked Questions
Does importing an Excel table create OpenRoads geometry?
No. The Place Table workflow creates a drawing table from spreadsheet cells. It does not convert rows into alignments, terrain features, corridors, or other civil objects. Use a data-specific OpenRoads workflow when you need model geometry.
Will the table update automatically when I edit Excel?
Not if it was imported as a static snapshot. If your version provides an Excel link option, updates may be available through its link or table update workflow, but the source workbook must remain accessible. Check the dialog and version documentation before depending on automatic updates.
Can I import just a few cells instead of the whole worksheet?
Usually the goal is to select a specific worksheet range rather than include the entire sheet. The available selection method depends on the release. If the dialog cannot restrict the range, copy the wanted data to a clean worksheet and import that sheet.
Can I import formulas and Excel formatting?
The table can use spreadsheet content, but it should not be treated as a fully interactive Excel worksheet. Formula results and formatting may not reproduce exactly, and the placed table will not necessarily recalculate like Excel. Check displayed values, number formats, borders, and text after placement.
Can I edit the imported table in OpenRoads Designer?
You can generally edit or replace drawing content using the table-editing tools available in your version, but editing a table in the DGN is not the same as editing its source workbook. For a linked table, changing content in the DGN may also interact with later source updates. Keep Excel as the authoritative source if that is your project workflow.
What if I need spreadsheet coordinates to create points?
Do not use Place Table for that purpose. It places a readable table, not survey points or civil geometry. Use the supported coordinate or survey import workflow for your OpenRoads Designer version, and verify coordinate order, units, and coordinate system before creating project data.
Related
- Find Matching Names in Excel Columns: Easy Methods
- Find Mean in Excel with AVERAGE and Examples
- Find Links to Other Workbooks in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting to Highlight an Entire Row in ExcelYes. In Excel for Microsoft 365, select the data range, create a formula-based conditional-formatting rule, and use a…
- COUNTIF TRUE in Google Sheets: Count Boolean ValuesTo count cells whose value is the Boolean TRUE in Google Sheets, use =COUNTIF(A2:A20,TRUE), replacing A2:A20 with your…
- Search Archive Emails in Outlook: A Practical GuideTo find archived email in Outlook, search the Archive folder or set the search scope to include it,…
- Open Excel in a Web Browser: A Simple Step-by-Step GuideTo open Excel in a web browser, go to Microsoft365.com, sign in with a Microsoft account, and choose…
- Insert a Personal Signature in Word Online: Steps and TipsYes. In Word Online, the most reliable way to insert a personal signature is to add it as…
- Conditional Formatting Color Scales in Excel ExplainedIn Excel for Microsoft 365 on Windows, a conditional formatting color scale colors cells according to their numeric…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.