Exporting lists of records to CSV/XLS (and something to look out for)

[alan_lowrance]

Like the wiki says, there are three ways to export a list into a CSV/XLS format:

On-Demand

1. Right-click the top of a list you've already filtered and sorted how you like, and choose Export.
2. Get the URL for the query and add CSV or EXCEL after the "?" and an "&" before the sysparm_query: https://[instance name].service-now.com/incident_list.do?CSV&sysparm_query=[your_query]

On a Schedule

• Create it as a report and schedule it to run and generate an XLS instead of PDF.

HOWEVER, if you are exporting a multi-line string field such as Description, you will notice if the [Enter] key was used as line breaks or you have \n or \r in there, Excel appears to cut off everything after the first line break.   This is just the way Excel displays these and the data is still in the new file, you just have to advance the cursor past the last word in the cell and it will flip to the next line while staying in the same cell.   You can also page/tab through these lines by using the up and down arrows next to the formula bar in Excel.

Edit: Or just make the cell taller and it will put more than just the first line!   Excel is a lot smarter than you give it credit for sometimes.