Initial Data Import
      Back to home
      1. Help Center
      2. Getting Started
      3. Initial Data Import

      Preparing the CSV import files with UTF-8 encoding

      Steps for preparing an import file in CSV format with UTF-8 encoding and ensuring the correct encoding when exporting it for import into Zapfloor.

      To ensure successful importing of CSV files into Zapfloor, it is crucial to use the correct encoding. When exporting a CSV file, it is recommended to follow specific steps for different platforms to set the encoding to UTF-8. This encoding ensures that the file format is compatible with Zapfloor and prevents any errors during the import process.

      For Windows users, you can open the CSV file in Notepad and save it with UTF-8 encoding. In Microsoft Excel, you can select the CSV UTF-8 (Comma delimited) option when saving the file. If you are using macOS and Numbers, choose Unicode (UTF-8) from the Text Encoding options when exporting the CSV file.

      If you get an error on you import, a good place to start is check if there are any additional comma's in your file. You can open the file in Excel or Numbers and use Find and Replace to take out any commas from your import file (as commas do not work in this kind of file type.)

      Then you can follow up, in case there's still an error, with these steps:

      UTF-8 Encoding in Notepad (Windows)

      1. Open your CSV file in Notepad.

      2. Click File in the top-left corner of your screen.

      3. Click Save as...

      4. In the dialog which appears, select the following options:

        • In the "Save as type" drop-down, select All Files.

        • In the "Encoding" drop-down, select UTF-8.

        • Rename your file using the .csv extension (Example: myproject.csv).

      5. Click Save.

      UTF-8 Encoding in Microsoft Excel (Windows)

      1. Open your CSV file in Microsoft Excel.

      2. Click File in the top-left corner of your screen.

      3. Select Save as...

      4. Click the drop-down menu next to File format.

      5. Select CSV UTF-8 (Comma delimited) (.csv) from the drop-down menu.

      6. Click Save.

      UTF-8 Encoding in Numbers (macOS)

      1. Open your CSV file in Numbers.

      2. Click File in the top-left corner of your screen.

      3. Select Export to... -> CSV...

      4. Click Advanced options.

      5. Click the drop-down menu next to Text Encoding.

      6. Select Unicode (UTF-8).

      7. Click Next

      8. Choose a name and location for your new file and click Save.