Export alignment superelevation data
Last updated: 2022-08-29
Total video time: 4:33
cntrctr-data-xprt-ali-supr-data-01.mp4 4:33
Civil 3D 2020 and later – export to xlsx
Alignment superelevation information is exported to an Excel spreadsheet instead of using the CSV export button in superelevation tabular editor.
See Contractor Data - Superelevation Report for more information.
Civil 3D versions prior to 2020 – export to csv
Export alignment superelevation CSV files
- Open drawing file with alignment to export
- Select the centerline alignment graphically.
- Contextual ribbon > Modify > Superelevation pulldown > View Tabular Editor
- Tabular Editor panorama > Export Superelevation Data icon
- In the Export to CSV dialog browse to the project 12345678\const\CD-Design\CD-AliProf and type in the filename < Construction_ID >-Super-Ali-< Ali Name >.csv
- Save
Clean up alignment superelevation csv file
Info: If your design has no "inside" lanes or shoulders (non-divided design) you will need to delete extra columns from the csv file.
- Open file 12345678\const\CD-Design\CD-AliProf\< Construction_ID >-Super-Ali-< Ali Name >.csv
- Review this file. It had superelevation data for both the outside lanes and shoulders as well as the inside lanes and shoulders. Nothing needs to be cleaned out of this file.
- Open file Superelevation Example.CSV
- Select the Column G header (Left Inside Lane) then CTRL + select following columns:
- Column H (Left Inside Shoulder)
- Column K (Right Inside Lane)
- Column L (Right Inside Shoulder)
- Right-click > Delete to remove columns.
- Save