Skip to main content
All CollectionsInventoryInventory Export & Import
Transform Your .CSV Export to Columns
Transform Your .CSV Export to Columns

Learn How to Format Your .CSV Export into Columns Using Spreadsheet Software

Updated over a week ago

CSV files are a flexible and widely used format for transferring data between different applications that might not otherwise be compatible. By transforming a .CSV export into columns, you can enhance readability and make it easier to manage your data in your preferred spreadsheet software.

Transforming a .CSV Export with Microsoft Excel

  1. Open the .CSV File: Right-click the downlaoded .CSV file and choose to open it with Microsoft Excel.

  2. Prepare to Split Text:

    • Select the cell or column that contains the text you want to split, typically Column A.

    • Navigate to Data > Text to Columns.

  3. Configure the Wizard:

    • In the Convert Text to Columns Wizard, select Delimited > Next.

    • Choose the delimiters, in TWICE, typically Commas are used as separators in .CSV files. The Data preview window will show how your data will appear > Next

    • Choose where you want the new columns to appear by selecting the Destination in your worksheet.

    • Click Finish to see your data organized into separate columns.

Transforming a .CSV Export with Google Sheets

  1. Start a New Google Sheet:

    • Open Google Sheets and start a new document.

    • Go to File > Import and choose your downloaded .CSV file.

  2. Import Settings:

    • In the Import file window, select your import location and separator type. In TWICE, typically Commas are used as separators in .CSV files. Decide whether you want text converted to numbers, dates, and formulas.

    • Click Import data.

  3. Adjust Columns if Needed:

    • If some data does not display correctly, highlight the affected cells.

    • Go to Data > Split text to columns to manually adjust them.

Did this answer your question?