import csv file as a Trailayer in Search Widget

[Henryobaseki]

Hi All,

I have spent a lot of time trying to figure this out in excel. The issue is my Number column in excel displays scientific number;

1.00091E+11

1.00091E+11

I have used the format cells to numbers but when I save and reopens the scientific numbers comes back. This is an issue when using the csv as a search layer. It gives random numbers. I want the unique numbers to be displayed as it is.. 100090429674 100090429671 100091440630 200004639203. this is my code; // Add the layer to the map   var trailsLayer2 = new FeatureLayer({     url: "https://services1.arcgis.com/BZNs0xaSHDSi4V6G/arcgis/rest/services/Addresses_A/FeatureServer/0",   }); map.add(trailsLayer2); // Optionally add layer to map

At the moment my info table displays 100090429671 as 1000000000000.

[SteveCole]

In Excel, you should format that column as TEXT instead of numbers. That will eliminate the 1.0E+11 issue, and hopefully the issue you have inside the JS API as well. You should especially do this if any of your values have leading zeros (in my County, the tax account numbers sometimes have two leading zeros).

[Henryobaseki]

hi steve,

I have changed the format to TEXT. this is what I get

100090429674  changes to 100090000000

[Henryobaseki · Accepted solution]

Hi All,

Finally resolved the issue. Did save as numbers in excel and then resave as a string in ArcGIS Online. The numbers are exactly the same as it is on the spreadsheet.