Yes I have done this already and still have the same issue. I can import the file as a csv into ArcPRO but not xls which is what the assignment calls for.
Yeahhhh it doesn’t matter if it’s xls or csv. You can point her to any actual professional who will tell you this. In fact, csv is the preferred file type. They are an idiot.
Make sure you have it saved in the older Excel format, xls rather than the newer xlsx.
Also, make sure that you don’t have any spaces in your column titles, and that each column is assigned the proper data type (text, number, etc). Best to have dates stored as text not date.
Can’t help with the driver issue, but aside from that Esri is picky when it comes to Excel files.
Check to see if you have the most recent service pack installed. I had pro 2.8 installed on a new machine and it woundnt load in excel sheets. Think there are 3 service packs available for download. That may help
I had this problem when I upgraded from an older version of Excel. I discovered that I had to add a driver to make it compatible. [https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm](https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm) Explains the driver - the link from that page does not work, but try this one. If it doesn't work, message me and I can see if I found the one I used. I knew I could save files as CSVs, but I am constantly working with xlsx files and did not want the hassle of converting them all to csv.
As a standard practice, I convert to csv before loading into Arc Pro. This has been a problem going all the way to ArcView 3.2. ESRI has not been able to make that easy. Also, once you do get Excel to load, it is quite buggy.
You do this yet? https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm
This is the answer.
Yes I have done this already and still have the same issue. I can import the file as a csv into ArcPRO but not xls which is what the assignment calls for.
Your prof WILL NOT care that it's a csv over an xls. Prof can't expect you to have paid licenses of software.
Yeahhhh it doesn’t matter if it’s xls or csv. You can point her to any actual professional who will tell you this. In fact, csv is the preferred file type. They are an idiot.
Save the data as CSV and import that as a table, if you can't fix by other means.
https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm Requires a Microsoft install
Try using Excel to Table tool on the sheet
Make sure you have it saved in the older Excel format, xls rather than the newer xlsx. Also, make sure that you don’t have any spaces in your column titles, and that each column is assigned the proper data type (text, number, etc). Best to have dates stored as text not date. Can’t help with the driver issue, but aside from that Esri is picky when it comes to Excel files.
Check to see if you have the most recent service pack installed. I had pro 2.8 installed on a new machine and it woundnt load in excel sheets. Think there are 3 service packs available for download. That may help
Microsoft service pack that is
I’ve already checked and I have everything up to date and I am still having the issue.
Not too sure then. Other option convert the excel sheet to a csv and try it rhat way.
I had this problem when I upgraded from an older version of Excel. I discovered that I had to add a driver to make it compatible. [https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm](https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm) Explains the driver - the link from that page does not work, but try this one. If it doesn't work, message me and I can see if I found the one I used. I knew I could save files as CSVs, but I am constantly working with xlsx files and did not want the hassle of converting them all to csv.
As a standard practice, I convert to csv before loading into Arc Pro. This has been a problem going all the way to ArcView 3.2. ESRI has not been able to make that easy. Also, once you do get Excel to load, it is quite buggy.