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
Import Stored Values from a file
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.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