# Exporting data correctly in excel **URL:** \ **Category:** General Questions\ **Created:** [October 14, 2022, 2:58pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452 "2022-10-14T14:58:05Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Matt\_28](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@Matt\_28](https://prepomax.discourse.group/u/Matt_28)\ **Post date:** [October 14, 2022, 2:58pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/1 "2022-10-14T14:58:05Z")
Good morning, I’m trying to export the displacements of a surface to excel, in order to make some calculation. I created a node set of the surface, and the reuslts are displayed in a ‘’.dat’’ file. But, if I copy and paste these values in excel, they are all on the same cell. Then, I tried, by using results → history outputs → create; so, I selected ‘‘ALL’’ (because I need the total value, not the components) and then selected the surface. But I get only 100 nodes, I need all the nodes in the surface selected. If I use that second method, the values are stored correctly in excel, but I need all the node values. Is there a way to get what I need? Thank you. ---
**Author:** ![FEAnalyst](https://yyz2.discourse-cdn.com/free1/user_avatar/prepomax.discourse.group/feanalyst/32/688_2.png) [@FEAnalyst](https://prepomax.discourse.group/u/FEAnalyst)\ **Post date:** [October 14, 2022, 3:38pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/2 "2022-10-14T15:38:58Z")
> [@Matt\_28](#): > > But, if I copy and paste these values in excel, they are all on the same cell. In Excel you can set some data import options including custom separators. If you do it properly, the outputs should be placed in individual cells. ---
**Author:** ![Matt\_28](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@Matt\_28](https://prepomax.discourse.group/u/Matt_28)\ **Post date:** [October 14, 2022, 3:55pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/3 "2022-10-14T15:55:12Z")
I tried, it worked, but all the -1,8E-02 are transformed in -1,8E+02 ---
**Author:** ![FEAnalyst](https://yyz2.discourse-cdn.com/free1/user_avatar/prepomax.discourse.group/feanalyst/32/688_2.png) [@FEAnalyst](https://prepomax.discourse.group/u/FEAnalyst)\ **Post date:** [October 14, 2022, 4:12pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/4 "2022-10-14T16:12:28Z")
That’s strange. Maybe try finding and replacing all occurances of E-02 with e.g. 10^-2. ---
**Author:** ![Matt\_28](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@Matt\_28](https://prepomax.discourse.group/u/Matt_28)\ **Post date:** [October 14, 2022, 4:18pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/5 "2022-10-14T16:18:31Z")
But I have around thousands of rows, is there a fast way for doing it? ---
**Author:** ![FEAnalyst](https://yyz2.discourse-cdn.com/free1/user_avatar/prepomax.discourse.group/feanalyst/32/688_2.png) [@FEAnalyst](https://prepomax.discourse.group/u/FEAnalyst)\ **Post date:** [October 14, 2022, 4:31pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/6 "2022-10-14T16:31:43Z")
In both Excel and text editors (including Notepad) there is a Search and Replace tool that can do this for all entries. ---
**Author:** ![Matt\_28](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@Matt\_28](https://prepomax.discourse.group/u/Matt_28)\ **Post date:** [October 14, 2022, 4:37pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/7 "2022-10-14T16:37:45Z")
I tried but doesn’t work with the ‘‘E+’’ of numbers ---
**Author:** ![ANYS](https://yyz2.discourse-cdn.com/free1/user_avatar/prepomax.discourse.group/anys/32/7737_2.png) [@ANYS](https://prepomax.discourse.group/u/ANYS)\ **Post date:** [October 14, 2022, 4:58pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/8 "2022-10-14T16:58:20Z")
> [@Matt\_28](#): > > I tried, it worked, but all the -1,8E-02 are transformed in -1,8E+02 ¿Don’t you mean -1.8E-02 are transformed in -1,8E+02?. Notice the point and coma difference. \*.Dat files use “.” and your Excel might be using Commas as decimal separator. In Excel you need to use “split into columns”. > **[Split text into different columns with the Convert Text to Columns Wizard -...](https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7)** > > Learn how to take the text in one or more cells, and split it out across multiple cells by using Excel functions. This is called parsing, and is the opposite of concatenate. Watch more in this video. ---
**Author:** ![Matt\_28](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@Matt\_28](https://prepomax.discourse.group/u/Matt_28)\ **Post date:** [October 14, 2022, 5:02pm UTC](https://prepomax.discourse.group/t/exporting-data-correctly-in-excel/452/9 "2022-10-14T17:02:48Z")
You’re right, I didn’t notice it, now it works because I set ‘’.‘’ into ‘’,‘’ in the conversion window. Thank you a lot.