Skip to main content

CSV Import Errors Explained: PDF, Excel, Image, and UTF-16 Files

· 4 min read
Score7 Team
Score7 Team

The most common reason a CSV import fails isn't a formatting issue inside the CSV — it's that the file isn't a CSV at all. Score7 now spots a PDF, an Excel spreadsheet, or an image instantly and tells you exactly what to do next.

What changed​

Score7's import dialog used to attempt to parse anything you dropped on it, then surface a generic "the CSV file could not be read" message when parsing failed. That message was misleading — there are no unmatched quotes inside a PDF.

Now Score7 looks at the actual contents of the file (not just the extension) and, if it recognises the upload as something other than a CSV, returns a specific message before it even tries to parse. No more converting your file just to find out you sent the wrong one.

The error messages, decoded​

Here's what each rejection means and the quickest path to a working CSV.

"This file looks like a PDF"​

You probably exported a tournament report, a participant list, or a federation document as PDF from somewhere else. Score7 can't read structured data out of a PDF.

Fix: find the source spreadsheet, open it, and:

File > Save As > CSV

If you only have the PDF, you'll need to retype the data into a fresh spreadsheet first.

"This file looks like a spreadsheet"​

This covers Excel .xlsx, OpenDocument .ods, Numbers files, and any other ZIP-based spreadsheet container.

Fix: open the file, then:

File > Save As > CSV (comma delimited)

In Excel installations outside English, the option is sometimes labelled CSV UTF-8 or CSV (Macintosh) — any of those work.

"This file looks like an older Excel file"​

The legacy .xls format (pre-2007). Same fix:

File > Save As > CSV

"This file looks like an image"​

PNG, JPEG, or GIF. There's no shortcut here — the data isn't machine-readable from a picture.

Fix: retype the names into a spreadsheet, then File > Save As > CSV.

"Score7 can't read this CSV's text encoding"​

Your file is saved in UTF-16 (this happens when some apps export "Unicode Text"). Score7 reads UTF-8.

Fix: in Excel, choose Save As and pick CSV UTF-8 specifically (not plain CSV).

Empty file​

Your upload was 0 bytes — likely a download that didn't complete, or a save that didn't finish. Re-export from the source and try again.

Why renaming the file doesn't help​

A common workaround is to rename report.pdf to report.csv and re-upload. Score7 reads the actual bytes inside the file, not the extension — the rejection still fires.

This is a feature, not a limitation: a renamed PDF would have produced a confusing parse error before. Now it produces an exact diagnosis with a one-step fix.

Why we show you the filename​

The message includes the name of the file you uploaded. When you've juggled Book1.csv, participants.csv, and participants_FINAL.csv between your desktop and Downloads folder, knowing exactly which one Score7 received is half the diagnosis. The filename is sanitised before being shown back to you, so even a very long name or a filename with unusual characters can't break the dialog layout.

What didn't change​

  • The Import button location is the same (Participants page for teams, Schedule page for round-robin schedule imports).
  • Successful uploads still import as before — no extra confirmation step, no new requirements on the CSV format itself.
  • If your file IS a CSV but has formatting issues inside (mismatched columns, missing headers, wrong separator), you'll see the existing line-by-line validation messages — those didn't change.

Common scenarios​

"I have a tournament from last year exported as PDF — how do I re-import the participants?" Find the original spreadsheet or retype the names; Score7 can't extract data from PDF. If you ran the original tournament in Score7, use the Premium Import from Tournament feature instead — no PDF needed.

"My federation sent me an Excel attachment — can I upload it directly?" No. Open it in Excel and Save As > CSV first, then upload the CSV.

"I'm on Google Sheets, not Excel — does the same guidance apply?" Yes. In Google Sheets: File > Download > Comma Separated Values (.csv). Numbers, LibreOffice, OnlyOffice — every spreadsheet app has a CSV export option in the same neighbourhood of the File menu.

For the full CSV import walkthrough including the round-robin schedule format, see the Import or Export Participants via CSV guide.

Ready to try the import again? Open your tournament and go to the Participants page.

Next steps in Score7