Can I import csv file of line data?

[asdfjljwg]

Hello, I have a csv-structured dataset as follows : 

ID	x1	y1	x2	y2
1	14184878	4442592	14184886	4442595
2	14184504	4443068	14184511	4443076
...	...	...	...	...

This is a line dataset, whose x values are latitude and y values are longitude of two points of each line.

But I have no idea how to import this in line form, because the only way importing csv file into GIS I've known so far is just dropping it and clicking 'XY data display' menu. And if I do this, I can use coordinates of only one point. Thus, I can only import this csv file in only point form. 

So is there any way that I can import this in line form?

[JohannesBierer]

I think you will need python to do this - someone posted a solution here:

https://gis.stackexchange.com/questions/34647/creating-lines-from-points-pair-coordinates-with-arcpy

I tried the code of Chad Cooper there with four points with the old cursors ... it seems to work.

Here is the code I used:

import arcpy

fieldnames = ['X1', 'Y1', 'X2', 'Y2']
# Needed input/ output files
inExcel = r"YOURPATH\Points.xlsx"
FGDB = r"YOURPATH\Points2Lines.gdb"
outTable = "Coords"
outLines = "Lines"

arcpy.env.workspace = FGDB
arcpy.env.overwriteOutput = True

# Change to your Sheet name!
arcpy.conversion.ExcelToTable(inExcel, outTable, "Test")

in_rows = arcpy.SearchCursor(outTable)

point = arcpy.Point()
array = arcpy.Array()

# Without Spatial Reference, please change!
arcpy.CreateFeatureclass_management(FGDB, outLines, "POLYLINE")

featureList = []
cursor = arcpy.InsertCursor(outLines)
feat = cursor.newRow()

for in_row in in_rows:
    # Set X and Y for start and end points
    # Change here to your field names
    point.X = in_row.X1
    point.Y = in_row.Y1
    array.add(point)
    point.X = in_row.X2
    point.Y = in_row.Y2
    array.add(point)   
    # Create a Polyline object based on the array of points
    polyline = arcpy.Polyline(array)
    # Clear the array for future use
    array.removeAll()
    # Append to the list of Polyline objects
    featureList.append(polyline)
    # Insert the feature
    feat.shape = polyline
    cursor.insertRow(feat)
del feat
del cursor

[asdfjljwg]

Thank you! I didn't tried this yet, but this seems very fit for my purpose.

[AhmedFathy74 · Accepted solution]

Hi,

You can easily use xy to line geoprocessing tool and you will be able to add this CSV file in line form 

Ahmed fathy