1. Jerry Thomas
  2. Sherlock Holmes
  3. General
  4. Tuesday, 19 July 2016
  5.  Subscribe via email
When I double-click on a .csv file, it is opened in Excel. The csv-files have columns delimited with semicolons (not commas, but also a valid format).

Using a German Windows/Excel setup, the opened file is displayed correctly, the columns are separated where the semicolons existed in the csv-file. But when I do the same on an (US-) English Windows/Excel setup, only one column is imported, showing the whole data including the semicolons in the first column.

You can change the CSV separator in Matukio>configuration>setting>advanced>CSV Separator BUT this does not change the system fields 'Booking number';'Event title';'Booked places' which still have ; (semi colons).

Workaround -
1. Rename the file .txt and import into Excel
2. Add this on the first line of the CSV file: sep=; or sep=, This will override system setting ("list separator character";) and Excel will open the file correctly.

Most users will not know or want to do this, making CSV files useless for US customers.
Responses (2)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Hotspots Pro 6.0.13 compatability with Joomla 5.3.
Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
2 Replies
Posted on Friday, 04 July 2025
some questions on Hotspots
Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
0 Replies
Posted on Thursday, 03 July 2025
Trying to resize the image in the comments
Hey everyone, Basically I am trying to make the images in the comments smalle...
9 Replies
Posted on Wednesday, 12 August 2009
J5 compatibility for Hotspots
Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
2 Replies
Posted on Monday, 24 February 2025
  • #Hotspots
  • #hotspots Joomla 5
error message when adding/cofiguring email address
When configuring the email plugin that send a email message to admin when a new ...
0 Replies
Posted on Friday, 09 May 2025