Skip to main content
randi84
Dec 16, 2021 8:10 PM UTC
Solved

Exporting Description without trimming?

I'm trying to export my Item List to a CSV to get all of our Item Descriptions in a spreadsheet. When I get it to the CSV file the descriptions are trimmed to a limited characters ending with a (...). I'd like to export the entire description not limited to character count. Is there any way to do this? Thanks!

BigRedConsulting
BigRedConsultingAnswer
Dec 16, 2021 11:30 PM UTC

Exporting from a report will always have this limitation, same as the report.

 

However, you can export the Items list to an IIF file and then open that IIF file, which is a Tab-delimited file, in Excel. That export will include the entire contents of the description fields.

 

To do this, start at File | Utilities | Export | Lists to IIF files...

View in thread

5 replies

BigRedConsulting
BigRedConsultingAnswer
Dec 16, 2021 11:30 PM UTC

Exporting from a report will always have this limitation, same as the report.

 

However, you can export the Items list to an IIF file and then open that IIF file, which is a Tab-delimited file, in Excel. That export will include the entire contents of the description fields.

 

To do this, start at File | Utilities | Export | Lists to IIF files...

    randi84Author
    Dec 17, 2021 6:55 PM UTC

    Thanks, that helped me out a lot. 

      Terms & ConditionsAccessibility statement