Import of csv showing commas

Hi,

thanks for your post, and sorry for the trouble.

Can you post/upload your CSV file somewhere, so that I can check why it might not be importing?

TablePress tries to detect what the delimiter is, and it can detect encoded delimiters (for example, if the comma is the delimiter, cells that contain a comma should be wrapped in quotation marks).

Regards,
Tobias

https://Www.murraywiltonministries.otg/Session_1.csv

Sorry, ‘org’, not ‘otg’.

Hi,

even with “org”, I only get a 404 Not Found error for the URL https://www.murraywiltonministries.org/Session_1.csv ??

Regards,
Tobias

Please try it again.

Thank you.

Hi,

thanks! Now it works!

The problem here is that the last row (Session 21) does not have a comma after it. So, technically, this is an invalid CSV file. It should be

Session 1, Session 2
Session 3, Session 4
Session 5, Session 6
Session 7, Session 8
Session 9, Session 10
Session 11, Session 12
Session 13, Session 14
Session 15, Session 16
Session 17, Session 18
Session 19, Session 20
Session 21,

(Note the comma after Session 21.)

Regards,
Tobias

Hi again,

and you might want to remove the spaces after the comma, otherwise these will be part of the data in the second column. They will probably be invisible, but it’s better to remove them.

Regards,
Tobias

Another site: https://oldcookstove.com/wp/menu-items/

Import file is https://www.oldcookstove.com/Fried_Chicken.csv

It is comma delimited. See that it just creates a list of all items, not recognizing the columns.

Hi,

this file has the same problem. It’s not “rectangular”. The first couple rows only have one column (no commas as delimiters in those rows), while the following rows then have multiple columns (i.e. multiple commas as delimiters).

TablePress can only import CSV file that are rectangular, i.e. that have the same number of commas per row.

Regards,
Tobias

Thank you. Do you put a comma at the end of each line? If a column is empty, do you put ,, there?

Hi,

you will always have to put the same number of commas in each row, yes.
So, indeed, if a row of the table shall be empty, you just put commas there (one less than the number of columns).

Regards,
Tobias