# Apple's Numbers App to .CSV vs Table

**URL:** <https://forums.realmacsoftware.com/t/apples-numbers-app-to-csv-vs-table/57032>\
**Category:** Elements\
**Created:** [July 17, 2026, 11:53am UTC](https://forums.realmacsoftware.com/t/apples-numbers-app-to-csv-vs-table/57032 "2026-07-17T11:53:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![meonmac](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/meonmac/32/36720_2.png) [@meonmac](https://forums.realmacsoftware.com/u/meonmac)\
**Post date:** [July 17, 2026, 11:53am UTC](https://forums.realmacsoftware.com/t/apples-numbers-app-to-csv-vs-table/57032/1 "2026-07-17T11:53:04Z")

</div>

Is anybody using Apple Numbers as the source for their CSV Table? When I export a table from Pages as a .csv file and then drop it to the data source window, I get an error when previewing the page.

![Screenshot 2026-07-17 at 13.47.42](https://europe1.discourse-cdn.com/flex005/uploads/realmacsoftware1/original/3X/d/4/d4d674b757c00ce3a680e03ac45023e76556c7b3.png)

[TABLE TEST.csv](https://forums.realmacsoftware.com/uploads/short-url/dfuQJItzOh3RYeGzV9vodMvinnn.csv) (68 Bytes)

---

<div class="post-metadata">

**Author:** ![RussOggi255](https://avatars.discourse-cdn.com/v4/letter/r/ee7513/32.png) [@RussOggi255](https://forums.realmacsoftware.com/u/RussOggi255)\
**Post date:** [July 17, 2026, 11:55am UTC](https://forums.realmacsoftware.com/t/apples-numbers-app-to-csv-vs-table/57032/2 "2026-07-17T11:55:30Z")

</div>

They don’t look comma separated to me;

Company;Ticker;Weight  
APPLE;TST;10 %  
MELI;TST;10 %  
SE;TST;10 %

---

<div class="post-metadata">

**Author:** ![meonmac](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/meonmac/32/36720_2.png) [@meonmac](https://forums.realmacsoftware.com/u/meonmac)\
**Post date:** [July 17, 2026, 12:02pm UTC](https://forums.realmacsoftware.com/t/apples-numbers-app-to-csv-vs-table/57032/3 "2026-07-17T12:02:30Z")

</div>

Interesting, could be the language/region setting? Maybe. Its simple Excel table, I thought it gets transferred automatically.

EU Company;Ticker;Weight APPLE;TST;10 % MELI;TST;10 % SE;TST;10 %

US Company,Ticker,Weight APPLE,TST,10% MELI,TST,10% SE,TST,10%

---

<div class="post-metadata">

**Author:** ![Lalla](https://avatars.discourse-cdn.com/v4/letter/l/71c47a/32.png) [@Lalla](https://forums.realmacsoftware.com/u/Lalla)\
**Post date:** [July 17, 2026, 12:25pm UTC](https://forums.realmacsoftware.com/t/apples-numbers-app-to-csv-vs-table/57032/4 "2026-07-17T12:25:07Z")

</div>

As I understand it, comma-separated is the standard for CSV in the USA/UK. However, in most EU countries, it is a semicolon. This has to do with the number format in those countries.

Two possibilities:

- Create a comma-separated export instead of semicolon-separated.

- Or (much better 😉 ) ask RealMac if an option can be added to Elements to also be able to import a semicolon-separated CSV.

To create a comma-separated CSV with Numbers:  
In MacOS in System Settings go to “General \> Language & Region”. Change “Number format” to “1,234,567.89” (first option). Make your export to CSV and then change the System Setting back to “1.234.567,89”.

---

<div class="post-metadata">

**Author:** ![meonmac](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/meonmac/32/36720_2.png) [@meonmac](https://forums.realmacsoftware.com/u/meonmac)\
**Post date:** [July 17, 2026, 12:29pm UTC](https://forums.realmacsoftware.com/t/apples-numbers-app-to-csv-vs-table/57032/5 "2026-07-17T12:29:38Z")

</div>

Yes, thats what I think is happening. The conversion is fast, I just was not expecting this drag and drop function not to work. The workaround is fast, so all is good but I am not using anything complicated like live data updates.