topic Adding CSV file from a URL is not showing columns in ArcGIS Online Questions

Adding CSV file from a URL is not showing columns

SébastienKoller — Wed, 16 Aug 2017 12:00:18 GMT

In ArcGIS Online, when adding a csv file from a URL (Add Layer from Web), the system doesn't recognize the columns, it only shows _html_. But my csv file contains the following columns: FID, ISO-3166 alpha-2, NS deployed

Re: Adding CSV file from a URL is not showing columns

AdrianWelsh — Wed, 16 Aug 2017 21:54:53 GMT

Sébastien,

Take out the hyphens and spaces. Put in underscores for your field names.

ISO_3166_alpha_2, NS_deployed

Re: Adding CSV file from a URL is not showing columns

shan_sarkar — Thu, 17 Aug 2017 04:42:05 GMT

I agree with Adrian, you need to remove any spaces or special characters from the columns in the excel and try and have the columns names to start with a letter and not a number.

Re: Adding CSV file from a URL is not showing columns

SébastienKoller — Thu, 17 Aug 2017 07:29:17 GMT

Hi Adrian,

Thank you very much for your feedback.

We did try as you said but still the same message show up. It might come from our Share Point (linked to some security process). We are enquiring on our side. We will let you know when we find a solution.

Best regards

Re: Adding CSV file from a URL is not showing columns

AdrianWelsh — Thu, 17 Aug 2017 17:20:44 GMT

Can you share the CSV layer publicly here so others can test it?

Re: Adding CSV file from a URL is not showing columns

SébastienKoller — Fri, 18 Aug 2017 14:53:25 GMT

Unfortunately the file is on our Share Point Organization, I cannot share it. I can send it to you if you'd like to test it. But it looks like that (saved as csv) :

ISO_3166_alpha_2	NS_deployed
AU	Australian Red Cross
DK	Danish Red Cross
EC	Ecuadorian Red Cross
ET	Ethiopian Red Cross Society
FI	Finnish Red Cross
DE	German Red Cross
GR	Hellenic Red Cross
IE	Irish Red Cross Society
IT	Italian Red Cross

Re: Adding CSV file from a URL is not showing columns

AdrianWelsh — Fri, 18 Aug 2017 20:52:04 GMT

Do you have location data for it to be located on the map?

This article may help:

CSV, TXT, and GPX files—ArcGIS Online Help | ArcGIS

Re: Adding CSV file from a URL is not showing columns

SébastienKoller — Mon, 21 Aug 2017 06:51:18 GMT

I have "only" these two fields. I use this file to make a join (ISO) with another one ("World Countries (Generalized)")) to display the countries in the join. As this file can be updated once in a while I would like that someone can update the file on share point and then automatically the map gets updated.

Re: Adding CSV file from a URL is not showing columns

AdrianWelsh — Mon, 21 Aug 2017 12:50:08 GMT

The CSV has to have location data in order to be displayed on a map. See the above link for details.

Re: Adding CSV file from a URL is not showing columns

SébastienKoller — Tue, 22 Aug 2017 06:27:30 GMT

Actually you're right if I wanted to display something on the map, but in my case I "only" want to make a join. In the link you mention it is also written :

You can also add a CSV file that doesn't contain location information to Map Viewer as a table. This is useful when you want to join nonspatial data—for example, property damage claims related to a recent tornado—to spatial data such as a ZIP Codes layer using the Join Features analysis tool.

Re: Adding CSV file from a URL is not showing columns

ChrisWhitmore — Tue, 22 Aug 2017 16:34:52 GMT

Hi Sébastien - one thing to check is the response from the server providing the csv. The headers that are returned when the request is made from the map viewer may be causing the CSV to be interpreted as something other than text (which would potentially cause parsing to fail, etc).

You can check this out using a browser's developer tools (Chrome has a great set). Esri technical support can assist as well. In the response headers from the request for the CSV, you should see content-type as a property. This is an example from the USGS for their recent earthquakes feed: