When I import a TSV file (data included) via the online import tool, seems the tab delimiters are ignored

[daniel.f.lim]

When I import a TSV file (data below) using the online import tool the three fields are treated as a single field: “ID Name Label”. Why is this happening. I don’t have issues with any of my other TSV files.

I noticed that all my tabs are replaced with spaces in the actual post and because I’m new I can’t attach the actual file. This is frustrating - can someone help?

=====

ID Name Label
K.CC.1 Count to 100 by ones and by tens. Standard
K.CC.2 Count forward and backward beginning from a given number within the known sequence (instead of having to begin at 1). Standard
K.CC.3 Write numbers from 0 to 20. Represent a number of objects with a written numeral 0-20 (with 0 representing a count of no objects). Standard
K.CC.4 Understand the relationship between numbers and quantities; connect counting to cardinality. Standard
K.CC.6 Identify whether the number of objects in one group is greater than, less than, or equal to the number of objects in another group, e.g., by using matching and counting strategies. Standard
K.CC.7 Compare two numbers between 1 and 10 presented as written numerals. Standard
K.OA.1 Represent addition and subtraction with objects, fingers, mental images, drawings, sounds (e.g., claps), acting out situations, verbal explanations, expressions, or equations. Standard
K.OA.2 Solve addition and subtraction word problems, and add and subtract within 10, e.g., by using objects or drawings to represent the problem. Standard
K.OA.4 For any number from 1 to 9, find the number that makes 10 when added to the given number, e.g., by using objects or drawings, and record the answer with a drawing or equation. Standard
K.OA.5 Fluently add and subtract within 5. Standard

[jeremy.adams]

Hi Daniel,
I had the same issue with this file, BUT I found that if I removed ALL of the comma characters, then the TSV imported worked! I’ll share this bug with the team.

It also worked to “escape” the comma chars like \, but they ended up in the property like that

Problematic commas

3 columns treated as 1 column

[lizeth.botsford1]

Hi Daniel,

This usually happens when the import tool doesn’t properly detect tab delimiters and instead treats them as regular spaces. A couple of things you can try:

• Make sure the file is saved explicitly as TSV (Tab-Separated Values) and not CSV or plain text.

• Try opening the file in a text editor (like Notepad++ or VS Code) and confirm that the separators are actual tab characters, not spaces.

• Some tools also require manually selecting tab as the delimiter during import.

For handling structured data and exports, tools like arceus ios can give useful ideas about managing and formatting data properly before importing, which may help avoid similar issues.

Hope this helps, let us know if the issue persists!