Forum Message

Exporting Full Customer Address to CSV

I want to export all my customers to a csv file but I only get the first line of the billing address. Is it possible to export the whole address?


Posted by Peter Swettenham on Jan 26, 2024 11:11 PM GMT

Hi Peter,

The CSV file includes the full customer address including multiple lines.
However, Microsoft Word only shows the first line by default. To show more
than the first line, increase the height of the row by dragging the row
separator down.

Alternatively you can import the CSV file into Google Sheets which shows
the full address by default.


Posted by Solar Accounts Customer Support on Jan 29, 2024 9:53 AM GMT

Mark,

Thanks for getting back to me.

I needed the address on one line in order to import it into another program. I achieved it as follows:

Press Ctrl+H to activate the Replace dialog.
Click in the 'Find what' box and press Ctrl+J. This inserts an (invisible) line break.
Click in the 'Replace with' box and enter a comma or semicolon (, or ;).
Click Replace or Replace All.

Regards

Peter


Posted by Peter Swettenham on Jan 29, 2024 11:26 AM GMT

Hi Peter,

OK glad to hear you have resolved the issue by using the Replace All
feature.


Posted by Solar Accounts Customer Support on Jan 30, 2024 11:01 AM GMT