Add multiple Excel/CSV to ArcGIS Online as a feature service with different layers

Add multiple Excel/CSV to ArcGIS Online as a feature service with different layers

I discussed the steps to add a single CSV file as a hosted feature service in an earlier article link, but when I tried to add multiple PDF files, I was unable to do so. Therefore, in this article, I will mention how to upload multiple files combined in one service as different layers.

To follow this article, you will need either ArcMap or ArcGIS Pro because the CSV files will first be converted into features, and then they will be either added to a Geodatabase or Shapefiles.

To begin with, let see our CSV files in the ArcCatalog pane of ArcMap (Step 1).

arcgis online blog 1.png

Then select the file you want to convert to a feature layer. Go to the submenu 'Creat Feature Class' and select 'From XY Table...' (Step 2).

arcgis online blog 2.png

A new window, 'Create Feature Class From XY Table,' will open. First, select the corresponding coordinate from the CSV file in the X and Y fields dropdown menu in this window (Step 3). Then select the Coordinate System that is suitable to the coordinates in your file (Step 4).

arcgis online blog 3.png

For our data, we have selected WGS 1984 (Step 5). Then press OK.

arcgis online blog 4.png

Select a suitable location for your feature class to store (Step 6).

arcgis online blog 3_1.png

Create a file geodatabase (GDB) a store your feature classes in that GDB (Step 7), and then press OK.

arcgis online blog 5.png

This process will convert your CSV to a feature class. Now, head back to the ArcCatalog pane and refresh the folder. You'll be able to see the newly created file in the previously selected GDB (Step 8).

arcgis online blog 6.png

Similarly, you can add more files to the same GBD

arcgis online blog 7.png

In your File Explorer, you'll be able to see the .gdb folder. Create a .zip file from the folder (Step 9)

arcgis online blog 8.png

As discussed in the previous section, we will follow the same steps to upload the file as illustrated below. Well navigate to the Content menu (Step 10) and select Add Item option (Step 11)

arcgis online blog 9.png

We will select the option to upload the file from our computer (Step 12)

arcgis online blog 10.png

Then we'll navigate to the file located in our machine (Step 13)

arcgis online blog 11.png

After uploading the file, you will able to see the following page.

arcgis online blog 12.png

On this page, we will share this service with everyone to be accessible by the public (Step 14).

arcgis online blog 15.png

With this, you can copy the service link from the bottom right corner of the screen and open it in a new window.

arcgis online blog 14.png

This concludes our article on adding multiple excel files and utilizing them as published services with many ESRI products and applications. Most prominently, it can be utilized by your custom web and mobile mapping applications.