Commas in my CSV export/report are effecting my data format and order

Commas in any of your text fields are no problem in a CSV export. In your Report Templates just surround your data tags with double quotes to tell Excel to keep everything between the double quotes in one column even if it has commas. Please see our CSV export sample report for how your report should be. Or better, use our sample and just modify it rather than creating your own.


Bad example of report tags not enclosed...

SI-E-Title,SI-E-Notes...


Good example of report tags that are enclosed and safe if the data may contain commas...

''SI-E-Title'',''SI-E-Notes''...
Last updated on Mar 8, 2017
Schedule it Ltd
/faq/10700/commas-in-my-csv-export-report-are-effecting-my-data-format-and-order

Subscribe to our newsletter and receive our free scheduling tips and articles to help you improve the planning in your business. Unsubscribe anytime.

GET STARTED RESOURCES
Login Support and Help
Register Blog
Features Privacy Policy
Online Pricing Terms and Conditions
On-Prem Pricing Industry Sectors
Latest Version Reviews and Feedback
APPS POPULAR SEARCHES
Web App Team Scheduling
iOS App Employee Planning
Android App Customer Scheduling
Zapier App Engineer Scheduling


Start Your Free Trial Today



Copyright © 2003-2020 Schedule it Ltd. All rights reserved.
Schedule it on LinkedIn   Schedule it on Twitter   Schedule it on YouTube   Schedule it on Facebook