Import Stored Values from a file

[steveosb]

Hi
I'm hoping someone might be able to point me in the right direction regarding importing stored values from a csv file. I have a spreadsheet which contains a large number of stored values that I'd like to import into a horse race market. I've used the correct excel template but I am getting the 'cannot parse column x' error. I assume that this could be because the stored value is text rather than a number. Could that be the correct interpretation? If it is, is there a quick way in excel to embed cells containing text in "" so that they import correctly?
Best Regards

Steve

[ODPaul82]

=""""&A1&""""

[steveosb]

Many thanks - now sorted. Much appreciated.

[Alifeen84]

dinosaur game wrote: ↑
Hi
I'm hoping someone might be able to point me in the right direction regarding importing stored values from a csv file. I have a spreadsheet which contains a large number of stored values that I'd like to import into a horse race market. I've used the correct excel template but I am getting the 'cannot parse column x' error. I assume that this could be because the stored value is text rather than a number. Could that be the correct interpretation? If it is, is there a quick way in excel to embed cells containing text in "" so that they import correctly?
Best Regards

Steve

Yes, that’s very likely the issue. That error usually shows up when a column expects a number but gets text instead. If the values need to be treated as text, you can force Excel to wrap them in quotes pretty quickly using a formula (like =""""&A1&"""") or by exporting the CSV with text qualifiers enabled. Also double-check there are no stray spaces or formatting quirks in that column.

[jamesedwards]

dinosaur game wrote: ↑ SPAM BACKLINK HERE ← ← ← ←
Hi
I'm hoping someone might be able to point me in the right direction regarding importing stored values from a csv file. I have a spreadsheet which contains a large number of stored values that I'd like to import into a horse race market. I've used the correct excel template but I am getting the 'cannot parse column x' error. I assume that this could be because the stored value is text rather than a number. Could that be the correct interpretation? If it is, is there a quick way in excel to embed cells containing text in "" so that they import correctly?
Best Regards

Steve

Yes, that’s very likely the issue. That error usually shows up when a column expects a number but gets text instead. If the values need to be treated as text, you can force Excel to wrap them in quotes pretty quickly using a formula (like =""""&A1&"""") or by exporting the CSV with text qualifiers enabled. Also double-check there are no stray spaces or formatting quirks in that column.

z001.jpg