# Exporting a vector field to a csv file
**URL:** https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780
**Category:** ParaView Support
**Created:** [July 8, 2020, 10:23am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780 "2020-07-08T10:23:32Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 10:23am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/1 "2020-07-08T10:23:32Z")
Hello,
I have a field with 500 vectors and I would like to export the (X,Y,Z) of the vectors to a csv file.
pic of the vectors:
When i do File-\> Save Data -\> “file.csv”, I get a csv file that looks like this:
One problem is that the file has 15470 rows.
But the main problem is that the (X,Y,Z) beggining and ending aren’t the same as the data is Paraview.
what can I do to get the real points? Or maybe I am reading the data wrong in the CSV file?
I am uploading the csv file so whoever wants to give it a try is welcome.
Thank you, Ohad
[asd.csv](https://discourse.paraview.org/uploads/short-url/dGf01mk8PN9LGt9jPkaffLY17Ap.csv) (675.2 KB)
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [July 8, 2020, 11:13am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/2 "2020-07-08T11:13:09Z")
Are you exporting the results of the glyph filter ?
Can you share your original data ?
---
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 11:16am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/3 "2020-07-08T11:16:25Z")
Yes the glyph filter.
The files are huge (over 1gb), I can try and send you them if you want
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [July 8, 2020, 11:17am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/4 "2020-07-08T11:17:36Z")
You want to export the output of the reader, not the glyph filter.
---
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 11:21am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/5 "2020-07-08T11:21:35Z")
And how do I do that? I tried threw the python shell and it didn’t work
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [July 8, 2020, 11:24am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/6 "2020-07-08T11:24:23Z")
Please share a screenshot of ParaView (including the interface and pipeline browser) just before you export.
---
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 11:33am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/7 "2020-07-08T11:33:30Z")
This is the paraview screen.
This is an error I get when i try to export.
When i saved the data i did save data, not export
בתאריך יום ד׳, 8 ביולי 2020 ב-14:24 מאת Mathieu Westphal (Kitware) via ParaView \<[noreply@discourse.paraview.org](mailto:noreply@discourse.paraview.org)\>:
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [July 8, 2020, 11:36am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/8 "2020-07-08T11:36:06Z")
- Click on the extract subset filter in the pipeline browser
- File -\> SaveData -\> .csv -\> OK
- You csv file should be ok.
---
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 11:42am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/9 "2020-07-08T11:42:56Z")
I did it and I got a csv file with only 3 columns. How does this represent the vectors?
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [July 8, 2020, 11:44am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/10 "2020-07-08T11:44:52Z")
Hard to say. Please share you original file and what you are trying to achieve exactly.
---
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 11:50am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/11 "2020-07-08T11:50:41Z")
The original files are over 2gb and it will be hard for me to share them with you.
I have a raw file (.raw) from an experiment I have done. I loaded it in Paraview with a python script (I’ll share here) and i can see the vectors (in the image I sent).
My goal is to have a csv file with (x, y, z) beginning and ending or with an angel and length.
[glyphTrace.py](https://discourse.paraview.org/uploads/short-url/dEtvI4Ww1n1fHU4u9IWHTyOImkW.py) (51.9 KB)
---
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 11:52am UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/12 "2020-07-08T11:52:01Z")
[https://drive.google.com/drive/folders/1GfnFQNmBeK6KH7qiGwXNVXyY9HQ2aXid?usp=sharing](https://drive.google.com/drive/folders/1GfnFQNmBeK6KH7qiGwXNVXyY9HQ2aXid?usp=sharing)
the files i import (the raw file) is here
בתאריך יום ד׳, 8 ביולי 2020 ב-14:50 מאת Ohad Mishael \<[ohad.mishael@mail.huji.ac.il](mailto:ohad.mishael@mail.huji.ac.il)\>:
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [July 8, 2020, 12:22pm UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/13 "2020-07-08T12:22:20Z")
> My goal is to have a csv file with (x, y, z) beginning and ending or with an angel and length.
So here what you need to do :
- Open your file
- Extract the subset your are interested in using ExtractSubset, apply
- Add an AppendDataset filter, Apply
- Add a calculator filter to compute the angle of the vector, Apply
- Add a calculator filter to compute the length of the vector, Apply
- Add a PassArray filter to remove the arrays you are not interested in
- File → SaveData → csv
This should create the file you are looking for.
---
### Author:  [@ohad.mishael](https://discourse.paraview.org/u/ohad.mishael)
#### Post date: [July 8, 2020, 12:57pm UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/14 "2020-07-08T12:57:05Z")
I’m not sure what you mean when you say how to compute angle and length of vector
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [July 8, 2020, 12:59pm UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/15 "2020-07-08T12:59:36Z")
This is for you to define what you mean by that in your original message.
It may be something like that : [https://www.intmath.com/vectors/7-vectors-in-3d-space.php](https://www.intmath.com/vectors/7-vectors-in-3d-space.php)
---
### Author:  [@wascott](https://discourse.paraview.org/u/wascott)
#### Post date: [July 8, 2020, 4:28pm UTC](https://discourse.paraview.org/t/exporting-a-vector-field-to-a-csv-file/4780/16 "2020-07-08T16:28:14Z")
In the File -\> Save Data -\> csv -\> there is a Choose Arrays To Write option. Now, you get to output whatever you want. Thus, no need for the Pass Arrays filter.