I have a .shp-file filled with polylines, where some of them are currently being drawn as a straight line from A-B, where in reality they curve a lot along the way.

In the shapefile, I have an "ID" that matches with an Access/Excel table where I have the coordinates for all the vertices that need to be added to the lines in order for them to have their correct position.

I need to change the lines from straight lines to lines with a lot of vertices using coordinates from my Acces/Excel-file. CRS is the same for both files, and there are about 15.000 vertices in total.

I am using ArcMap 10.6.1, Advanced license, with Spatial/3D Analyst.


Example of exceldata

  • 1
    Do your points share the same CRS with polylines?
    – Taras
    Jul 26, 2019 at 6:22
  • Yes, the coordinate system is the same. All the data should be compatible, just don't know how to combine it. Jul 26, 2019 at 6:41
  • @BERA Not really sure how that would work, doesn't that only give the start coordinates and end coordinates? If we take the line ID21 as an example I have 216 vertices I need to move from the Excel file onto the line so it follows the correct path. Forgive me if I'm being stupid, but can XY To Line do that? Jul 26, 2019 at 7:01
  • 2
    I think you'll need ArcPy to do this and, for that, you'll need to provide a code attempt to get help with your code because we don't provide a code writing service.
    – PolyGeo
    Jul 26, 2019 at 7:38
  • 1
    If you can get from your CSV to points first then the Points To Line tool looks like it should get you most if not all the way there.
    – PolyGeo
    Jul 26, 2019 at 7:47

1 Answer 1


After PolyGeo's suggestion with Points To Line, I did the following steps:

  • New sort field in Accessdata to get the right route (0-1-2-3-4-5).
  • Create Point Layer using the Access data
  • Then Point To Line with ID and Sort field active
  • Lastly did a join from my old shape file with correct attributes on the new layer line layer with correct paths/routes.

Now I have everything as needed!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.