# Read excel sheet
**URL:** https://discourse.nodered.org/t/read-excel-sheet/50619
**Category:** Dashboard
**Created:** [4 September 2021 20:34 UTC](https://discourse.nodered.org/t/read-excel-sheet/50619 "2021-09-04T20:34:14Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Ino](https://discourse.nodered.org/u/Ino)
#### Post date: [4 September 2021 20:34 UTC](https://discourse.nodered.org/t/read-excel-sheet/50619/1 "2021-09-04T20:34:15Z")
I placed GPS position data in an excel spreadsheet (.xls) and I want to restore that data for reconstruction of my route (incl. speed and heading) over the water in one day. I saved that data every 10 minutes and that works fine. When I want to read thsi data I use the next function in a function node.
input=msg.payload.A2.w;
global.set ("log\_datum\_2",input );
msg.payload=input;
return msg;
This works fine too, but...when i want to restore all data I have to use a lot of function nodes, so I want to set (in this case) A2 as a variable. I tried several things without succes.
Someone a tip?
thanks in advantage
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [4 September 2021 20:50 UTC](https://discourse.nodered.org/t/read-excel-sheet/50619/2 "2021-09-04T20:50:34Z")
Are you storing it in Excel for a particular reason? If not then it is generally better to store it in a database such as influxdb which is explicitly designed for saving time series data.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [4 October 2021 20:51 UTC](https://discourse.nodered.org/t/read-excel-sheet/50619/3 "2021-10-04T20:51:05Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.