Articles on: Troubleshooting

I can’t open Findymail’s exported CSV files

In some regions (Europe for example) Excel files downloaded from the Findymail in the format .CSV (comma delimited) will not open correctly and the data within will be displayed incorrectly.

This is due to regional Excel settings that have default list separator options where files will either be read with a comma separator or semicolon separator. In Europe, the default is for the semicolon to be a delimiter instead of a comma.

Fix file formatting in Excel



If the data is present in a single column, please do this:

Select the cell or column that contains the text you want to split.
Select Data > Text to Columns.
In the Convert Text to Columns Wizard, select Delimited > Next.
Select the Delimiters for your data. For Findymail data, please select Comma. You can see a preview of your data in the Data preview window.
Select Next.
Select the Destination in your worksheet which is where you want the split data to appear.
Select Finish.

This is described on video here.

Convert .CSV files to .XLSX for Microsoft Excel



If you want to convert your Findymail CSV file to a XLSX Excel files, you can follow the following method: https://app.tango.us/app/workflow/Convert-CSV-file-to-XLSX-Excel-file-75bbb24f85b140d0b5081828f26600a2

Updated on: 24/05/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!