# Import data from excel failed **URL:** \ **Category:** Revit\ **Created:** [February 3, 2023, 11:46am UTC](https://forum.dynamobim.com/t/import-data-from-excel-failed/85717 "2023-02-03T11:46:30Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![azhar.alikoya](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@azhar.alikoya](https://forum.dynamobim.com/u/azhar.alikoya)\ **Post date:** [February 3, 2023, 11:46am UTC](https://forum.dynamobim.com/t/import-data-from-excel-failed/85717/1 "2023-02-03T11:46:31Z")
![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/4/245e71f514a224998ac6cf550b04913008e830be.png) When i tried to import data from excel to replace the shared parameter value of pipe in my project , it applies only the value in 1st row. could you please help me? We transfer link for the file: [WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free](https://we.tl/t-baJRfeD96c) ---
**Author:** ![Joe.ashton](https://avatars.discourse-cdn.com/v4/letter/j/7993a0/32.png) [@Joe.ashton](https://forum.dynamobim.com/u/Joe.ashton)\ **Post date:** [February 3, 2023, 11:51am UTC](https://forum.dynamobim.com/t/import-data-from-excel-failed/85717/2 "2023-02-03T11:51:55Z")
Hi Azhar, this could be a range of issues, could you tell us the error on the two nodes? ---
**Author:** ![azhar.alikoya](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@azhar.alikoya](https://forum.dynamobim.com/u/azhar.alikoya)\ **Post date:** [February 3, 2023, 12:19pm UTC](https://forum.dynamobim.com/t/import-data-from-excel-failed/85717/3 "2023-02-03T12:19:05Z")
Hi joe, Thanks alot for the quick response. the error in two nodes is ‘‘The parameter’s storage type is not a number’’. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/4/d4033c3f79ece71546689d6322793bfdab0b7340.png) attched the screen shot of excel for your ease of understanding. ---
**Author:** ![Joe.ashton](https://avatars.discourse-cdn.com/v4/letter/j/7993a0/32.png) [@Joe.ashton](https://forum.dynamobim.com/u/Joe.ashton)\ **Post date:** [February 3, 2023, 1:06pm UTC](https://forum.dynamobim.com/t/import-data-from-excel-failed/85717/4 "2023-02-03T13:06:07Z")
Hi Azhar, each parameter has a datatype, only data of that type can be entered. E.g you can’t set “Bananas” to the offset parameter. You can check the datatype in dynamo using the object.type node. What that error is showing is that you are inputting the wrong type, the parameter storage is not a number. So you need to match the input to the datatype. For me the simplest place to check the parameter datatype is in Revit which the below link may help on. From that parameter name, I can imagine the datatype is a string, which you can use string from object mode to convert: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/e/5ec2f02533592490450fc2d74d876d244d137790.png) Some extra information of parameters and there datatypes: > **[Parameters | Revit 2020 | Autodesk Knowledge Network](https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2020/ENU/Revit-Model/files/GUID-D927E0DC-F720-4F7D-AACD-8B06787793CB-htm.html)** > > Parameters store and communicate information about all elements in a model. Parameters are used to define and modify elements, as well as to communicate model information in tags and schedules ---
**Author:** ![azhar.alikoya](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@azhar.alikoya](https://forum.dynamobim.com/u/azhar.alikoya)\ **Post date:** [February 6, 2023, 8:17am UTC](https://forum.dynamobim.com/t/import-data-from-excel-failed/85717/5 "2023-02-06T08:17:32Z")
Thanks Joe, that was the issue. In the shared parameter data type was set as text and i was trying to write value as number through dynamo. thanks for the quick response.