Overview
Pacejet employs the use of .csv (comma separated value) files for Bulk Importing/Exporting and Freight Audit Imports, and for certain use cases in User Accounts.
Opening .csv files in programs like Microsoft Excel can change how the data is structured, or, worse, corrupt the file. This article discusses some helpful tips for opening .csv files for editing.
Before Opening Your .csv File
Before you open a .csv file, consider taking these steps.
Make a backup copy of your .csv file before importing it.
Understand how your program of choice may affect .csv files.
Consider using a text editor like Notepad or Notepad++.
How To Open .csv Files In Excel Safely
The directions below show you how to import files in Excel 2005. Other versions of Excel will likely have different directions. But the premise is the same:
Do not open it with File, Open. Instead Import the document.
Do not save normally. Instead save it as a csv file.
Open a new Excel sheet, select the Data tab, then click From Text/CSV .
Browse to the desired .csv file and select Import.
Select the Writing System that was used in the original .csv file. Many times, the correct writing system is selected by default.
Select Comma as the delimiter.
Select Load to import your data.
Your data opens.
Changing and Saving Your Data
Once you have made changes to your data, DO NOT CLICK SAVE as you normally would. This may have unintended consequences on the integrity of your data. Instead follow the steps below.
Click File, Save As.
Select Browse.
Select the desired location for your file.
Select CSV (MS-DOS) as the file type from the drop-down menu.
Click Save.
Click OK to the confirmation message.
Your .csv file is saved and ready for importing.