FAQ: How do I save my spreadsheet as a Comma Separated File (.CSV)?

FAQ: How do I save my spreadsheet as a Comma Separated File (.CSV)?

For Microsoft Excel:

  • Make certain you are on the first Sheet
  • Click File (or the Office Button) → Save As.
  • Change Save as type: “CSV (Comma delimited) (*.csv)”.
  • Enter “Customers” or "Products" etc. as a file name and save the file.
AlertPlease note: Microsoft Excel will occasionally save CSV files with empty/blank columns and rows - typically, if you've used them and deleted content. This will prevent your CSV from being ingested properly. Please ensure that only rows and columns that contain data in required fields are exported.

For Google Sheets

  • Make certain you are on the first Sheet
  • Click File → Download As
  • Select "Comma-Separated values (*.csv, current sheet)”
  • Enter “Customers.csv” or "Products.csv" etc as a file name and save the file.
AlertPlease note: Line breaks in data fields will break imports. Open up your CSV file with a text editor and validate that each entry is on a single line.

    • Related Articles

    • How to: Set up Direct Sales Products and Customers (UPDATED)

      UPDATED: Nov 23, 2023 DigThisData enables companies to manage and process orders for on-premise, licensee, and even grocery customers through the Direct Sales channel. Getting set up can take some effort, however once complete, DTD provides tools to ...

    • How to: Bulk ingest logistics delivery schedules

      To ingest logistics schedules in bulk, you'll need to download the provided spreadsheet templates, copy and paste data, save the file as a Comma Separated file, and upload to DigThisData. The following steps will accomplish ingesting your logistics ...

    • How To: Work with FIL for Delivery

      DigThisData offers a light integration with FIL Logistics to make processing orders faster and more efficient. To ingest logistics schedules in bulk, you'll need to download the provided spreadsheet templates, copy and paste data, save the file as a ...

    • How to: Configure sales rep territories and store details

      Configuring Stores For all account locations, you can define Sales Reps, Supply Warehouses, Low Inventory Thresholds (where applicable), Delivery Days, Cut Off Times, and more. To assign variables to a specific store, click on the edit icon to open ...

    • FAQ: Is there any integration with the LCBO DDVP [DEPRECATED]?

      DigThisData supports uploading CSV files downloaded from the LCBO DDVP (Direct Delivery Vendor Portal) AND automatically ingesting them using your credentials. Once ingested, the data included in the CSV file will be converted into individual ...