I have joined a spreadsheet to a polyline shapefile. The information from the spreadsheet is present in the attribute table however when I apply a buffer the information is not in the attribute table for the buffer. I have done this before and gotten it to work.

Any advice?

1 Answer 1


You need to make sure that the values in the attribute table is numerical values. Excel sometimes tricky, you can see numerical values in the attribute table but Excel treats the values as text. Therefore, you need to convert the text digits into numbers or numeric by selecting the numerical column and from the Format cell change it to Number.

Or easier, save the file as CSV, and it should handle the values as numbers not text.

Also, you need to save the the polyline as new polyline shapefile after joining the shapefile with the CSV to make the join permanent, so you can select it when doing buffer analysis.

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.