Did it still not work with that format?
If not, would you mind sharing your XLSForm and the updated and fixed CSV file again with the community? The community should be able to help you out.
@Victorpaisano25, you are with the same CSV structure:
Change your CSV structure as shown in the image below:
How do I do that
Maybe you will need to do some Excel search for this.
I already converted it and it still doesn’t work
@Victorpaisano25, you should be able to achieve the desired format by following the instructions as outlined in the steps shared below:
Open the CSV file. You should see your CSV file in the following structure:
Select the column that contains the data.
Text to Columns data tool from the
By default, you will see
Delimited being selected. Now press
Semicolon and press
In some cases, you may also need to select
Tab along with the
Semicolon if the data has line breaks in it.
Now you will see
General being selected. You could simply press
You should now get a dialogue box as shown in the image below. Simply press
Your CSV is now as shown in the following structure:
PDPesaje.csv (312.5 KB)
Thanks but it still doesn’t work
@Victorpaisano25, could you share with the community a screenshot of what is not working now?