Chat with us, powered by LiveChat

Why when I download data to Excel columns are not formatted?

CVS files generated by Onpipeline are comma separated, according to the standard

If you open the CSV file in Excel and the data is not formatted automatically (all data loaded in the first column), it means your O.S. default “list separator” is a semicolon or a tab.

You have 2 options to solve this:

– If you want to properly read the CSV every time you open the file with Excel, you can change the default list separator to a comma (,) in your O.S. system preferences. It depends on your O.S. but normally you can find this in “Regional and Language Options”.

– You can import the file by using the “Text Import Wizard”. Open Excel and go to the Data tab > Get External Data > From Text. Additional information can be found here:


Onpipeline is a great sales CRM to build and visually manage your sales pipeline, get and organize Leads from 3rd parties through web forms and API, and much more.