-->
header image

Importing Cross Section Data from Excel - CS Software Help



ESurvey Section allows you to import data from 5 different types of excel formats – Layers, Series, Classic, Fixed Distance and Field Book.

ESurvey Importing CS Data
1. Click on ‘Template’ button on the toolbar and select each of these options and open the templates.

Import Cross Section Data From Excel
These are sample data files for various templates

    A. Layers: Use this template if the input data is available layer wise.

    Import Cross Section Data From Excel
    B. Series: Use this template if the input data is available section wise.

    Import Cross Section Data From Excel
    C. Classic: Please note that there are 5 different worksheets in this template and you need to select the template depending on the number of columns of data you have.

    Import Cross Section Data From Excel
    D. Fixed Distance: Use this template if the input data is available at standard distance.

    Import Cross Section Data From Excel
    E. Field Book: Use this template when you have survey data created from auto level.

    Import Cross Section Data From Excel
2. To understand the column names better, open and see C:\ESurvey\ESurveyCADD\Sample\Series.xls which is a readily available in sample folder.

Import Cross Section Data From Excel
3. There are 5 columns of data – Layer, Section, Distance, Level and Remark. ESurvey CADD allows importing data up to 20 layers.

Import Cross Section Data From Excel
Normally ground data are imported in Layer1 and hence you have to specify 1 as layer number. In section column, you have to specify the chainage value. In the Distance column, you have to give the distance from the centre for offsets on left side give distance in negative. In a level column, enter reduced level that is the elevation or z value of the point. You can optionally enter the remark if any. After entering the data you save the file in any location.

4. You can import data available in sample folder that is ‘Series.xls’. Click on 'Excel Import' and select ‘Series.xls’.

Import Cross Section Data From Excel
Import Cross Section Data From Excel
Import Cross Section Data From Excel
5. Once the data is imported, all the cross sections will be created automatically. You can navigate from a cross section to cross section in the preview screen.

Import Cross Section Data From Excel