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 https://www.ietf.org/rfc/rfc4180.txt.

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: https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857

 

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.
TRY IT FREE