Export and import in specific CSV or Excel forms

[WJae]

Hi guys,

I have some questions about formatting CSV files when exporting or importing. If anyone knows how to do this, please help me. Paid apps are also welcome. I know how to apply Excel formulas after exporting the file, but I want to automate the process and skip this step.

1. Merging Two Columns into One When Exporting a CSV File

   • I want to combine the values of two columns into a single cell when exporting a CSV file. For example, I want to merge the address from columns CL and CM into one cell, as shown in the attached image.
     

2. Creating Empty Columns in a CSV File

   • Is it possible to create empty columns when exporting a CSV file? I want to leave columns C, D, and E blank, as shown in the attached image.
     
     
     Thanks in advance.

[KennyAtBonify]

Hey @WJae 

I’d definitely recommend checking out the Arigato Workflow Automation. It’s a great tool for automatically exporting customer data to Google Sheets. With the Google Sheets integration, you can customize the data that gets sent, skip columns in the spreadsheet, and even merge shipping address details into a single cell for easier organization.. Please check out some of our Google Sheets workflow template on this page to see how it works

Feel free to drop us a line if you have any questions! 🙂