Hi @evgenys   First things, first... This is frustrating situation to find yourself in. Everyone who has participated in this thread has experienced it. We feel your pain.   TL;DR Best advice: Get the official file format and data details from the producer/creator of the file.   Now, for a nonsensical philosophical discussion.    When I have to do things like this I ask myself a series of questions. The first two questions are the most important. The answer to them will dictate whether I ask the other questions.     What's the cost of being wrong? If this data is really important then figuring out the format on your own is a bad idea because being wrong is expensive. In other words: the creator/producer of the data has responsibility for ACCURATELY describing it.   If the data isn't critical you can use this as a learning exercise but it isn't a really great learning exericise.   Is this a one time exercise or is it going to be repeated? If it needs to be a repeatable process how often will it run? If this is a one-time exercise then running guessrows on the entire file may not be a huge deal. Start the job before you go to lunch or leave for the day.   If this is for a production job, you want a real, stable, description of the file layout.    Pro Tip: if it takes your machine a long time to run this job, use this as justification for a new, awesome, computer.   Where does the data originate? If the data comes from a database a DBA can point you to the SQL (Data Definition Language (DDL) that was used to create the table). Using this, I know the longest possible length of the character strings.   If the data is something someone threw together it may be a good idea to ask them how they are doing it. Perhaps they can provide the length of the strings.   Others have pointed-out that we should always ask the source of the data (person or machine) for the file layout and column length information. It is solid advice. In fact, I believe this is the best advice you could be given. As you can tell from the comments, it is very frustrating to be asked to read in a file that you know nothing about.     How big is this CSV file (KB, MB, GB)? 4 million rows is not a lot these days. For example, when I am experimenting with database loads I will typically use 10 to 20 million rows. My desktop PC handles this with no problem even when I am loading data into cloud databases. That being said, if the file is huge (many GB) it could take some time to process which leads to the next question.   Can I subset the file in so that my chances of finding the longest text fields increases? If may be possible to sort the file so the longest records appear at the top. This could help you figure-out the max length of the character fields.     Does anyone know something that can help me? This is a variant of the first question. You may have a co-worker who has read the file before and can help you.   I know this isn't what you are after but I think it is the only real answer. Anyone who has been through this can identify with it. It is frustrating.   Best wishes, Jeff   ... View more