topic Re: Adding data to ArcGIS Excel in ArcGIS for Excel Questions

Adding data to ArcGIS Excel

ZiziphoKeli1 — Mon, 21 Jul 2025 13:55:01 GMT

When trying to add my practice data to my ArcGIS for Excel on the layers option, I get this error message: "Cannot read properties of null (reading '0')". What could be the problem?

Re: Adding data to ArcGIS Excel

CodyPatterson — Mon, 21 Jul 2025 13:56:47 GMT

Hey @ZiziphoKeli1

Would it be possible to link the practice data here? It may be that Excel cannot read blank or rows with a 0 in it, I would attempt to export a single row from the attribute table and test to see if it has problems with certain data.

Cody

Re: Adding data to ArcGIS Excel

ZiziphoKeli1 — Mon, 21 Jul 2025 14:08:27 GMT

It's this data file, downloaded from the ArcGIS for Excel Basics course.

Re: Adding data to ArcGIS Excel

CodyPatterson — Mon, 21 Jul 2025 14:38:27 GMT

Hey @ZiziphoKeli1

Your data looks just fine, I see no major issues in it, would it be possible to cut down the CSV to 1-5 rows and then attempt an upload? I would also try to open a new fresh Excel instance to be sure it's not something else in the sheet you're trying to use.

Cody

Re: Adding data to ArcGIS Excel

ShannonCardoza — Mon, 21 Jul 2025 21:54:12 GMT

Good afternoon @ZiziphoKeli1, Thanks for posting! From what I gather you downloaded the data from a training course, is it this one, Get started with ArcGIS for Excel? I ask because the sample data you provided here in another comment is Insured properties but the data from the training course is SalonCustomers. Can you please clarify?

Thank you,

Re: Adding data to ArcGIS Excel

ZiziphoKeli1 — Tue, 22 Jul 2025 09:11:57 GMT

Hi @ShannonCardoza. Thank you for your reply! They must have changed the data because the one I was working with is Insured Properties. But no worries, I was able to find a solution.