How to import data from excel to an arduino sketch

I am trying to import a column of numbers from Excel into an array in an Arduino sketch. There are many posts on how to export from Arduino to excel but no one seems to deal with importing data to Arduino sketches from Excel.

I only need to do this as an editing task not as a real-time data transfer,

I only need to do this as an editing task not as a real-time data transfer,

It sounds like a bit of cunning editing with a decent editor (not the IDE editor) could do the job.

Have you got an example of the Excel data ? Saving it as a CSV file or copy/paste would seem like the obvious way to start.

NetDevil has given us a present with this:

2016-12-06_17-00-55.png

As you can see cell ‘D1’ is being read by the Arduino where it could be sent to a variable.

Serial.println("CELL,GET,D1,");
delay(10);
int  cell_num = Serial.parseInt();

.

try this if your data is just a fairly simple CSV file:

const int my_data = {
#include "datafile.csv"
};

this 'cheat' doesn't really require any 'real' editing.
you might have to whack out an extraneous last comma from the csv file.