I need to get the start and the end point of each line in a shapefile. In my case these lines represents pipelines. I need to get the start and the end points of each pipeline in an Excel sheet and to refer to the number of the line that is connected between any two points.
If you have an Advanced level license of ArcGIS for Desktop then the tool to look at will be Feature Vertices To Points (Data Management):
Creates a feature class containing points generated from specified vertices or locations of the input features.
and its BOTH_ENDS option:
BOTH_ENDS —Two points will be created, one at the start point and another at the endpoint of each input feature.