Can't load CSV files from Excel

Bug Reports
1

Steps causing the bug to occur

  1. Make table in Excel
  2. Export as either of the following: CSV, CSV-UTF8, Tab separated TXT, Macintosh CSV, MS-DOS CSV
  3. Fetch table in Vuo
  4. No items in table

Have you found a workaround?

No

Other notes

  • Vuo version: 2.4.0
  • macOS version: macOS 11
  • CPU: x86_64
  • How severely does this bug affect you? It prevents me from completing a specific task with Vuo.
2

Have you tried exporting a CSV from Numbers.app? Same thing (on Norwegian macOS install)?

3

The problem is that Fetch Table only handles commas and tabs as separators. If, based on your region settings, Excel is using a comma for the decimal point, then exported CSVs will use a semicolon as the column separator.

Thanks for reporting this bug, @MartinusMagneson. We’ll modify Fetch Table (and Make Table from Text and Format Table) to correctly handle this case.

If you have the option to format the file differently when exporting from Excel, that would be one workaround. Or you could do a quick-and-dirty search-and-replace as in the attached composition (which wouldn’t correctly handle quoted/escaped separators).

Fetch_Table_-_Replace_Text.vuo (1.67 KB)

1 Like
4

In Vuo 2.4.1 we updated the Fetch Table and Make Table from Text nodes to handle CSV files with either commas or semicolons as separators. For details, see the documentation for those nodes.

1 Like